RE: [PHP] trouble reading a database (fwd)
| From: | Jason Murray | Date: | Tue, 24 Apr 2001 00:24:06 +0000 |
| Subject: | RE: [PHP] trouble reading a database (fwd) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-49966@lists.php.net to get a copy of this message | ||
> Read_sql SELECT * FROM TBL_Picture WHERE FLD_FileName =
> "SailBoat.jpg"and FLD_Path ="
/var/www/html/slidecollection/WinterCarnival"
This is a little hideous.
For one thing, you should probably use ' and not ". It may not
make a difference to MySQL, but it does to other databases you
may use in the future.
For the FLD_Path comparison, you are looking for something that
specifically STARTS with a space. I'd bet this is why the script
is getting 0 rows back - probably none of your FLD_Path's start
with a space.
Jason