Probs with query
| From: | Simon Garstin | Date: | Sat, 02 Dec 2000 15:34:07 +0000 |
| Subject: | Probs with query | ||
| Groups: | php.install | ||
| Request: | Send a blank email to php-install+get-1034@lists.php.net to get a copy of this message | ||
Hi,
I am using PHP4.0.1 to connect to and run queries to Mysql.
The problem is that none of the queries will work from within PHP.
The code:
$sql="CREATE TABLE jobs (id int(6), cust char(30))"
// $conn is the connection to the database which I have checked and works fine, the database name is
right etc..
// and yes I have changed the priveliges in the 'mysql' file itself so that the user has
permission to do "Create_priv"
// --- I even tried it as "root" (all permissions enabled) but it would still not run !!
$result=mysql_query($sql,$conn) or die("Could not run query");
The query just will not work, although it will work fine if I execute it within the Mysql Monitor.
Doubtless there is some setting that needs to be checked/changed.
HELP...!!!!
(Apologies if this is not the right forum - if so could someone direct me to a more appropriate
forum.)
regds
S.Garstin