simple equestion

aayatoos

if i want to know the department no of an employee and store it in a variable how can i do it if i am using this eql query

$result = mysql_query("SELECT dep_no FROM employees where emp_id = $id",$db);

and is there any way to use the variable that stored the department_no in the second form without using sumbit and also without using the session variable

bastien

not quite clear on what you want /need...

you want to use the value from the query and place it into another form without using sessions?

you could include it in a hidden field

you could place the value into a cookie

aayatoos

no it is not what i mean
i want to put the result of the sql query in to a variable and pass that variable to next form without using submit or session variable
how could i do it

LordShryku

Put it in the URL as a $_GET variable.

bastien

you don't want to pass is to the next form...you want to pass it thru the next form...

then as suggested by LordShryku, place the variable into the URL

aayatoos

how can i Put it in the URL as a $_GET variable?
i want the code for the page that have the variable value and the page that will use the vaiable value
thanks

keith73

you pass it in the URL like this:

in page1.php

$result = mysql_query("SELECT dep_no FROM employees where emp_id = $id",$db);
$url = "page2.php?dep_no=" . mysql_result($result,'dep_no');
header("Location: $url");

in page2.php

<input type="hidden" name="dep_no" value="<?php echo $_GET['dep_no']; ?>">

keith

aayatoos

i do the what you write and it display an error telling me that the header is already sent out
what do they mean by that and is there any why to sent it without using any header.

thanks

laserlight

it display an error telling me that the header is already sent out

well, that means your script outputs something before the header(), e.g. writing <html>, or having a blank line at the top of the script.

header() must be called before all those, or you have to use output buffering.