Code: Select all
$sql = "SELECT * FROM `qcheck` WHERE jobno = $jid";
$result2 = mysql_query ($sql) or die ("Query failed");
while ($row = mysql_fetch_array ($result2)) {
echo '<tr>';
echo '<td>'. $row[1] .'</td>';
echo '<td>'. $row[2] .'</td>';
echo '<td>'. $row[3] .'</td>';
echo '<td><a href = chapw_report.php?chap='.$row2[0].'&pid='.$row[4].'>'. $row2[0] .'</a></td>';
}
}$cid = $HTTP_GET_VARS['chap'];
$pid = $HTTP_GET_VARS['pid']; and then proceed with my reports.
Now for example if $row[0] returns something like "Spindle" then the data passed thru url is like this
chapw_report.php?chap=spindle&pid=12421
so i dont have any problems with processing BUT if my $row[4] returns something like "Master Cylinder" then the whole keyword is not sent and the url looks like this
chapw_report.php?chap=master
How can i overcome this?