[PHP-DB] empty query

[Addison Ellis]

hello,
i have unsuccessfully tried for three days to write, re-write something that will insert data into my db and ashamedly have failed again. at one point i was able to echo values and see that they were in fact passing from my form. now i can't even get that. anyway, if you could take a look at this and tell me where i'm going wrong i will greatly appreciate it. thank you... addison

<?
session_start(); if (@$auth != "yes") include("config.php");

function storeForm($formdata,$ads)
{
$query = "INSERT INTO $ads (";
$query2 = " VALUES (";
$counter = 0;
foreach ($formdata as $key => $value) {
$formdata[$key] = trim($formdata[$key]);
$formdata[$key] = strip_tags($formdata[$key]);
$counter++;
if ($counter == sizeof($formdata) ) //if this is last field
{
$query = $query.$key;
$query2 = $query2."'".$value."'";
}
else //if this is not the last field
{
$query = $query.$key.",";
$query2 = $query2."'".$value."'".",";
}
}
$query = $query.")";
$query2 = $query2.")";
$query=$query.$query2;
$result = mysql_query($query)
or die ("Couldn't execute query.");
}
?>
--
Addison Ellis
small independent publishing co.
114 B 29th Avenue North
Nashville, TN 37203
(615) 321-1791
[EMAIL PROTECTED]
[EMAIL PROTECTED]
subsidiaries of small independent publishing co.
[EMAIL PROTECTED]
[EMAIL PROTECTED]