Re: Pulling information out of a MySQL database
| From: | Tim Thorburn | Date: | Mon, 26 Nov 2001 04:57:53 +0000 |
| Subject: | Re: Pulling information out of a MySQL database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-75696@lists.php.net to get a copy of this message | ||
Hi again,
Ok, I've heard some suggestions to my problem ... but I'm not entirely certain how to incorporate them, perhaps taking a look at the code would be helpful.
Again, the problem I'm having is as follows. I have a simple form in which the user selects a month and year from two drop down menu's - based on their choice, the following PHP script searches a MySQL database and displays a basic listing (event name and date) for the selected month. Then the user has the option to click an event name and receive a more detailed listing of the event - this is the portion that isn't working.
It seems that the script is forgetting the values entered by the user - I have come to this conclusion as when I replaced ".$month." and ".$year." with an actual month and year ie. 'November' and '2001' respectively, the detailed display works perfectly.
How can I get both the basic and detailed event listings working at the same time?
Thanks
-Tim
<?
$db = mysql_connect("localhost", "login", "password");
mysql_select_db("edoinfo",$db);
if ($id) {
// query for extented information
$result = mysql_query("SELECT *, DATE_FORMAT(EventStartDate, '%W %M %D %Y') AS FormattedEventStartDate, DATE_FORMAT(EventEndDate, '%W %M %D %Y') AS FormattedEventEndDate, TIME_FORMAT(EventStartTime, '%r') AS FormattedEventStartTime, TIME_FORMAT(EventEndTime, '%r') AS FormattedEventEndTime FROM comcal WHERE id=$id and EventMonth='".$month."' and EventYear='".$year."'",$db);
$myrow = mysql_fetch_array($result);
//display extended information
echo "<table width='65%' border='0' cellspacing='2' cellpadding='2'>";
echo "<tr>";
echo "<td valign='top' align='left'><b>Event: </b></td>";
echo "<td valign='top' align='left'>";
echo ($myrow["EventName"]);
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td valign='top' align='left'><b>Location: </b></td>";
echo "<td valign='top' align='left'>".($myrow["EventLocation"])."</td>";
echo "</tr>";
echo "<tr>";
echo "<td valign='top' align='left'><b>City: </b></td>";
echo "<td valign='top' align='left'>".($myrow["EventCity"]).", ".($myrow["EventState"])."</td>";
echo "</tr>";
echo "<tr>";
echo "<td valign='top' align='left'><b>Time: </b></td>";
echo "<td valign='top' align='left'>".($myrow["FormattedEventStartTime"])."</td>";
echo "</tr>";
echo "<tr>";
echo "<td valign='top' align='left'><b>Date: </b></td>";
echo "<td valign='top' align='left'>".($myrow["FormattedEventStartDate"])."</td>";
echo "</tr>";
echo "<tr>";
echo "<td valign='top' align='left'><b>Contact Person(s): </b></td>";
echo "<td valign='top' align='left'>".($myrow["EventC1FN"])." ".($myrow["EventC1LN"])."<br>".($myrow["EventC2FN"])." ".($myrow["EventC2LN"])."</td>";
echo "</tr>";
echo "<tr>";
echo "<td valign='top' align='left'><b>Phone: </b></td>";
echo "<td valign='top' align='left'>".($myrow["EventC1ACPhone"]).".".($myrow["EventC1ExcPhone"]).".".($myrow["EventC1ExtPhone"])." ";
echo "<br>".($myrow["EventC2ACPhone"]).".".($myrow["EventC2ExcPhone"]).".".($myrow["EventC2ExtPhone"])." ";
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td valign='top' align='left'><b>Fax: </b></td>";
echo "<td valign='top' align='left'>".($myrow["EventACFax"]).".".($myrow["EventExcFax"]).".".($myrow["EventExtFax"])."</td>";
echo "</tr>";
echo "<tr>";
echo "<td valign='top' align='left'><b>Cell: </b></td>";
echo "<td valign='top' align='left'>".($myrow["EventACCell"]).".".($myrow["EventExcCell"]).".".($myrow["EventExtCell"])."</td>";
echo "</tr>";
echo "<tr>";
echo "<td valign='top' align='left'><b>Email: </b></td>";
echo "<td valign='top' align='left'><a href='mailto:".($myrow["EventEmail"])."'>".($myrow["EventEmail"])."</a></td>";
echo "</tr>";
echo "<tr>";
echo "<td valign='top' align='left'><b>Web: </b></td>";
echo "<td valign='top' align='left'><a href='".($myrow["EventWeb"])."'>".($myrow["EventWeb"])."</a></td>";
echo "</tr>";
echo "<tr>";
echo "<td valign='top' align='left'><b>Description: </b></td>";
echo "<td valign='top' align='left'>".($myrow["EventDescription"])."</td>";
echo "</tr>";
echo "<tr>";
echo "<td valign='top' align='left'><b>Cost: </b></td>";
echo "<td valign='top' align='left'>".($myrow["EventCost"])."</td>";
echo "</tr>";
echo "<tr>";
echo "<td valign='top' align='left'><b></b></td>";
echo "<td valign='top' align='left'> </td>";
echo "</tr>";
echo "<tr>";
echo "<td valign='top' align='left'><b></b></td>";
echo "<td valign='top' align='left'> </td>";
echo "</tr>";
echo "</table>";
} else {
//display basic information from user input form
$result = mysql_query("SELECT *, DATE_FORMAT(EventStartDate, '%W %M %D %Y') AS FormattedEventStartDate, TIME_FORMAT(EventStartTime, '%r') AS FormattedEventStartTime FROM comcal WHERE EventMonth='".$month."' and EventYear='".$year."' ORDER BY EventStartDate",$db);
if ($myrow = mysql_fetch_array($result)) {
echo "<table width=65% border=0 cellspacing=2 cellpadding=2>";
do {
echo "<tr>";
echo "<td valign='top' align='left'>";
echo "<a href=";
echo "$PHP_SELF?id=";
echo ($myrow["id"]);
echo ">";
echo ($myrow["EventName"]);
echo "</a>";
echo "</td>";
echo "<td valign='top' align='left'>";
echo "<font size='1'>";
echo ($myrow["FormattedEventStartDate"]);
echo "</font>";
echo "</td>";
echo "</tr>";
} while ($myrow = mysql_fetch_array($result));echo "</table>";
} else {
// no records to display
echo "Sorry, there are no events scheduled for this month";
}} ?>