Re: PHP 4.0 Bug #7752: Will not create a new table in database
| From: | Ignacio Vazquez-Abrams | Date: | Fri, 10 Nov 2000 19:19:31 +0000 |
| Subject: | Re: PHP 4.0 Bug #7752: Will not create a new table in database | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-37710@lists.php.net to get a copy of this message | ||
On 10 Nov 2000 mgrigajtis@rosasonline.com wrote:
> From: mgrigajtis@rosasonline.com
> Operating system: Linux Mandrake 7.2 Kernel 2.2.17
> PHP version: 4.0.2
> PHP Bug Type: MySQL related
> Bug description: Will not create a new table in database
>
> PHP4 will not ever create a new table in any database. It will create a new database, but
> just simply will not create the table.
> For example, the following lines do not work:
>
> $query = "CREATE TABLE $name (ID int(4), Date varchar(50), Sales float(4));"
> $result = mysql_query ($query);
>
1) Are you using/selecting the database first?
2) Does the user you're connecting to the server as have CREATE rights in
the database?
--
Ignacio Vazquez-Abrams <ignacio@openservices.net>