Major Problem

inbowns

When I use the following select statement I get no data. In my option box.

"SELECT * FROM employees WHERE user_name = '$process' ";

(the $process variable is for the option box)

if I select the data like this it fills in my option box.

"SELECT * FROM employees ORDER BY user_name ASC ";

If this is unclear i can send the whole script.

OhLordy

do echo $process to see what is in the variable $process.

inbowns

Thanks Ohlordy but it's printing nothing. You see the select statement needs to have data in it so the $process variable can echo. But it seems like this variable is wiping out whatever this select statement is showing.

laserlight

so the $process variable can echo

hmm... are you trying to store the result in $process then?

cos you look like you're using $process as a value by which to return particular rows.
Now, if echo $process; prints nothing, then $process contains a NULL value.
So, unless you have rows in which the user_name field is NULL, you will not retrieve any rows.

inbowns

Thank you all I figured it out.