myPhpAdmin/mysql/php/ Problem

From: Date: Mon, 06 Aug 2001 16:22:21 +0000
Subject: myPhpAdmin/mysql/php/ Problem
Groups: php.general 
Request: Send a blank email to php-general+get-61446@lists.php.net to get a copy of this message
who's fault is this?: I have a table 'cdrequest' it has columns 'albumfill' and 'releasedatefill' among others.... when i do the following query with myphpadmin update cdrequest set albumfill = "hot shots II", releasedatefill = 20010708 where requstID = 2; i get: You have an error in your SQL syntax near '\"hot shots II\", releasedatefill = 20010708 where requstID = 2' at line 1 I can't see any reason for the error..... part 2: when I flip to properties for the cdrequest just to make sure i'm spelling the columns corectly and cut and paste the exact same query on that page IT WORKS.... Why would it work on that page but not the other. both are supposed to be places where you can enter a normal sql query.. It also doesn't work in my PHP script which is where I really want it to work. What am I missing?? thanx Julian

« previous php.general (#61446) next »