ROB — Tue, 20 Jan 2004 04:50:54 +0000

druagord wrote: with fetch_row you have to use $qry[0] $qry[1] with fetch_array you can use $qry['header'] and $qry['body']

fetch_row returns a number indexed array, fetch_assoc returns a string indexed hash, fetch_array returns both.

Suzanne — Mon, 19 Jan 2004 16:55:46 +0000

I thought it was something like that, Druagord, I've amended my code sample to accomodate that.

brady.k — Mon, 19 Jan 2004 16:42:29 +0000

Thanks, suzanne...

That's the script i was referring to, and didn't understand what was wrong

druagord — Mon, 19 Jan 2004 15:04:44 +0000

with fetch_row you have to use $qry[0] $qry[1] with fetch_array you can use $qry['header'] and $qry['body']

ROB — Mon, 19 Jan 2004 05:08:30 +0000

also, even though I believe the php manual claims theres little performance difference, you should use mysql_fetch_assoc or mysql_fetch_row unless you specifically need both, because I've benchmarked them and mysql_fetch_array is significanlty slower.

Suzanne — Mon, 19 Jan 2004 00:48:40 +0000

http://www.webmaster-forums.net/showthread.php?t=22762&highlight=mysql_fetch_row+mysql_fetch_array from the last time we talked about this, in case you need the reference.

I tend to code it differently, so you may be getting an error in something I can't see because I'm not familiar with it:

<?php
 
...connection... 
 
$sql = mysql_query(\"SELECT * FROM data\"); 
// this *should* work, but I use mysql_fetch_array usually
while ($qry = mysql_fetch_row($sql)) { 
    $header = $qry[0];
    $body = $qry[1];

echo<<<DISPLAY
<p class=\"title\">$header</p>
<p>&nbsp;&nbsp;&nbsp;$body</p>
<p class=\"line\">---------------</p>
DISPLAY; 

}  

mysql_close($dbh); 
                                            
?>

In general, it looks fine, perhaps there is no data returned? Put in some error messages and see what you get?

brady.k — Mon, 19 Jan 2004 00:32:48 +0000

lol _fetch_row

sorry.

Suzanne — Mon, 19 Jan 2004 00:27:13 +0000

mysql_fetch_array?