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@xxxxxxxxx> wrote in message
news:a16da1ff0812220635j6a77c35ga2e74588671dc300@xxxxxxxxxxxxxxxxx
>
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?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
