[PHP/MySQL] Query problem - Tilted Forum Project Discussion Community

Fallon · 04-01-2004, 06:01 PM

Alright, so I got MySQL v. 4.0.18-standard, and php 4.3.4 as background.
What I'm tryin to do is create a script that'll create a table thru a table. Some people may have the PHP fast & easy development and I'm trying to copy the one that they have in the book.
I've looked at the php.net, and it didn't really answer my question though.
Here's the error I get.
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 't (Array[0]),)' at line 1
This is in the table creation script

PHP Code:


			
$sql = "CREATE TABLE $_POST[table_name] (";

for ($i = 0; $i < count($_POST[field_name]); $i++) {

    $sql .= "$_POST[field_name][$i] $_POST[field_type][$i]";

    if ($_POST[field_length][$i] != "") {

    $sql .= " ($_POST[field_length][$i]), ";

    } else {

        $sql .= ", ";

    }

}

and heres my form sorta deal. It used to have a dropdown menu, but I thought that may be part of the issue, but it isn't I think.
This is in the table selection field.

PHP Code:


			
  for($i = 0; $i < $_POST[num_fields]; $i++) {

      $form_block .= "

      <TR>

          <TD ALIGN=CENTER><INPUT TYPE=\"text\" NAME=\"field_name[]\" SIZE=\"30\"></TD>

          <TD ALIGN=CENTER><INPUT TYPE=\"text\" NAME=\"field_type[]\">            </TD>

          <TD ALIGN=CENTER><INPUT TYPE=\"text\" NAME=\"field_length[]\" SIZE=\"5\"></TD>

If you need to see anymore code or got any questions, I'll try my best to answer them.
If you have any references about this that I can look at, I would be greatly appriciative.

Moskie · 04-01-2004, 08:46 PM

I think the problem is that the last time this for loop goes through:

PHP Code:


			
$sql = "CREATE TABLE $_POST[table_name] (";



for ($i = 0; $i < count($_POST[field_name]); $i++) {



    $sql .= "$_POST[field_name][$i] $_POST[field_type][$i]";



    if ($_POST[field_length][$i] != "") {



    $sql .= " ($_POST[field_length][$i]), ";



    } else {



        $sql .= ", ";



    }



}

... you're left with an extra comma at the end.

Do a check to see if you're at the last iteration of the loop. If you are, don't print the comma. Hopefully that helps.

Such as:

PHP Code:


			
$sql = "CREATE TABLE $_POST[table_name] (";



for ($i = 0; $i < count($_POST[field_name]); $i++) {



    $sql .= "$_POST[field_name][$i] $_POST[field_type][$i]";



    if ($_POST[field_length][$i] != "") {



    $sql .= " ($_POST[field_length][$i]) ";



    } 



if ($i < $_POST[field_name]-1) {

    $sql .= ", ";

}



}

Rawb · 04-01-2004, 09:41 PM

This happens all the time.

when your loop goes through, it will end up with an extra comma on the end, remove it with rtrim() after your loop is finished

PHP Code:


			
$sql = rtrim($sql,", ");

Also, after that is all done, you have open a paranthesis(sp) but not closed it, look right after the CREATE TABLE, so just append a close paranthesis to the end and you should be pretty well good to go.

mpedrummer2 · 04-03-2004, 11:19 AM

I generally toss stuff like that into a temporary array, then implode() the array, gluing with commas.

No trailing commas that way.

MPEDrummer

04-01-2004, 06:01 PM	#1 (permalink)
Fallon Junkie Location: RI	[PHP/MySQL] Query problem Alright, so I got MySQL v. 4.0.18-standard, and php 4.3.4 as background. What I'm tryin to do is create a script that'll create a table thru a table. Some people may have the PHP fast & easy development and I'm trying to copy the one that they have in the book. I've looked at the php.net, and it didn't really answer my question though. Here's the error I get. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 't (Array[0]),)' at line 1 This is in the table creation script PHP Code: `$sql = "CREATE TABLE $_POST[table_name] ("; for ($i = 0; $i < count($_POST[field_name]); $i++) { $sql .= "$_POST[field_name][$i] $_POST[field_type][$i]"; if ($_POST[field_length][$i] != "") { $sql .= " ($_POST[field_length][$i]), "; } else { $sql .= ", "; } }` and heres my form sorta deal. It used to have a dropdown menu, but I thought that may be part of the issue, but it isn't I think. This is in the table selection field. PHP Code: `for($i = 0; $i < $_POST[num_fields]; $i++) { $form_block .= " <TR> <TD ALIGN=CENTER><INPUT TYPE=\"text\" NAME=\"field_name[]\" SIZE=\"30\"></TD> <TD ALIGN=CENTER><INPUT TYPE=\"text\" NAME=\"field_type[]\"> </TD> <TD ALIGN=CENTER><INPUT TYPE=\"text\" NAME=\"field_length[]\" SIZE=\"5\"></TD>` If you need to see anymore code or got any questions, I'll try my best to answer them. If you have any references about this that I can look at, I would be greatly appriciative. Last edited by Fallon; 04-01-2004 at 06:03 PM..

04-01-2004, 08:46 PM	#2 (permalink)
Moskie Pure Chewing Satisfaction Location: can i use bbcode [i]here[/i]?	I think the problem is that the last time this for loop goes through: PHP Code: `$sql = "CREATE TABLE $_POST[table_name] ("; for ($i = 0; $i < count($_POST[field_name]); $i++) { $sql .= "$_POST[field_name][$i] $_POST[field_type][$i]"; if ($_POST[field_length][$i] != "") { $sql .= " ($_POST[field_length][$i]), "; } else { $sql .= ", "; } }` ... you're left with an extra comma at the end. Do a check to see if you're at the last iteration of the loop. If you are, don't print the comma. Hopefully that helps. Such as: PHP Code: `$sql = "CREATE TABLE $_POST[table_name] ("; for ($i = 0; $i < count($_POST[field_name]); $i++) { $sql .= "$_POST[field_name][$i] $_POST[field_type][$i]"; if ($_POST[field_length][$i] != "") { $sql .= " ($_POST[field_length][$i]) "; } if ($i < $_POST[field_name]-1) { $sql .= ", "; } }` __________________ Greetings and salutations. Last edited by Moskie; 04-01-2004 at 08:52 PM..

04-01-2004, 09:41 PM	#3 (permalink)
Rawb Crazy Location: Salt Town, UT	A common, but small mistake This happens all the time. when your loop goes through, it will end up with an extra comma on the end, remove it with rtrim() after your loop is finished PHP Code: `$sql = rtrim($sql,", ");` Also, after that is all done, you have open a paranthesis(sp) but not closed it, look right after the CREATE TABLE, so just append a close paranthesis to the end and you should be pretty well good to go.

04-03-2004, 11:19 AM	#4 (permalink)
mpedrummer2 Insane	I generally toss stuff like that into a temporary array, then implode() the array, gluing with commas. No trailing commas that way. MPEDrummer __________________ My sig can beat up your honor student.