*HELP* database trouble

[Anon]

Does anybody know how to use this?

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)]
[table_options] [select_statement]

I need to create a new table using the select statement part of it FROM another table.

It basically creates a new table and populates it on data from another table that has had a select statement applied to it

thanks Rob

[nostradamus]

Try the following statement:

CREATE TABLE TABELLE_NEU(FELD1, FELD2, FELD3)
AS (SELECT FELD1, FELD2, FELD3
FROM TABELLE_ALT <WHERE...>);

That should work.

[Anon]

<?php

$link = mysql_connect(" "," "," ");

mysql_select_db("namenum", $link);

mysql_query("CREATE TABLE numone (name, num) AS (SELECT name, num FROM num WHERE name = 'Robert')" , $link);

?>

This is the code im using but it still doesnt want to work. Any ideas why it isnt