monkeypaw201 Posted April 23, 2008 Share Posted April 23, 2008 i get the following error: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/monkeypaw201.com/httpdocs/crons/metar_0_500.php on line 13 lines 10-15: mysql_select_db($database_cron,$cron); $result = mysql_query("SELECT * FROM airports LIMIT 0, 500"); while($row = mysql_fetch_assoc($result)) { Quote Link to comment https://forums.phpfreaks.com/topic/102454-solved-mysql_fetch_assoc-error/ Share on other sites More sharing options...
Fadion Posted April 23, 2008 Share Posted April 23, 2008 Im sure uve connected to the database first Quote Link to comment https://forums.phpfreaks.com/topic/102454-solved-mysql_fetch_assoc-error/#findComment-524662 Share on other sites More sharing options...
monkeypaw201 Posted April 23, 2008 Author Share Posted April 23, 2008 yes, i have Quote Link to comment https://forums.phpfreaks.com/topic/102454-solved-mysql_fetch_assoc-error/#findComment-524664 Share on other sites More sharing options...
Fadion Posted April 23, 2008 Share Posted April 23, 2008 The problem isnt with mysql_fetch_array(), it is with mysql_query() not being passed correctly to $result as a resource identifier. Try: $result = mysql_query("SELECT * FROM airports LIMIT 0, 500") or die(mysql_error()); and see what error does it show. Quote Link to comment https://forums.phpfreaks.com/topic/102454-solved-mysql_fetch_assoc-error/#findComment-524666 Share on other sites More sharing options...
iarp Posted April 23, 2008 Share Posted April 23, 2008 wow... did i ever miss read that >.< Quote Link to comment https://forums.phpfreaks.com/topic/102454-solved-mysql_fetch_assoc-error/#findComment-524667 Share on other sites More sharing options...
Fadion Posted April 23, 2008 Share Posted April 23, 2008 wow... did i ever miss read that >.< What do u mean? And how's this topic solved? How did u solve the problem? Quote Link to comment https://forums.phpfreaks.com/topic/102454-solved-mysql_fetch_assoc-error/#findComment-524670 Share on other sites More sharing options...
monkeypaw201 Posted April 23, 2008 Author Share Posted April 23, 2008 The problem isnt with mysql_fetch_array(), it is with mysql_query() not being passed correctly to $result as a resource identifier. Try: $result = mysql_query("SELECT * FROM airports LIMIT 0, 500") or die(mysql_error()); and see what error does it show. i followed that, and it worked perfectly thank you Quote Link to comment https://forums.phpfreaks.com/topic/102454-solved-mysql_fetch_assoc-error/#findComment-524675 Share on other sites More sharing options...
iarp Posted April 23, 2008 Share Posted April 23, 2008 wow... did i ever miss read that >.< What do u mean? And how's this topic solved? How did u solve the problem? I edited the post so fast you didn't see it. Quote Link to comment https://forums.phpfreaks.com/topic/102454-solved-mysql_fetch_assoc-error/#findComment-524676 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.