[Solved] "supplied argument is not a valid MySQL...&
Posted: Wed Jun 22, 2005 7:57 am
Hi i hope someone can help me with this problem:
I have this code:
and it gives this error:
THANKS!!!
-TS
I have this code:
Code: Select all
$id = mysql_query("SELECT 'id' FROM 'action'", $db);
$name = mysql_query("SELECT 'name' FROM 'action'", $db);
$description = mysql_query("SELECT 'description' FROM 'action'", $db);
$image_source = mysql_query("SELECT 'image_source' FROM 'action'", $db);
$game_link = mysql_query("SELECT 'game_source' FROM 'action'", $db);
$developer = mysql_query("SELECT 'developer' FROM 'action'", $db);
$platform = mysql_query("SELECT 'platform' FROM 'action'", $db);
$votes_added = mysql_query("SELECT 'votes_added' FROM 'action'", $db);
$votes = mysql_query("SELECT 'votes' FROM 'action'", $db);
while (($id = mysql_fetch_array($id, MYSQL_BOTH)) && ($name = mysql_fetch_array($name, MYSQL_BOTH)) && ($description = mysql_fetch_array($description, MYSQL_BOTH)) && ($image_source = mysql_fetch_array($image_source, MYSQL_BOTH)) && ($game_link = mysql_fetch_array($game_link, MYSQL_BOTH)) && ($developer = mysql_fetch_array($developer, MYSQL_BOTH)) && ($platform = mysql_fetch_array($platform, MYSQL_BOTH)) && ($votes_added = mysql_fetch_array($votes_added, MYSQL_BOTH)) && ($votes = mysql_fetch_array($votes, MYSQL_BOTH)) ) { //line 17
echo $id["action"] . " | ";
echo $description["action"] . " | ";
echo $image_source["action"] . " | ";
echo $game_link["action"] . " | ";
echo $developer["action"] . " | ";
echo $platform["action"] . " | ";
echo $votes_added["action"] . " | ";
echo $votes["action"] . " | ";
echo "<center>+------------------------------------------------------------------+</center>";
}i can't understand what's wrong with the code.Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/vhosts/playonline.e2u.cc/action.php on line 17
THANKS!!!
-TS