I think I'm a little too close to the problem to see it properly, but
there's something wrong with my SQL syntax in this query I'm trying to
create.
Readers of Julie Meroni's PHP Essentials will recognise it.
<?php
$sql = "CREATE TABLE $table_name (";
for ($i = 0; $i < count($field_name); $i++)
{
$sql .= "$field_name[$i] $field_type[$i]";
if ($field_length[$i] != "")
{
$sql .= " ($field_length[$i]),";
}//end if
else
{
$sql .= ",";
}//end else
}//end for
$sql = substr($sql, 0, -1);
$sql .= ");";
It gives me this error
You have an error in your SQL syntax near '(50),product_price float
(10),product_category text (50),product_picture text (5' at line 1
Is there like an upper limit on the number of characters you can have in a
SQL statement?
All help is greatly appreciated!
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
