create new table from existing table

[Anon]

I want to create a new table using the select statement from another table

This is the syntax

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

could somebody give me an actual PHP coded example as i am having problems getting it to work

thanx Rob