Hello -

I'm not getting any errors on this... and the variable is passing from the
form on the other page, but I'm getting empty result sets when I know there
should be data.


<?
$link = mysql_connect ("localhost", "www", "scripts4") or die ("Could not
connect");
$db = mysql_select_db ("schileens_db") or die ("Could not select database");
?>
<TITLE>Weekday events</TITLE>
</HEAD>
<BODY>
<?
# make function #
 function display_events ()
{
# declare global variable coming from other page #
global $PHP_SELF;
# select events for this day #
$query="select msg_year, msg_month, msg_day, msg_title from
calendar_messages where CONCAT(msg_year,msg_month,msg_day) = $yyyymmdd" ;
$result=mysql_query ($query) or die ("cannot execute query");

        while ($row = mysql_fetch_array ($result))
        {
                printf ("%s %s %s %s<BR>\n", $row["msg_year"], $row["msg_month"],
$row["msg_day"], $row["msg_title"]);
        }
        mysql_free_result ($result); } ;
 ?><A href="drop5.php">back to weekday selection
</A>

Thanks in advance for any help!

Tim Wright

:::::::::::::::::::::::::::::::::::::::::::
:::                                     :::
:::   Timothy Wright                    :::
:::   mailto:[EMAIL PROTECTED]   :::
:::   Digital Network Enterprises       :::
:::   http://www.01network.com          :::
:::                                     :::
:::   secure e-mail by request          :::
:::   (PGP signature and/or encryption) :::
:::::::::::::::::::::::::::::::::::::::::::


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to