Re: Select, mysql_fetch_array, PHP question

2002-12-03 Thread Beauford.2003
o: "Beauford.2003" <[EMAIL PROTECTED]> Sent: Tuesday, December 03, 2002 7:41 PM Subject: Re: Select, mysql_fetch_array, PHP question > Maybe you have an "if ($line = mysql_fetch_array($result))" line > somewhere up above? That would cause the while loop to skip

Re: Select, mysql_fetch_array, PHP question (sorry - typo in my original email)

2002-12-03 Thread Beauford.2003
Sorry, where it says echo $item should have read echo $line['item']; Simply a typo, but the problem is still the same. Hi, I'm trying to do a search on database through a web interface using PHP and having one small problem. Example: If I search for items that cost $5.00 and there are three of th

Re: Select, mysql_fetch_array, PHP question

2002-12-03 Thread Steve Yates
On Tue, 3 Dec 2002 08:38:59 -0500, Beauford.2003 wrote: > while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { > echo $item; } Try echo $line['item']; - Steve Yates - Any sufficiently advanced magic looks like technology. ~ Taglines by Taglinator - www.srtware.com ~ --

RE: Select, mysql_fetch_array, PHP question

2002-12-03 Thread Jennifer Goodie
lto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 5:39 AM To: [EMAIL PROTECTED] Subject: Select, mysql_fetch_array, PHP question Hi, I'm trying to do a search on database through a web interface using PHP and having one small problem. Example: If I search for items that cost $5.00 and

Select, mysql_fetch_array, PHP question

2002-12-03 Thread Beauford.2003
Hi, I'm trying to do a search on database through a web interface using PHP and having one small problem. Example: If I search for items that cost $5.00 and there are three of them, the query works and displays the information, but if there is only one item the query works but doesn't display the