Hey... new to the list, but didn't have time to lurk and watch the traffic,
kind of in a bind here. I apologize in advance if I do something wrong...

Using this code:
                    $link = mysql_connect()
                        or die("Could not connect");
                    mysql_select_db("mydb") or die("Could not select database");

                    $result = mysql_query("SELECT * FROM cars WHERE year=1991");

                    while ($row = mysql_fetch_object($result)) {
                        $generation = $row->generation;
                                $year = $row->year;
                                $owner = $row->owner;
                                $email = $row->email;
                                $pic1 = $row->pic1;
                                $tmb1 = $row->tmb1;
                                printf("<img src='%s'><br>", $pic1);
                                printf("<a href=mailto:'%s'>%s</a><p>", $email, 
                                printf("<a href='%s'><img src='%s' border=0></a><p>", 
$pic1, $tmb1);

                    /* Free resultset */

                    /* Closing connection */

I'm successfully able to retrieve and display information for year='1991'.
It works great. However, if I replace '1991' with any other year that I KNOW
there's a matching record for, I get no results. So if I were to replace
year='1991' with year='1990', no results would be produced although the same
query given directly in MySQL will give results. Make sense? This same
problem happens with other fields too, it seems really selective. I can use
WHERE color='red' and get results, but color='black' returns nothing,
although there are matching records. Taking out the WHERE in the above code
will return all but the first record in the table. I fixed that just by
putting a dummy record first, but that still shouldn't be happening.

Any ideas? I need to get this fixed but I'm not sure what's wrong!

Thanks in advance,
(PHP 4.1.2 Win32)
(MySQL 3.23 Win32)

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to