Re: First record not diplaying

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", GetSQLValueString("%" . $colname_rsSearch . "%", "text")); $rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or die(mysql_error()); $row_rsSearch = mysql_fetch_assoc($rsSearch); $totalRows_rsSearch = mysql_num_rows($rsSearch); -- - Gary Maddock-Greene ""Dan Shirah"" <mrsquash2@gmail.com> wrote in message news:a16da1ff0812220635j6a77c35ga2e74588671dc300@mail.gmail.com... > > >> 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 "<h3>Sorry no products were found</h3>"; >>>> } else { >>>> echo "<h3>Please click on a product for further information.</h3>"; >>>> while ($row_rsSearch = mysql_fetch_assoc($rsSearch)){ >>>> echo "<div class=\"productitem\"><img src=\"products". >>>> $row_rsSearch['product_image']."\"> >>>> >>>> - Gary Maddock-Greene >>>> >>> >>> Is this another one of your classes? I see your email address links to >>> a >>> web page created for a class. >>> >>> Without the rest of the code (the code above what you have placed) and >>> the >>> end of the echo line you have provided, all any of us can do is a guess. >>> >>> However one thing to note, this list was not created to help you with >>> your >>> homework and with the previous postings you have written, it is >>> pointedly >>> answering different places you have stumbled in your work and haven't >>> checked your book, the online resources, or a TA. >>> >>> Wolf >> >> > Like Wolf said...we need more code :) > > My "guess" would be that you probably have the default value of your row > count set to start at 1...but the results of an array start at > 0...therefore > your first row is being cutoff? >