[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-general
Subject:    [PHP] Re: [PHP-DB] Help with update...
From:       Florian Blaser <mjjblaser () vtx ! ch>
Date:       2001-08-18 16:39:30
[Download RAW message or body]

Well, might not be the good answer, since it's been a long time I haven't 
used mysql. But, does mysql is case sensitive on table names ? try using 
albums instead of ALBUMS in your update query.

Just my .002 cents
Florian
Le Samedi, 18 Août 2001 18.21, vous avez écrit :
> I'm working under the gun here, so please excuse me if this turns out to be
> something really simple, but it's got me stumped... I'm trying to update
> the "cover" field in a table by using the album_id field in the table and
> adding a ".jpg" extention to it...
> For example:
> "Update albums set cover = "1.jpg" where album_id = 1"

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net

[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic