MySQL Statement Failing in PHP
| From: | Dominic | Date: | Thu, 23 Jan 2003 18:43:25 +0000 |
| Subject: | MySQL Statement Failing in PHP | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-18050@lists.php.net to get a copy of this message | ||
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);