A quicky:
echo "$query_rsRegisteredClasses"
To make sure the query is exactly what you are expecting. Copy the exact SQL
statement and run in MySQLAdmin sql window.
PHP to PHP, SQL statement to sql statement.
--
Scott Carr
Documentation Maintainer
http://documentation.openoffice.org
OpenOff
I think you need to do a while() loop there instead of trying to grab the
results in one shot:
$row_rsRegisteredClasses = array();
while ($row = mysql_fetch_assoc($rsRegisteredClasses)) {
$row_rsRegisteredClasses[] = $row; //populate this array with the $row array
}
That may or may not work,
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.D
