Thank you for ur advise that what i have right now
<?php
$error = "Could not connect to the database";
mysql_connect('localhost','root','') or die($error);
mysql_select_db('learningcenter') or die($error);
$query = "SELECT scheduletime from tutorschedule where tutorid=$tutorid";
$result = mysql_query($query);
$row=mysql_fetch_assoc($result);
$scheduletime = $row['scheduletime'];
echo"<table border='1'>";
echo"<tr>";
echo"<td>$scheduletime</td>";
echo"</tr>";
echo"</table>";
?>
that show me the time of each tutor, my next question will be how set up the code in order to show available and unavailble time?? do i need another field??
Again thank you
I was thinking if i have another two fields like Open and Close type TINYINT as a link
echo"<table border='1'>";
echo"<tr><td>Schedule</td><td>Close</td><td>Open</td></tr>";
echo"<tr>";
echo"<td>$scheduletime</td>";
echo"</tr>";
echo"</table>";
wHAT U THINK??
<?php
$error = "Could not connect to the database";
mysql_connect('localhost','root','') or die($error);
mysql_select_db('learningcenter') or die($error);
$query = "SELECT scheduletime, open , close from tutorschedule where tutorid=$tutorid";
$result = mysql_query($query);
$row=mysql_fetch_assoc($result);
$scheduletime = $row['scheduletime'];
$open = $row['open'];
$close =$rwo['close'];
echo"<table border='1'>";
echo"<tr><td>Schedule</td><td>Open</td><td>Close</td></tr>";
echo"<tr>";
echo"<td>$scheduletime</td><td>$open</td><td>$close</td>";
echo"</tr>";
echo"</table>";
?>
Linear Mode
