Jump to content


Photo

Small error..can't find it


  • Please log in to reply
4 replies to this topic

#1 corc

corc
  • Members
  • Pip
  • Newbie
  • 5 posts
  • LocationUNCA

Posted 23 September 2006 - 07:16 PM

Alright so I've got this really simple script:
<table width="80%" cellpadding="0" cellspacing="0" border="0" class="news">
<tr><td><b>Meet Name:</b></td><td><b>Date:</b></td><td><b>Location:</b></td><td><b>Results:</b></td></tr>

<?php

// Display current schedule
	include("./pk2/db.php");
	include("./pk2/db2.php");

	$readschedule = 'SELECT event, date, date_int, location, res_query, res_link FROM park_schedule ORDER BY date_int 

ASC';

	if ($readsched1 = mysql_query ($readschedule)) {
		while ($row = mysql_fetch_array ($readsched1)) {
			print ("<tr>\n");
			print ("<td>{$row['event']}</td>\n");
			print ("<td>{$row['date']}</td>\n");
			print ("<td>{$row['location']}</td>\n");
			print ("<td>");
// If results posted, make link.
			if ({$row['res_query']} == 1) {
				print ("<a href=\"{$row['res_link']}\">Results</a>");
			} else {
				print ("Results Not Available");
			}
			print ("</td>\n</tr>");
		}
	} else {
		die ('<p>Could not retrieve the data because: <b>' . mysql_error() . "</b></p><p>The query 

was:<br>$readschedule</p>");
	}

	mysql_close();

?>
</table>

And there's some stupid little typo in it somewhere that's causing it to not work. I just need a little help finding it..I've been staring at this for like 2 hours now.

#2 Orio

Orio
  • Staff Alumni
  • Advanced Member
  • 2,491 posts

Posted 23 September 2006 - 08:18 PM

So... What's the problem with it?

Orio.
Think you're smarty?

(Gone until 20 to November)

#3 newb

newb
  • Members
  • PipPipPip
  • Advanced Member
  • 454 posts

Posted 23 September 2006 - 08:38 PM

whats the error lolz.

#4 corc

corc
  • Members
  • Pip
  • Newbie
  • 5 posts
  • LocationUNCA

Posted 24 September 2006 - 07:17 PM

Well this little script is on a larger page, and I get a completely blank screen. When I comment it out the page shows up fine (less the script).

#5 corc

corc
  • Members
  • Pip
  • Newbie
  • 5 posts
  • LocationUNCA

Posted 25 September 2006 - 08:51 PM

Anyone? Any ideas?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users