using $_POST in multiple SQL queries on Different pages
Posted: Wed Mar 04, 2009 12:18 pm
Hi
I am using
$getjob = $_POST['job'];
to use in my sql query and it works fine for one of my forms, but I have just tried to use it again in the same way but it doesnt work.
Can I not use this same variable across my site? The code I am using is below, this code produces no errors but doesnt shows a blank table.
thanks
I am using
$getjob = $_POST['job'];
to use in my sql query and it works fine for one of my forms, but I have just tried to use it again in the same way but it doesnt work.
Can I not use this same variable across my site? The code I am using is below, this code produces no errors but doesnt shows a blank table.
Code: Select all
$getjob=$_POST['job'];
$query1 = "SELECT * FROM Job_Spec WHERE Project_Name ='$getjob'";
$result1 = mysql_query($query1);
$colcnt1 = 0;
while ($row1 = mysql_fetch_array($result1,MYSQL_ASSOC)) {
{
if (!$colcnt1)
{
$colcnt1 = 7;
}
$colcnt1--;{
$Name1 = $row1['Name'];
$Java1 = $row1['Java'];
$Leadership1 = $row1['Leadership'];
$Communication1 = $row1['Communication'];
$Teamwork1 = $row1 ['Team_Work'];
$Problem_Solving1 = $row1['Problem_Solving'];
}
}
}
{thanks