Not valid My-SQL?

[rapmonkey]

For some reason when I run my script, I get this error:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/t/a/tattwo/public_html/gbx/testing/viewmain.php on line 26

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/t/a/tattwo/public_html/gbx/testing/viewmain.php on line 28

Line 26 of the code is:

$categories = mysql_query("SELECT * FROM " . $prefix . "categories ORDER BY catorder", $connection);

And line 28 of the code is:

while ($row = mysql_fetch_assoc($categories)) {

I can't figure out what's wrong. 🙁 I'd really appreciate any help I can get. 🙂

[ptbsG_Man]

do it like this

mysql_query("SELECT * FROM '$prefix' categories ORDER BY catorder", $connection);

i use an access DB and call it diferent but the SQL should be the same

hope that helps

[autumn]

try this instead:

$query = "SELECT * FROM  $prefixcategories ORDER BY catorder"; 

$categories = mysql_query($query, $connection);

a lot harder to make mistakes this way.

A

[Weedpacket]

Originally posted by autumn
try this instead:

$query = "SELECT * FROM  $prefixcategories ORDER BY catorder"; 

$categories = mysql_query($query, $connection);

a lot harder to make mistakes this way.

A [/B]

Except that won't work (where does the variable $prefixcategories come from?)

But the error message is saying that the $connection is bad, not that the query contains any error.

What happens if you just say mysql_query("SELECT...")?