Re: [PHP] First record not diplaying

2008-12-22 Thread Gary Maddock-Greene
unless you fetch it in a variable to process datas at a later time. SanTa - Original Message - From: "Gary Maddock-Greene" To: Sent: Monday, December 22, 2008 3:49 PM Subject: Re: [PHP] First record not diplaying Thanks Dan, So my error is here? $colname_rsSearch =

Re: [PHP] First record not diplaying

2008-12-22 Thread Gary Maddock-Greene
rom: "Gary Maddock-Greene" To: Sent: Monday, December 22, 2008 3:49 PM Subject: Re: [PHP] First record not diplaying Thanks Dan, So my error is here? $colname_rsSearch = "-1"; if (isset($_GET['product_name'])) { $colname_rsSearch = $_GET['product_name'

Re: [PHP] First record not diplaying

2008-12-22 Thread HostWare Kft.
first record, unless you fetch it in a variable to process datas at a later time. SanTa - Original Message - From: "Gary Maddock-Greene" To: Sent: Monday, December 22, 2008 3:49 PM Subject: Re: [PHP] First record not diplaying Thanks Dan, So my error is here? $colname

Re: [PHP] First record not diplaying

2008-12-22 Thread Gary Maddock-Greene
Thanks Dan, So my error is here? $colname_rsSearch = "-1"; if (isset($_GET['product_name'])) { $colname_rsSearch = $_GET['product_name']; } mysql_select_db($database_sondia_lighting, $sondia_lighting); $query_rsSearch = sprintf("SELECT * FROM products WHERE product_name LIKE %s", GetSQLValueStr

Re: [PHP] First record not diplaying

2008-12-22 Thread Dan Shirah
> > Hi, I seem to have a bug in my code but can't see why. My first record >>> does >>> not display when I run a search. Can anyone spot what I have done wrong? >>> Thanks >>> >>> if (0 == $totalRows_rsSearch) { >>> echo "Sorry no products were found"; >>> } else { >>> echo "Please click on a pro

Re: [PHP] First record not diplaying

2008-12-22 Thread Ashley Sheridan
On Mon, 2008-12-22 at 14:14 +, Gary Maddock-Greene wrote: > Ash ... this is the full code block ... I am really new to php so I > appreciate your tip > > // Good to go > > if (0 == $totalRows_rsSearch) { > echo "Sorry no products were found"; > } else { > echo "Please click on a product fo

Re: [PHP] First record not diplaying

2008-12-22 Thread Gary Maddock-Greene
Very helpful thanks Wolf. fyi the web site you see was done by my son. This is a live project that I was just asking for help on ... a pointer perhaps. Too much to ask I guess -- - Gary Maddock-Greene "Wolf" wrote in message news:20081222141852.ovv8i.364383.r...@cdptpa-web15-z01... Gar

Re: [PHP] First record not diplaying

2008-12-22 Thread Gary Maddock-Greene
I know you are so right Richard .. beleive me ... I wish I was year down the line so I knew how to get the html out of the php -- - Gary Maddock-Greene ""Richard Heyes"" wrote in message news:af8726440812220617l6c965cd0x6ae55f57fa96b...@mail.gmail.com... Also (and I know the speed junkies wil

Re: [PHP] First record not diplaying

2008-12-22 Thread Dan Shirah
> > // Good to go > > if (0 == $totalRows_rsSearch) { > echo "Sorry no products were found"; > } else { > echo "Please click on a product for further information."; > while ($row_rsSearch = mysql_fetch_assoc($rsSearch)){ > echo " $row_rsSearch['product_image']."\"> > >". $row_rsSearc

Re: [PHP] First record not diplaying

2008-12-22 Thread Wolf
Gary Maddock-Greene wrote: > Hi, I seem to have a bug in my code but can't see why. My first record does > not display when I run a search. Can anyone spot what I have done wrong? > Thanks > > if (0 == $totalRows_rsSearch) { > echo "Sorry no products were found"; > } else { > echo "Please

Re: [PHP] First record not diplaying

2008-12-22 Thread Richard Heyes
> Also (and I know the speed junkies will want to shoot me now!) you could > shorten the echo inside the while loop to: You could shorten it even further by omitting it... :-) -- Richard Heyes HTML5 Graphing for FF, Chrome, Opera and Safari: http://www.rgraph.org (Updated December 20th) -- PH

Re: [PHP] First record not diplaying

2008-12-22 Thread HostWare Kft.
How do you know the record count for the query? SanTa - Original Message - From: "Gary Maddock-Greene" To: Sent: Monday, December 22, 2008 3:02 PM Subject: [PHP] First record not diplaying Hi, I seem to have a bug in my code but can't see why. My first record does not display when

Re: [PHP] First record not diplaying

2008-12-22 Thread Gary Maddock-Greene
Ash ... this is the full code block ... I am really new to php so I appreciate your tip Sorry no products were found"; } else { echo "Please click on a product for further information."; while ($row_rsSearch = mysql_fetch_assoc($rsSearch)){ echo " ". $row_rsSearch['product_name'].

Re: [PHP] First record not diplaying

2008-12-22 Thread Ashley Sheridan
On Mon, 2008-12-22 at 14:02 +, Gary Maddock-Greene wrote: > Hi, I seem to have a bug in my code but can't see why. My first record does > not display when I run a search. Can anyone spot what I have done wrong? > Thanks > > if (0 == $totalRows_rsSearch) { > echo "Sorry no products were found