MySQL / PHP problem, can someone help?
Posted 04 July 2006 - 09:04 PM
$result = mysql_query("SELECT spic, name FROM $tb1 LIMIT $at, 1 WHERE cat1 = '$cat' OR cat2 = '$cat' OR cat3 = '$cat'",$db) or die(mysql_error());
And this is the error I am getting:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE cat1 = '116' OR cat2 = '116' OR cat3 = '116'' at line 1
If I take out the LIMIT portion, it works fine, so I assume it has something to di with how, or where I added it. If someone could help, that would be just great, thanks for your time!
Posted 04 July 2006 - 09:15 PM
Disclaimer: Free advice is usually worth what you paid for it. ( or at least when it's coming from me! )
Posted 04 July 2006 - 09:37 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users