Pass query result into a variable and use it in additional query?

[Apollo6]

I have the following query that is using a variable from a previous page (User Input AS $ss_num):

$query1 = "SELECT Emp_hed.emph_emp_code
FROM Emp_hed
WHERE ((Emp_hed.emph_ssc_nbr)='$ss_num')";

$result1 = odbc_exec($connect, $query1);

The results will be a SINGLE record, Employee#. I then want to use the results to execute an additional query:

$query2 = "SELECT whatever...
FROM table...
WHERE field='$result1'";

I am not returning any results from my second query??? I can echo $result1 and it is getting the data but when used in the second query, it seems as if it is empty???

Thanks in advance for any help.

 

[sleipnir214]

The general order of operations for database access in PHP is:[ol][li]Connect to the database, getting a database handle.[/li][li]Issue a query into the database handle, getting a resource handle.[/li][li]Fetch data from the resource handle.[/li][/ol]

$result1 is not data from the query -- it is a handle to the result set. You haven't actually fetched any data.

Take a look at odbc_fetch_row() (

http://www.php.net/manual/en/function.odbc-fetch-row.php)

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Apollo6]

sleipnir214:

That was the ticket!!!

Still learning...Thanks for the help!