what's wrong with this syntax?

[miocene2]

$result2 = mysql_query("SELECT * FROM userpayments WHERE userid = $userid[$k] ORDER BY id ASC");

I suspect it's something to do with the userid = $userid[$k] bit but not sure what the correct suntax is.

Can someone help me out?? Cheers

 

[Twinkie]

It has to be like this:

$result2 = mysql_query("SELECT * FROM userpayments WHERE userid = {$userid[$k]} ORDER BY id ASC");

Other than simple variable calls, curly braces are needed.

 

[miocene2]

Thanks. Got another prob now:

using this code:

$result2 = mysql_query("SELECT * FROM userpayments WHERE userid = {$userid[$k]} AND paymentid = $payid ORDER BY paymentid ASC");
while($row2 = mysql_fetch_array($result2))

Gives me this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/miocene1/public_html/includes/getdata.php on line 52

Edit: Nevermind got one of my column names wrong

 

[Twinkie]

That would be because the mysql query is coming back with no results. You will have to go into PHPmyAdmin and see what wrong. Or, you can post whats in those variables (what the query resolves to, $userid, and page link), and the mysql database entry you are trying to find here as well as the table structure. To me, the first one is easier

 

[miocene2]

Thanks all sorted now!

 

[erhalo]

This helped me also thank you