[Resolved] Value not passing between forms

[lmayer4]

I'm a little confused here, I thought this would work. Obviously not. I have a form that selects a facility does some stored procs then passes the value of the selected facility to the next page. The last thing is whats not happening.

this is the select peice:

mssql_connect('HQMSDB05');
// assuming db connection already exists - do query
$q = mssql_query('select distinct Source from Yardcheck.dbo.tblM5UpLoad order by Source');
if (mssql_num_rows($q) > 0):
print '<select name="Source" size="1">';
for ($i=0; $cust = mssql_fetch_array($q); ++$i):
print '<option value='.urlencode($cust["Source"]).'>'.$cust["Source"].'</option>';
endfor;
print '</select>';

This is the select statement:

/ construct and run our query /
$sql = "SELECT * FROM Yardcheck.dbo.tblFailedUpLoad where Source = '".urldecode($_REQUEST['Source'])."'order by TrailerID";

I'm sure it's something simple, I also have been thinking today was Wednesday.

Thanks for any help

Laura

[thorpe]

where is the code that passes this stuff to the next page?

[lmayer4]

I've added it as atachment

[lmayer4]

Okay I figured it out. Since it was posting to itself to begin with then doing some Stored proces THEN using a header to push it to the next page I needed sessions.

Works fine now.

Thanks for looking.

Laura