'while' in php-mysql query

[tomaxs]

Firsty, sorry for my broken english 🙂

ok,

From form i have variables name_of_row1 ... 2... etc , there is also two kinds of rows (varchar, and enum).

The main problem is this that i have no idea how can i automatise it ... end skript should looke like this (with for ex. 3 varchar and 2 enum rows)

<?php
mysql_query("CREATE TABLE $nazwa (
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
$username1 VARCHAR(5),
$username2 VARCHAR(5),
$username3 VARCHAR(5),
$username4 ENUM('tak','nie') NOT NULL,
$username3 ENUM('tak','nie') NOT NULL)")
?>

And right here i have small problem, i don't known how to automatise this ... how to create only specified number of rows ?

Can i use something like 'while' function in mysql query ?

Maybe someone knows any tutorial about this.

Big thx for any help,
tomaxs

[tomhath]

You need to do it in php, not sql.

Either make a string with the CREATE TABLE that has all the fields, or create a table with only the primary key column (id) and then do ALTER TABLE to add the columns from the form one at a time.