query result records stored as variable

[cjhowe]

I am just totally dense today. I need the result of a query stored as a collumn that will be put into a large text box in the following page...ie.

$_POST['City'] = do {
echo $row_Recordset1['City']; "/n";
} while ($row_Recordset1 = mysql_fetch_assoc ($Recordset1));

but this is invalid...

[laserlight]

Why not get the following page to query for that info then?

If you want to do it this way, you'll probably need sessions or cookies, e.g.

$row_Recordset1 = mysql_fetch_assoc ($Recordset1);
$_SESSION['City'] = $row_Recordset1['City'] . "\n";

Otherwise, the user would have to go to the next page via an appropriate hyperlink, or by submitting a form.

[cjhowe]

In my denseness....I didn't fully explain the situation. The variables that are being posted with the $POST are being input into a pdf file using php's tools to do so. The pdf form that this is being posted to has a narrative section that needs a listing of items....ie City from a query that is on the same page where I'm posting with $POST.