Location: PHPKode > projects > Pet Grooming Management System > pet/viewschedule.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<title>PGMS Pick the Groomer</title>
$operator =$_COOKIE['user'];
require ('name.inc');
require ('header.inc');
require ('info.inc');
mysql_connect('localhost',$r,$p) or die("Could not connect to Host.");
mysql_select_db($d) or die("Could not select database.");
$query = "select * 
          from users
					where censtatus = 'a'
					order by lname";
$result = mysql_query($query);
$numUsers = mysql_num_rows($result);
for ($i=0; $i<$numUsers; $i++) 
 $row = mysql_fetch_array($result);
 $id[$i] = $row['user'];
 $lname[$i] = $row['lname'];
 $fname[$i] = $row['fname'];
echo'<h2><font color = "green">Select the groomer;</font color = "black"></h2><br>';
echo'<form action="viewschedule1.php" method="post">';
echo'<select name="groomer">';
echo'<option value="all">All</option>';
for ($i=0; $i<$numUsers; $i++) 
 echo'<option value="'.$id[$i].'">'.$fname[$i].' '.$lname[$i].'</option>';  
echo'<button type="submit">Go</button>';
Return current item: Pet Grooming Management System