For a for problem....

[rulinus]

hi!
I'm trying to write a little script that generates a mysql table, but the legth of the table varies depending on a user imput (number - int) that determines the number of "modules" in the table. This modules are simply a set number of columns.... well here's what i've got so far:

 if ($num != 0){ 
$A = "CREATE TABLE `name` (
`guia` INT(10) UNSIGNED NOT NULL, 
`cliente` INT(10) UNSIGNED NOT NULL, "; // must-have columns
for($i = 1; $i <= $num; $i++){
$a = "`point".$i."` CHAR(50) NOT NULL, 
`date.".$i."1` DATE NOT NULL,";
$a=${'T'.$i}; //creating secuencial variables
}
$B = "`obs_final` TINYTEXT NOT NULL,
PRIMARY KEY (`guia`)
) 
COMMENT = 'something'; "; //end of table

Now the problem i have, besides the ones that a more trained eye might see in the above code, is finding a way of joining all the created variables. Do i have to join them in another For loop?
thanks in advance.
rulox

[ahundiak]

What you want to do is to use the concat operator to build up your string. Something like:

$sql = 'CREATE table (guia INT(10),';

for($i = 1; $i <= $num; $i++)
{
  $sql .= "point$i CHAR(50),";
  $sql .= "date$i DATE NOT NULL,";
}

/* Trim the extra comma at the very end */
$sql = rtrim($sql,',');

$sql .= "THE Closing Part of the table";

echo $sql;

Get the basics working then add the back ticks and the rest of the qualifiers.

[rulinus]

thank you, i got it working 😃