Re: empty query

whew! is there a tutorial you know of that might help me? in essence i have page 1 "select category," page two "select subcategory," page 3 "fill out the form, click submit," data is entered into database, user is directed to a new page. i thought from this php 4.1 book that i was doing that. :-) i guess not. anyway... thank you very much, again. addison

On Sunday 26 January 2003 18:59, Addison Ellis wrote:

correct... i am able to echo values again.

Hmm, okay :-)

i had the following to carry forward cat and subcat values: <?

    session_start();
    if (@$auth != "yes")
    {
       header("Location: login.php");
       exit();
    }
    include("config.php");
    $scobj = mysql_db_query($dbname,"select * from subcategory where

id=$subcategory")

                  or die (mysql_error());
    $scrow = mysql_fetch_object($scobj);
    $cobj =  mysql_db_query($dbname,"select * from category where

id=$scrow->category")

                 or die (mysql_error());
    $crow =  mysql_fetch_object($cobj);
    $sql = "SELECT first_name,last_name FROM accounts
                   WHERE email='$logname'";
    $result = mysql_query($sql)
                 or die (mysql_error());
    while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
    extract($row);

I don't see anything in that code which would carry the category and subcategory forward, UNLESS $scrow and $crow are registered as session variables.

again, from this new php 4.1 book, i am following the examples and guidelines. i guess that since register_globals is turned on on the server they are passing.?

I would hazard a guess and say that "next_" is the name of a button and "Submit Your Ad" is it's value? As it is part of the form and you're programmatically (or indiscriminately) extracting everything from $_POST (or equivalent) then that is why you end up with it.

how am i to get rid of it.

Don't put it into $formdata! Remember you're the one who is putting it in there!

i guess i am not sure how to keep it out of $formdata. again, the book... addison

Presumably at some point you have some code which will insert the contents of $formdata into your database. If that code is properly written then the presence (or otherwise) of "next_" should not affect its operation. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Once upon a time, four AMPHIBIOUS HOG CALLERS attacked a family of DEFENSELESS, SENSITIVE COIN COLLECTORS and brought DOWN their PROPERTY VALUES!! */ -- 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