Re: empty query

thank you so much for responding... i added this: { echo "$key, $value<br>"; } underneath function storeForm($formdata,$ads) and it is now displaying this: year, 1971 make, chevy model, impala color, green mileage, condition, none price, other, Ad may not exceed 25 words. contact, addison@bellsouth.net next_, Submit Your Ad which is what i entered into the form except it is not passing the category, subcategory info that was selected from the two previous pages. and, in the table the data goes into needs to have a category and subcategory id. also, i don't know why i am getting the next_,Submit Your Ad values passed. again, i really appreciate your time. best regards, addison ellis

On Sunday 26 January 2003 14:31, Addison Ellis wrote:

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)

Are you saying that now $formdata is empty?? If it is, where are you getting $formdata from? [snip]

    $result = mysql_query($query)
         or die ("Couldn't execute query.");

Don't use die(), use: $result = mysql_query($query)

    or echo "Couldn't execute query. " . mysql_error();

-- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* "Now here's something you're really going to like!" -- Rocket J. Squirrel */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 addison@bellsouth.net info@smipco.com subsidiaries of small independent publishing co. info@gloabaldog.com info@momandpocentral.com