hi
dont really know how to explain it so i'll just show the code
what i need it to do is
$_get information from the url that is stored in a variable
for example
abc=1,bcd=2
(load abc and bcd in a while loop from database)
set $name=$_get[$variable]
display the name then wipe before movin on to the next variable in the database
this is where the information is sent
and this is the section where its supposed pick it up
i know this method isnt very secure but at the moment i just need this working can anyone help
dont really know how to explain it so i'll just show the code
what i need it to do is
$_get information from the url that is stored in a variable
for example
abc=1,bcd=2
(load abc and bcd in a while loop from database)
set $name=$_get[$variable]
display the name then wipe before movin on to the next variable in the database
this is where the information is sent
Code:
while($row = mysql_fetch_array($result)) {
$ddriver=$row['driver'];
echo"<br> Enter $ddriver 's Hours For $date <input type='text' name='$ddriver' value='0' size='5'>";
};
echo"<br><input type='submit' value='Generate Preview Profit Loss Sheet For $date'></form>";
Code:
$query="SELECT * FROM `drlist`";
$result=mysql_query($query);
while($row = mysql_fetch_array($result)) {
$dname=$row['dname'];
$dhourrate=$row['dhourrate'];
$ddriver=$_GET [$dname];
echo "$dname,$ddriver, test ,$dhourrate";
if ($ddriver<>'') {
$driverwork=$ddriver-0.75;
$drivercost=$driverwork*$dhourrate;
echo " Driver $dname, Hours After Break = $driverwork, Driver Cost @ $dhourrate per hour =
$drivercost";};
$ddriver='';
};
};
Comment