Posted: Sat Aug 12, 2006 11:22 am
To clarify
Code: Select all
$result = mysql_query($query) or die(mysql_error());A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
$result = mysql_query($query) or die(mysql_error());This error usually happens when: you have not conected to the server, you have not chosen a database, or when there is a syntax error in your query to the database. Use d11wtq's advice and add or die(mysql_error());. However if your using the same code as in the other server, most likely there is a problem with your database or configuration of your new server.not a valid MySQL result resource
Code: Select all
$sql = "SELECT * FROM pixels WHERE viewable= 'Y' AND adult = 'N' ORDER BY created DESC LIMIT 0,4";Code: Select all
$sql = "SELECT * FROM `pixels` WHERE `viewable`= 'Y' AND `adult` = 'N' ORDER BY `created` DESC LIMIT 0,4";