Hello

--- Pete <[EMAIL PROTECTED]> a écrit :

>Another problem is that the table is created with the
>name $num and is not replaced like I want by its
>value. How can I solve this other problem?

Use double quotes around the "SELECT..., not the
single quotes that you
have now. 

Thank you very very much for your help. I really had
the feeling that I would never solve this problem.
So, here is the good answer:

Wrong:
$sql_query = 'CREATE TABLE $num ('
        . ' `variable1` DATE NOT NULL'
        . ' )'; 

Good:
$sql_query = "CREATE TABLE `$num` (variable1 DATE NOT
NULL,
variable2 smallint(4) unsigned NOT NULL)";

Just use the `` for the name of the table.


        

        
                
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com


Community email addresses:
  Post message: [email protected]
  Subscribe:    [EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://groups.yahoo.com/group/php-list 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php-list/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to