Error - Problem displaying data in"; echo " minutes table

"; echo "Please click "; echo "here"; echo " to reload this page, or your browser's Bacl key to try again."; } #@$rows = pg_NumRows($result); $rows=mysql_num_rows($result); $row=mysql_fetch_assoc($result); echo "

Meeting minutes titled '",$row["title"]."'

"; echo "

";
		echo $row["info"];
		echo "


Now for the regular page...
"; closedbconn(); } } function displayMinutes() { $connection = getdbconn(); if (!$connection) { echo "Whoops! an error occured. Sorry.\n"; } $sql = "SELECT * FROM minutes;"; //$result = pg_exec ($connection, $sql); //$rows = pg_NumRows($result); $result = mysql_query ($sql); #or die ("BAD Query for Minutes:
\n"); $rows = mysql_num_rows($result); if (!$result) { echo "

Error - no minutes items registered!?!

\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "


\n"; echo "\n"; echo "\n"; echo "\n"; exit; } echo "

Installfest Minutes ($rows\n"; if ($rows == 1) { echo " item).

\n"; } else { echo " items).\n"; } if ($rows > 0) { echo "
\n"; echo "
"; #for ($i=0; $i < $rows; $i++) { while ($row=mysql_fetch_assoc($result)) { #$id = pg_result($result, $i, "id"); #$title = pg_result($result, $i, "title"); $id = $row["id"]; $title = $row["title"]; echo "Display entry with title '$title'\n"; echo "
"; } echo "
"; closedbconn(); } } function dumpToDo() { global $DARKGREEN, $WHITE, $FIREBRICK; global $connmgr_connectionid; $connection = getdbconn(); //echo "DEBUG: Connect-> ".$connection."
\n"; //if (!$connection) { // echo "Whoops! an error occured. Sorry.\n"; //} $sql = "select * from todo"; //@$result = pg_exec ($connection, $sql); //@$rows = pg_NumRows($result); #$dbconn=mysql_select_db("linuxsa", $connection); $result = mysql_query ($sql) or die ("Bad TODO query".mysql_error());; $rows = mysql_num_rows($result); if (!$result) { echo "

Error - no todo items registered!?!

\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "


\n"; echo "\n"; echo "\n"; echo "\n"; exit; } echo "

Installfest TO DO list ($rows\n"; if ($rows == 1) { echo " item).

\n"; } else { echo " items).\n"; } if ($rows > 0) { echo "
\n\n\n
"; //for ($i=0; $i < $rows; $i++) { while ($row=mysql_fetch_assoc($result) ) { $id = $row["id"]; $name=$row["name"]; $email=$row["email"]; $completed=$row["completed"]; $text=$row["text"]; if ($completed == "FALSE") { $completed = "NOT COMPLETED"; $maincolour = $FIREBRICK; } else { $completed = "COMPLETED"; $maincolour = $DARKGREEN; } #echo "DEBUG: Main Color-> $maincolour\n"; #the following couple of lines are just bad... #box ($maincolour, $WHITE, $WHITE, $maincolour, "
\nAction Item $idSubmitter: $name ($email)$completed
", $text); box ($maincolour, $maincolour, $WHITE, $maincolour, "
\nAction Item $idSubmitter: $name ($email)$completed
", $text); } echo "
"; //closedbconn(); } } function helperspage() { global $webmonkey; processAdminRequests(); echo "

Helper or organiser page

\n"; echo "Update (5/12/2002): The helpers page for the installfest has been broken at times,\n"; echo "however we could still use your help.\n"; echo "We will be at Enterprise House, 139 Greenhill Road from 8 AM in the \n"; echo "morning and we hope to hold a \"helpers meeting\" at 9:30 AM at the \n"; echo "latest.

\n"; echo "We need all types of help, including installers, people to help at the \n"; echo "registration desk...even people who can point people in the right direction or make tea/coffee for us and make \n"; echo "sure we don't overwork ourselves.

\n"; echo"To be a helper just come along and talk to the person at the registration desk.

\n"; echo" Rest of the page

\n"; echo "This page is for people who would like to help out at the installfest, either by helping to organise the event, or by helping out on the day by installing and/or configuring Linux and/or FreeBSD on other peoples' PCs\n

\n"; echo "

\n"; dumpToDo(); displayMinutes(); } display("sidebar", "helperspage"); ?>