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)) { 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 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 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. 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 >.< 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? 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 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. 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
Archived
This topic is now archived and is closed to further replies.