tokkille Posted March 9, 2006 Share Posted March 9, 2006 When i try to recive data from my database i get the following error message (on the webpage):Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /customers/vahlne.se/vahlne.se/httpd.www/index.php on line 18My code in PHP looks as follows (from row 13(<?php)-24(?>)):<?phpinclude("XXX.php");$result = mysql_query("SELECT * FROM maraton1 ORDER BY Plats ASC",$db);echo "<table border=1 align=center cellspacing=2 cellpadding=3>\n";echo "<TR><TH>Plats<TH>Lag<TH>Poäng</TR>\n";while ($rad = mysql_fetch_array($result)){echo "<TR><TD>$rad[Plats]<TD>$rad[Lag]<TD>$rad[Poäng]\n";}echo "</TABLE>";?>Would be greatful for all help!!Thanks alot,Tokkille Quote Link to comment https://forums.phpfreaks.com/topic/4519-cant-recive-database-query/ Share on other sites More sharing options...
shocker-z Posted March 9, 2006 Share Posted March 9, 2006 basicaly that means there is an error in your SQLchange: $result = mysql_query("SELECT * FROM maraton1 ORDER BY Plats ASC",$db);to: $result = mysql_query("SELECT * FROM maraton1 ORDER BY Plats ASC",$db) OR die(mysql_error());and that will give you an error that will say what the problem with the statement is Quote Link to comment https://forums.phpfreaks.com/topic/4519-cant-recive-database-query/#findComment-15740 Share on other sites More sharing options...
tokkille Posted March 9, 2006 Author Share Posted March 9, 2006 Thanks for the help!!!!!/Tokkille Quote Link to comment https://forums.phpfreaks.com/topic/4519-cant-recive-database-query/#findComment-15754 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.