mySQL

[James Smith]

can i use variables in mySQL requests ? I get a mySQL error when i use this in my PHP :

<BLOCKQUOTE><font size="1" face="Verdana, Arial">code/font><HR><pre>
$result2 = mysql_query(
"SELECT reviewtext FROM lps where ID=$row[id]");
if (!$result2) {
echo("&lt;P&gt;Error performing query: " .
mysql_error() . "&lt;/P&gt;");
exit();
}
[/code]

cheers
-j

[qslack]

What is the error you got?

There are thousands of possible errors...so we need to know a bit more to help you.

But yes you can use PHP variables in mySQL queries.

[James Smith]

its OK, I've sorted it out now. thanks for the reply anyway.

[qslack]

Sure, no problem. It would've been nice to help someone though.

Anyways good luck with PHP and mySQL and I'll try to help you faster next time