LINUX.IE, website of the Irish Linux Users' Group
Tux rules!

   
Home
New Users
Articles
Download
Projects
Community
Vendors

  Print Version
Email to...
 
Archives:


planetILUG

Recent News

News Archive


Join the
ILUG
on FaceBook


Join the
ILUG
on LinkedIn


Join the
ILUG SETI
Group



















 
 :: Mailing Lists

[ILUG] fetch_row problem

[ILUG] fetch_row problem

nils nils at eircom.net
Sat Mar 27 23:00:35 GMT 2004


hi,

can anyone see anything wrong with this.
$result = mysql_query("SELECT topic_id, forum_id, topic_last_post_id,
topic_title, topic_poster, topic_views, topic_replies,topic_moved_id
FROM phpbb_topics ORDER BY topic_last_post_id DESC");

This should put the return array into each var listed.

while(list($topic_id, $forum_id, $topic_last_post_id, $topic_title,
$topic_poster, $topic_views, $topic_replies, $topic_moved_id) =
mysql_fetch_row($result));

but when i do echo $topic_id, i get no value returned.

but if i change the the while  for this i get back
$myrow = mysql_fetch_row($result);
echo "<pre>";
print_r($myrow);
echo "</pre>";
I get this back

Array
(
    [0] => 26
    [1] => 12
    [2] => 65
    [3] => vega strike
    [4] => 6
    [5] => 1
    [6] => 0
    [7] => 0
)


Any ideas why it is not putting the contents on the return array into
each var listed in the while loop ?

nils





More information about the ILUG mailing list
Read this without the formatting.
                                                                                                    

 

Hosted by HEAnet


Maintained by the ILUG website team. The aim of Linux.ie is to support and help commercial and private users of Linux in Ireland. You can display ILUG news in your own webpages, read backend information to find out how. Networking services kindly provided by HEAnet, server kindly donated by Dell. Linux is a trademark of Linus Torvalds, used with permission. No penguins were harmed in the production or maintenance of this highly praised website. Looking for the Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
RSS Version
Powered by Dell