Re: CREATE TABLE QUERY PHP/MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Very likely you have to GRANT the CREATE permission to your PHP user
account.

Also investigate the CREATE TEMPORARY TABLE grant status available since
version 4+. Very convenient.

Ignatius
____________________________________________
----- Original Message -----
From: "Jonathan" <dbphp@ftbwebsolutions.com>
To: <php-db@lists.php.net>
Sent: Friday, December 06, 2002 10:00 PM
Subject:  CREATE TABLE QUERY PHP/MySQL


> This is the first time I am trying to create a table in MySQL based on
> user input.
>
> Here is the scenario,
>
> The user will enter in the name of a stage, e.g. Harley Davidson.
> I then look for the first space (to indicate the first word), make it
> into lower case and then do the following:
>
> $new_stage_name = "stage_".$var;
>
> This will give $new_stage_name the value of "stage_harley".
>
> That works fine.
>
> Now I want to run the following query:
>
> $SQL = "CREATE TABLE ".$new_stage_name." (set values and their
> properties)";
>
> If I run this query using PHPMyAdmin, minus the var of course, the table
> is created.
>
> When I run it in my code, nothing happens. I do a die($SQL) to see the
> final outcome of the query and it's correct and is what I am using to
> run the query in PHPMyAdmin.
>
> This is what my code is doing:
>
> I have class RecordSet which makes the db connection and its constructor
> takes the $SQL as an arg.
>
> So, $SQL = "what is listed above";
> $objRecordSet = new RecordSet($SQL);
> //I used this all the time with all kinds of other Select, Insert,
> Update, and Delete queries and it works perfect.
>
> For one, I don't know how to test whether the table has been created or
> not.  I know I could probably do some sort of mysql_list_tables and look
> for it or whatever but I was looking for something similar to
>
> If (mysql_affected_rows() == -1)
> Because that is very easy.
>
> And ideas as to why the table is not being created.
>
> ===================
> Jonathan Villa
> Application Developer
> IS Design & Development
> www.isdesigndev.com
> 414.429.0327
> ===================
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux