Records Not Showing Up
Posted: Thu Jan 01, 2009 4:15 pm
I am having a problem with the following page:
http://www.kidsnightonbroadway.com/kids ... _month.php
When I enter new Broadway shows they show up without any problem, however, for Off-Broadway shows despite having added several more records, I continue to get only the 2 shows presently listed. Does anyone have any suggestions as to what might be wrong in my code?
Here are my queries:
Here is how I am trying to display the results:
http://www.kidsnightonbroadway.com/kids ... _month.php
When I enter new Broadway shows they show up without any problem, however, for Off-Broadway shows despite having added several more records, I continue to get only the 2 shows presently listed. Does anyone have any suggestions as to what might be wrong in my code?
Here are my queries:
Code: Select all
<?php require_once('Connections/KidsNightOnBroadway.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
?>
<!-- Broadway show query -->
<?php
mysql_select_db($database_KidsNightOnBroadway, $KidsNightOnBroadway);
$query_Broadway_Shows = "SELECT shows.showName, shows.sortName, shows.broadwayOffbroadway, events.eventDate FROM shows, events WHERE shows.show='1' AND shows.broadwayOffbroadway='Broadway' AND shows.showCode = events.showcode AND events.eventDate >= curdate() ORDER BY events.eventDate, shows.sortName";
$Broadway_Shows = mysql_query($query_Broadway_Shows, $KidsNightOnBroadway) or die(mysql_error());
$row_Broadway_Shows = mysql_fetch_assoc($Broadway_Shows);
$totalRows_Broadway_Shows = mysql_num_rows($Broadway_Shows);
?>
<!-- Off Broadway show query -->
<?php
mysql_select_db($database_KidsNightOnBroadway, $KidsNightOnBroadway);
$query_OffBroadway_Shows = "SELECT shows.showName, shows.sortName, shows.broadwayOffbroadway, events.eventDate FROM shows, events WHERE shows.show='1' AND shows.broadwayOffbroadway='Off Broadway' AND shows.showCode = events.eventCode and events.eventDate >= curdate() ORDER BY events.eventDate, shows.sortName";
$OffBroadway_Shows = mysql_query($query_OffBroadway_Shows, $KidsNightOnBroadway) or die(mysql_error());
$row_OffBroadway_Shows = mysql_fetch_assoc($OffBroadway_Shows);
$totalRows_OffBroadway_Shows = mysql_num_rows($OffBroadway_Shows);
?>
<?
$sortName=$_GET['sortName']
?>
<?php
mysql_select_db($database_KidsNightOnBroadway, $KidsNightOnBroadway);
$query_getShow = "SELECT * FROM shows WHERE shows.sortName='$sortName'";
$getShow = mysql_query($query_getShow, $KidsNightOnBroadway) or die(mysql_error());
$row_getShow = mysql_fetch_assoc($getShow); $totalRows_getShow = mysql_num_rows($getShow);
?>Code: Select all
<table width="100%" border="0" cellspacing="0" cellpadding="10">
<tr>
<td width="33%"><strong>Show Date</strong></td>
<td width="67%"><strong>Show Name</strong></td>
</tr>
<?php do { ?> <tr>
<td><?php echo $row_Broadway_Shows['eventDate'] ?></td>
<td><em><a href="kids_display_show.php?sortName=<?php echo $row_Broadway_Shows['sortName']?>"><?php echo $row_Broadway_Shows['showName'] ?></a></em></td>
</tr><?php } while ($row_Broadway_Shows = mysql_fetch_assoc($Broadway_Shows)); ?>
</table>
<p><strong>Off-Broadway Shows</strong></p>
<table width="100%" border="0" cellspacing="0" cellpadding="10">
<tr>
<td width="33%"><strong>Show Date</strong></td>
<td width="67%"><strong>Show Name</strong></td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_OffBroadway_Shows['eventDate'] ?></td>
<td><em><a href="kids_display_show.php?sortName=<?php echo $row_OffBroadway_Shows['sortName']?>"><?php echo $row_OffBroadway_Shows['showName'] ?></a></em></td>
</tr>
<?php } while ($row_OffBroadway_Shows = mysql_fetch_assoc($OffBroadway_Shows)); ?>
</table>