I have the following code, and it works great, except it returns each item 7 times.
<?php
$db = mysqlconnect($mysqlHost,$mysqlUser,$mysqlPass)
or die("Failed to connect to host, {$mysqlHost}, using user name {$mysqlUser}.");
mysqlselectdb("php",$db)
or die("Unable to select database 'php' on {$mysqlHost}.");
$result = mysqlquery("SELECT ID,Name,Place,Date FROM worktimer WHERE ClockOut='00:00:00'");
if ($result) {
$row = mysqlfetcharray($result);
while(next($row) != false) {
echo " <p><input type=\"radio\" name=\"Record\" value=\"".$row["ID"]."\">".$row["Name"]." at ".$row["Place"]." on ".$row["Date"]."<br>\r";
}
}
?>
PLEASE HELP ME !!
thanks, AP
Enter your message below
Sign in or Join us (it's free).