Re: empty query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

> >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! 

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux