my code
| From: | Piet from South Africa | Date: | Mon, 01 Mar 2004 16:48:23 +0000 |
| Subject: | my code | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-33233@lists.php.net to get a copy of this message | ||
This is my code
My function call:
insert_property($name, $upfile1, $upfile2, $upfile3, $upfile4, $bed, $bath,
$living, $dining, $reception, $garages, $flats, $servant, $pool, $jacuzzi,
$lapa,
$entertain, $security, $securest, $short, $long, $contact, $number, $mail,
$fax,
$period, $prov, $city, $area);
My function:
function insert_property($name, $upfile1, $upfile2, $upfile3, $upfile4,
$bed, $bath,
$living, $dining, $reception, $garages, $flats, $servant, $pool, $jacuzzi,
$lapa,
$entertain, $security, $securest, $short, $long, $contact, $number, $mail,
$fax,
$period, $prov, $city, $area)
{
global $link;
$query = "insert into property (name, photo1, photo2, photo3, logo, bed,
bath,
living, dining, reception, garages, flats, servant, pool, jacuzzi, lapa,
entertain, security, securest, short, long, contact, number, mail, fax,
period, prov, city, area)
values ('" . $name . "', '" . $upfile1 . "', '" .
$upfile2 . "', '" .
$upfile3 . "'
,'" . $upfile4 . "', '" . $bed . "', '" . $bath .
"', '" . $living . "'
,'" . $dining . "', '" . $reception . "', '" .
$garages . "', '" . $flats .
"'
, '" . $servant . "', '" . $pool . "', '" .
$jacuzzi . "', '" . $lapa . "'
, '" . $entertain . "', '" . $security . "', '" .
$securest . "', '" .
$short . "'
, '" . $long . "', '" . $contact . "', '" .
$number . "', '" . $mail . "'
, '" . $fax . "', '" . $period . "', '" . $prov .
"', '" . $city . "'
, '" . $area . "')";
$result = mysql_query($query);
if (!$result)
{
echo "no result";
}
else
{
echo "";
}
}
"Piet From South Africa" <pieterdt@telkomsa.net> wrote in message
news:20040301162916.91396.qmail@pb1.pair.com...
> Hi
>
> I want to know if there is a limit to the amount of columns that can be
> created in a table, i have 30 columns, and i cannot insert data, i have
> checked everything over and over again, even written a shorter insert
> function that worked on the database.
>
> Can anyone help me here!!!!!