Could not execute query: $query");
//echo "How many rows returned: ".$numOfRows."
";
//******** Assigning the sql results to a numbered array of associative arrays
$i = 0;
while ($SqlArray = mysql_fetch_array($result_of_query))
{
/* print $SqlArray['timeStart'];
print "
";*/
//****THIS ISN"T WORKING; I was trying to number the arrays with the weekday number, I'm trying to use strtotime to convert from mysql string format to epoch time stamp and then to the weekday number
$q = strftime('%u',(strtotime($SqlArray['date'])));
$queried[$q]= array
(timeStart => $SqlArray['timeStart'],
date => $SqlArray['date'],
timeEnd => $SqlArray['timeEnd'],
hoursId => $SqlArray['hoursId'],
timeStamp => $SqlArray['timeStamp'],
name => $SqlArray['name']
);
$i++;
}
$name = $queried[0]['name'];
// to prevent people from putting bogus numbers in empId get variable
if (isset ($name))
{
echo ' Hours for '.$name.'
';
echo '
';
}
else
{
exit;
}
?>