I am running a query in a php page that is coming back with no results.
When I run the same query in MySQL Console, it gives the results. Any
thoughts?
mysql_select_db($database_Fund, $Fund);
$query_rsRegisteredClasses = sprintf("SELECT tlogin.FirstName,
tlogin.LastName, tcourse.Name, tschedule.Date, tschedule.StartTime,
tschedule.EndTime, tlogin.LoginName FROM ((tregistration INNER JOIN
tschedule ON tregistration.ScheduleUID = tschedule.ScheduleUID) INNER JOIN
tlogin ON tregistration.StudentUID = tlogin.LoginUID) INNER JOIN tcourse ON
tschedule.CourseUID = tcourse.ClassID WHERE tlogin.LoginName = '%s'",
$user_rsRegisteredClasses);
$rsRegisteredClasses = mysql_query($query_rsRegisteredClasses, $Fund) or
die(mysql_error());
$row_rsRegisteredClasses = mysql_fetch_assoc($rsRegisteredClasses);
$totalRows_rsRegisteredClasses = mysql_num_rows($rsRegisteredClasses);
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
