IEMC Posted March 24, 2006 Share Posted March 24, 2006 This is a news system.Its one i made a while back, stopped doing stuff with websites for awhile, now im coming back to it.My code is:[code]<?php $table = 'news'; $dbconnection = mysql_connect("$host", "$user", "$pass") or die ("MySQL Connection Attempt Failed: " . mysql_error()); mysql_select_db("$database",$dbconnection); $query="SELECT * FROM $table ORDER BY post_numb DESC LIMIT 1"; $result=mysql_query($query); $num_rows=mysql_num_rows($result); $i=0; while($i<$num_rows) { $title=mysql_result($result,$i,'news_title'); $time=mysql_result($result,$i,'time'); $article=mysql_result($result,$i,'news_text'); echo "$title"; echo nl2br("$article"); $i=$i+1; } mysql_close( $dbconnection ); ?>[/code]I have news entered, its just whenever i try to see the news, i get this:[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.invitation/lukepolito/mrfaxsender.be/index.php on line 30[/quote]Which makes no sense, because this used to work. Whats the problem? Link to comment https://forums.phpfreaks.com/topic/5724-not-reporting-data/ Share on other sites More sharing options...
shocker-z Posted March 24, 2006 Share Posted March 24, 2006 [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]<?php $table = 'news'; $dbconnection = mysql_connect("$host", "$user", "$pass") or die ("MySQL Connection Attempt Failed: " . mysql_error()); mysql_select_db("$database",$dbconnection); $query="SELECT * FROM $table ORDER BY post_numb DESC LIMIT 1"; $result=mysql_query($query) or DIE(mysql_error()); $num_rows=mysql_num_rows($result); $i=0; while($i<$num_rows) { $title=mysql_result($result,$i,'news_title'); $time=mysql_result($result,$i,'time'); $article=mysql_result($result,$i,'news_text'); echo "$title"; echo nl2br("$article"); $i=$i+1; } mysql_close( $dbconnection );?>[/quote]try that and give paste the error it gives abck it will say where the problem in the SQL syntax is, i can't see anything wrong from here.. Link to comment https://forums.phpfreaks.com/topic/5724-not-reporting-data/#findComment-20426 Share on other sites More sharing options...
IEMC Posted March 24, 2006 Author Share Posted March 24, 2006 Thats.... crazy...Putting that in made it echo the news.. lol thanks :P Link to comment https://forums.phpfreaks.com/topic/5724-not-reporting-data/#findComment-20430 Share on other sites More sharing options...
shocker-z Posted March 24, 2006 Share Posted March 24, 2006 what the... i didnt change the query just added or die(mysql_error());:S Link to comment https://forums.phpfreaks.com/topic/5724-not-reporting-data/#findComment-20432 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.