
February 21st, 2000, 10:58 PM
|
|
Contributing User
|
|
Join Date: Oct 1999
Location: Annapolis, Maryland US
Posts: 113
Time spent in forums: < 1 sec
Reputation Power: 14
|
|
|
Maybe something like...
// put all column names in an array
$cols=array("name", "age", "height");
$total=count($cols);
$query="CREATE table table_name(";
(for $i=0; $i<$total; $i++)
{
if($i != ($total-1))
$query.="$cols[$i] varchar(50),"
else
$query.="$cols[$i] varchar(50)); // no comma and end parentheses
}
I dunno...give it a shot
|