Re: [PHP-DB] Not displaying all records

2002-04-10 Thread Marius Ursache
$row returns an array, and you display only the first element Jennifer Downey a écrit : > Hi all, > > I had to re-write this so it would at least show something on the page. > > $query = "SELECT id, name, image, quantity FROM {$config["prefix"]}_my_items > WHERE uid={$session["uid"]} ORDER

Re: [PHP-DB] Not displaying all records

2002-04-10 Thread Jennifer Downey
Thank you Jason that worked out great! Jennifer "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > On Wednesday 10 April 2002 23:54, Jennifer Downey wrote: > > Hi all, > > > > I had to re-write this so it would at least show something on the page. > > > > $query = "SEL

Re: [PHP-DB] Not displaying all records

2002-04-10 Thread Jason Wong
On Wednesday 10 April 2002 23:54, Jennifer Downey wrote: > Hi all, > > I had to re-write this so it would at least show something on the page. > > $query = "SELECT id, name, image, quantity FROM > {$config["prefix"]}_my_items WHERE uid={$session["uid"]} ORDER BY id"; > $ret = mysql_query($query);

[PHP-DB] Not displaying all records

2002-04-10 Thread Jennifer Downey
Hi all, I had to re-write this so it would at least show something on the page. $query = "SELECT id, name, image, quantity FROM {$config["prefix"]}_my_items WHERE uid={$session["uid"]} ORDER BY id"; $ret = mysql_query($query); $row = mysql_fetch_array($ret); $id = $row['id']; $image = $row['ima