sql server - PHP Variable from one page to automatically run SQL query on other page -

i trying pass variable 1 page load query on page passed variable.

my code follows:

awaiting variable

if(isset($_post['viewrecord'])){     $sup_code = $_post['vhidden']; }

sql query

$sql = "select     sup_code, firstname, lastname, email, telephone         dbo.table sup_code = ('$sup_code')";

thanks guys, added following variable on page 2 , seemed solve issue.

$sup_code = preg_replace('/\s+/', '', $_post['vhidden']);

Dil