Menu
Community /Pin to ProfileBookmark
@NogDogDec 22.2008 — #If you want to echo each SQL string, put the echo within the for loop, not after it. @NogDogDec 22.2008 — #I'm not real sure what the goal is here. If you want to end up with the variable $sql containing all of the queries created in the for loop, then you want to do something like:
If the objective is something else, then I'll need more explanation.
how can i create a mysql table in a for loop?
Just a slight problem in my coding. I’m trying to create a mysql table in a for loop but when i echo the sql statement it only pulls the last item in the array out.
for ($c=0; $c < $num; $c++) {
// echo $data[$c] . “<br />n”;
$sql = “CREATE TABLE ACR (
acrID int NOT NULL,
“.$data[$c].” varchar(100) NULL,
PRIMARY KEY (acrID))type=MyISAM”;
}
echo $sql;
}
How can i get it to pull all 187 $data variables inside the for loop instead of just the last $data variable?
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogDec 22.2008 — #0
@NogDogDec 22.2008 — #I'm not real sure what the goal is here. If you want to end up with the variable $sql containing all of the queries created in the for loop, then you want to do something like:[code=php]
$sql = "";
for(blah...blah...blah)
{
$sql .= "blah...blah...blahn"; // note use of ".=" opeartor
}
echo $sql;
[/code]If the objective is something else, then I'll need more explanation.