what is wrong with this code?

searls03 · March 13, 2011

here is code:

<?php
session_start(); // Must start session first thing
/* 
Created By Adam Khoury @ www.flashbuilding.com 
-----------------------June 20, 2008----------------------- 
*/
// Here we run a login check
if (!isset($_SESSION['id'])) { 
   echo 'Please <a href="login.php">log in</a> to access your account';
   exit(); 
}
//Connect to the database through our include 
include_once "connect_to_mysql.php";
// Place Session variable 'id' into local variable
$userid = $_SESSION['id'];
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$name = $row["name"];
$phone = $row["phone"];
$username = $row["username"];
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$cell = $row["cell"];
$email = $row["email"];
$accounttype = $row["accounttype"];
$rank = $row["rank"];
$badges = $row["badges"];
}
// Set error message as blank upon arrival to page
$errorMsg = "";
// First we check to see if the form has been submitted 
if (isset($_POST['username'])){
$name = ereg_replace("[^A-Z a-z0-9]", "", $_POST['name']); // filter everything but numbers and letters
$phone = ereg_replace("[^A-Z a-z0-9]", "", $_POST['phone']); // filter everything but spaces, numbers, and letters
$username = ereg_replace("[^A-Z a-z0-9]", "", $_POST['username']); // filter everything but spaces, numbers, and letters
$address = ereg_replace("[^A-Z a-z0-9]", "", $_POST['address']); // filter everything but spaces, numbers, and letters
$city = ereg_replace("[^A-Za-z0-9]", "", $_POST['city']); // filter everything but lowercase letters
$state = ereg_replace("[^A-Za-z0-9]", "", $_POST['state']); // filter everything but lowercase letters
$zip = ereg_replace("[^A-Za-z0-9]", "", $_POST['zip']); // filter everything but lowercase letters
$cell = ereg_replace("[^A-Za-z0-9]", "", $_POST['cell']); // filter everything but lowercase letters
$email = stripslashes($_POST['email']);
$email = strip_tags($email);
$email = mysql_real_escape_string($email);

if((!$email)){

	$errorMsg = "You did not submit the following required information!<br /><br />";

    if(!$email){ 
       $errorMsg .= "--- Email Address"; 
    
   }
} else {		$sql = mysql_query("INSERT INTO events (name, phone, username, address, city, state, zip, cell, email) 

	VALUES('$name','$phone','$username','$address','$city','$state','$zip','$cell','$email") or die (mysql_error());

	$to = "$email";
	// Change this to your site admin email
	$from = "[email protected]";
	$subject = "Complete your registration";
	//Begin HTML Email Message where you need to change the activation URL inside
	$message = '<html>
	<body bgcolor="#FFFFFF">
	Hi ' . $username . ',
	<br /><br />
	You must complete this step to activate your account with us.
	<br /><br />
	Please click here to activate now >>
	<a href="http://www.somewebsite.com/activation.php?id=' . $id . '">
	ACTIVATE NOW</a>
	<br /><br />
	Your Login Data is as follows: 
	<br /><br />
	E-mail Address: ' . $email . ' <br />
	Password: ' . $password . ' 
	<br /><br /> 
	Thanks! 
	</body>
	</html>';
	// end of message
	$headers = "From: $from\r\n";
	$headers .= "Content-type: text/html\r\n";
	$to = "$to";
	// Finally send the activation email to the member
	mail($to, $subject, $message, $headers);
	// Then print a message to the browser for the joiner 
	print "<br /><br /><br /><h4>OK $firstname, one last step to verify your email identity:</h4><br />
	We just sent an Activation link to: $email<br /><br />
	<strong><font color=\"#990000\">Please check your email inbox in a moment</font></strong> to click on the Activation <br />
	Link inside the message. After email activation you can log in.";


	exit(); // Exit so the form and page does not display, just this success message
} // Close else after database duplicate field value checks
  } // Close else after missing vars check
//Close if $_POST


?>
<?php


// if no id is specified, list the available articles
if(!isset($_GET['eventid']))
{
   $self = $_SERVER['PHP_SELF'];

   $query = "SELECT eventid, event FROM Registration ORDER BY eventid";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list
   $description = '<ol>';
   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($eventid, $event, $date) = $row;
      $description .= "<li><a href=\"$self?eventid=$eventid\">$event</a></li>\r\n";
   }

   $description .= '</ol>';

   $Events = 'Events';
} else {
   // get the article info from database
     $query = "SELECT event, description, startdate, enddate location, subevent1, subevent2, subevent3, subevent4, subevent5, subevent6, subevent7, subevent8, price1, price2, price3, price4, price5, price6, price7, price8 FROM Registration WHERE eventid=".$_GET['eventid'];
   $result = mysql_query($query) or die('Error : ' . mysql_error());
   $row = mysql_fetch_array($result, MYSQL_ASSOC);

  $event = $row['event'];
   $description = $row['description'];
   $startdate = $row['startdate'];
     $enddate = $row['enddate'];

     $location = $row['location'];
 $subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];

$price1 = $row['price1'];
$price2 = $row['price2'];
$price3 = $row['price3'];
$price4 = $row['price4'];
$price5 = $row['price5'];
$price6 = $row['price6'];
$price7 = $row['price7'];
$price8 = $row['price8'];
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Register</title>
<style type="text/css">
#apDiv1 {
position:absolute;
left:33px;
top:320px;
width:252px;
height:48px;
z-index:1;
}
#apDiv2 {
position:absolute;
left:33px;
top:361px;
width:254px;
height:46px;
z-index:2;
}
#apDiv3 {
position:absolute;
left:33px;
top:525px;
width:256px;
height:43px;
z-index:3;
}
#apDiv4 {
position:absolute;
left:33px;
top:402px;
width:250px;
height:48px;
z-index:4;
}
#apDiv5 {
position:absolute;
left:106px;
top:616px;
width:263px;
height:255px;
z-index:5;
}
#apDiv6 {
position:absolute;
left:323px;
top:200px;
width:898px;
height:530px;
z-index:5;
}
#apDiv7 {
position:absolute;
left:33px;
top:443px;
width:266px;
height:42px;
z-index:6;
}
#apDiv8 {
position:absolute;
left:111px;
top:500px;
width:125px;
height:37px;
z-index:7;
}
#apDiv8 strong {
font-size: 24px;
}
#apDiv9 {
position:absolute;
left:33px;
top:408px;
width:267px;
height:49px;
z-index:8;
}
#apDiv10 {
position:absolute;
left:33px;
top:449px;
width:242px;
height:23px;
z-index:9;
}
#apDiv8 a {
color: #000;
}
#apDiv11 {
position:absolute;
left:101px;
top:490px;
width:168px;
height:42px;
z-index:10;
font-size: 24px;
font-weight: bold;
}
#apDiv11 a {
color: #000;
}
#apDiv12 {
position:absolute;
left:33px;
top:210px;
width:205px;
height:107px;
z-index:11;
}
#apDiv12 {
text-align: center;
}
#apDiv13 {
position:absolute;
left:33px;
top:320px;
width:248px;
height:47px;
z-index:12;
}
#apDiv {
position:absolute;
left:33px;
top:484px;
width:225px;
height:35px;
z-index:11;
}
#apDiv14 {
position:absolute;
left:33px;
top:566px;
width:298px;
height:51px;
z-index:12;
}
#apDiv15 {	position:absolute;
left:101px;
top:611px;
width:168px;
height:42px;
z-index:10;
font-size: 24px;
font-weight: bold;
}
#apDiv5 a {
font-size: 24px;
color: #000;
font-weight: bold;
}
#apDiv23 table tr td1 {
font-size: 14px;
}
</style>
<script type="text/javascript">
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
</script>

<style type="text/css">
#apDiv6 #form1 table tr th {
text-align: center;
}
#apDiv6 table tr td table tr td {
text-align: center;
}
#apDiv16 {
position:absolute;
left:330px;
top:45px;
width:208px;
height:100px;
z-index:13;
}
#apDiv6 table tr td #apDiv16 table tr th {
font-size: 36px;
}
#apDiv17 {
position:absolute;
left:183px;
top:342px;
width:427px;
height:65px;
z-index:13;
}
#apDiv6 table tr td #Accordion1 .AccordionPanel.AccordionPanelOpen .AccordionPanelContent #apDiv17 table tr th {
color: #999;
}
</style>

<style type="text/css">

#apDiv19 {
position:absolute;
left:33px;
top:320px;
width:271px;
height:33px;
z-index:13;
}
#apDiv20 {
position:absolute;
left:578px;
top:368px;
width:157px;
height:87px;
z-index:14;
}
#apDiv21 {
position:absolute;
left:8px;
top:705px;
width:270px;
height:683px;
z-index:15;
}
#apDiv22 {
position:absolute;
left:476px;
top:313px;
width:596px;
height:124px;
z-index:16;
}
#apDiv6 table tr td table tr th {
text-align: left;
}
#apDiv23 {
position:absolute;
left:626px;
top:250px;
width:247px;
height:85px;
z-index:16;
text-align: center;
font-size: 36px;
}
#apDiv23 table tr td {
text-align: center;
font-size: 24px;
}
#apDiv24 {
position:absolute;
left:626px;
top:295px;
width:247px;
height:63px;
z-index:17;
text-align: center;
font-size: 20px;
}
.klgjsa {
font-size: 18px;
}
#apDiv24 {
font-size: 16px;
}
#apDiv24 {
font-size: 18px;
}
#apDiv24 {
color: #C90;
}
</style>


</head>
<body onload="MM_preloadImages('button/pictures2.png','button/projects1.png','button/news2.png','button/eventmanager2.png','button/membermanager2.png','button/newsmanager2.png','button/myprofile2.png')">
<div id="apDiv6">
<table width="600" border="0" align="center" cellpadding="10" cellspacing="1" bgcolor="#336699">
  <tr>
  <td bgcolor="#FFFFFF"><h1 align="center"><?php echo $Events; ?></h1>
  <p> </p>
  <p> </p>
  <p><?php echo $description; ?></p>
    
  <p> </p>
    
  <p> </p>
  <?php
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$name = $row["name"];
$phone = $row["phone"];
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$cell = $row["cell"];
$email = $row["email"];
}
$sql = mysql_query("SELECT * FROM Registration WHERE eventid=".$_GET['eventid']." LIMIT 1");
while($row = mysql_fetch_array($sql)){
$event= $row["event"];
$subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];

$price1 = $row['price1'];
$price2 = $row['price2'];
$price3 = $row['price3'];
$price4 = $row['price4'];
$price5 = $row['price5'];
$price6 = $row['price6'];
$price7 = $row['price7'];
$price8 = $row['price8'];
}
?>
  <?php
// when displaying an article show a link
// to see the article list
if(isset($_GET['eventid']))
{
?>
  <div id="jQueryUIAccordion">
<h3> </h3>
<div>
	<p>

    
    <table width="575" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th width="563" bgcolor="#999999" scope="col">Location</th>
        </tr>
      </table>
    <table width="574" height="16" border="0" cellpadding="2" cellspacing="2">
      <tr>
        <th height="12" scope="col"><?php echo $location; ?></th>
        </tr>
      </table>
    <table width="573" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th width="561" bgcolor="#999999" scope="col">Description</th>
        </tr>
      </table>
    <table width="576" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th width="564" height="11" scope="col"><?php echo $title1; ?><br /><?php echo $price1; ?></th>
        <th width="564" scope="col"><?php echo $subevent1; ?></th>
        

        </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title2; ?><br /><?php echo $price2; ?></th>
        <th scope="col"><?php echo $subevent2; ?> </th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title3; ?><br /><?php echo $price3; ?></th>
        <th scope="col"><?php echo $subevent3; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title4; ?><br /><?php echo $price4; ?></th>
        <th scope="col"><?php echo $subevent4; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title5; ?><br /><?php echo $price5; ?></th>
        <th scope="col"><?php echo $subevent5; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title6; ?><br /><?php echo $price6; ?></th>
        <th scope="col"><?php echo $subevent6; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title7; ?><br /><?php echo $price7; ?></th>
        <th scope="col"><?php echo $subevent7; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title8; ?><br /><?php echo $price8; ?></th>
        <th scope="col"><?php echo $subevent8; ?></th>
      </tr>
      </table>
    <hr />
    <table width="200" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th scope="col">Price:</th>
        </tr>
      </table>
    <table width="200" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th scope="col">$<?php echo  $price; ?></th>
        </tr>
      </table>
	</p>
	<?php
if (isset($_GET['eventid'])) {
include('connect1.php');
$sql = mysql_query("SELECT * FROM Registration WHERE eventid='$eventid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$eventid = $row["eventid"];
$event = $row["event"];
$date = $row["date"];
$description = $row["description"];
$location = $row["location"];
}
$result = mysqli_query($dbcon, $query) or die('error getting data');

echo "<table>";
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
echo "<tr><td>";
echo "<a href=\"registration.php?eventid=".$_GET['eventid']."\"><ul>Register Now!</ul></a>";
echo "</td></tr>";
}
echo "</table>";

}
?>

    
    
    
    
    


  
    
    
  <div id="apDiv18"></div>
  <p align="center"><a href="<?php echo $_SERVER['PHP_SELF']; ?>">Back to Events</a></p>
    
    
    
  <?php
}
?></td></tr>
</table>


</div><div id="apDiv2"><a href="register.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image3','','button/register2.png',1)"><img src="button/register1.png" name="Image3" width="235" height="50" border="0" id="Image3" /></a></div>
<div id="apDiv4"><a href="projects.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image4','','button/projects2.png',1)"><img src="button/projects1.png" name="Image4" width="235" height="50" border="0" id="Image4" /></a></div>

<div id="apDiv11"><?php if ($accounttype == "Scout") {
echo '<a href="../logout.php">Logout</a>';} ?></div>
<div id="apDiv12"><?php echo "$accounttype"; ?>
  <p><?php echo "$name"; ?></p>
  <p>Troop 78</p>
</div>

<div id="apDiv5"><?php if ($accounttype == "Admin") {
echo "<a href=\"../logout.php\">Logout</a>";
}
?></div>


<div id="apDiv7"><a href="news.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image6','','button/news2.png',1)"><img src="button/news1.png" name="Image6" width="235" height="50" border="0" id="Image6" /></a></div>
<div id="apDiv"> <?php if ($accounttype == "Admin") {
echo "<a href=\"../search1.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image7','','../button/membermanager2.png',1)\"><img src=\"../button/membermanager1.png\" name=\"Image7\" width=\"235\" height=\"50\" border=\"0\" id=\"Image7\" /></a>";
} 
?></div>
<div id="apDiv3"><?php if ($accounttype == "Admin") {
echo "<a href=\"../eventmanager.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image8','','../button/eventmanager2.png',1)\"><img src=\"../button/eventmanager1.png\"  name=\"Image8\" width=\"235\" height=\"50\" border=\"0\" id=\"Image8\" /></a>";
}
?>
</div>
<div id="apDiv14"><?php if ($accounttype == "Admin") {
echo "<a href=\"../newsmanager.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image9','','../button/newsmanager2.png',1)\"><img src=\"../button/newsmanager1.png\"  name=\"Image9\" width=\"235\" height=\"50\" border=\"0\" id=\"Image9\" /></a>";
}
?>
</div>

<div id="apDiv19"><a href="myprofile.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image5','','button/myprofile2.png',1)"><img src="button/myprofile1.png" name="Image5" width="235" height="50" border="0" id="Image5" /></a></div>
<div id="apDiv21"><img src="button/red.png" width="282" height="687" /></div>
<div id="apDiv23"><?php echo $event; ?> <br /> 
</div>
<div id="apDiv24"><?php echo $startdate;?> <span class="klgjsa">-</span> <?php echo $enddate; ?></div>
<img name="boyscout" src="buttons/boyscout.jpg" width="1180" height="700" border="0" id="boyscout" alt="" />
</body>
</html>

here is error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a6254834/public_html/register.php on line 469

help?

PFMaBiSmAd · March 13, 2011

Your query on line 468 failed due to an error of some kind and you don't have any error checking or error reporting logic in your code to get your code to tell you if and why the query failed.

searls03 · March 13, 2011

I tried to put an error code in but can't seem to get it, can you give me a hand?

searls03 · March 13, 2011

ok got it working......now some of my echo's don't show up.............this is a pain................................... I will turn the problem purple, sorry this isn't in code tags. If this doesn't make sense, let me know and i will try to explain it better......:

<?php

session_start(); // Must start session first thing

/*

Created By Adam Khoury @ www.flashbuilding.com

-----------------------June 20, 2008-----------------------

*/

// Here we run a login check

if (!isset($_SESSION['id'])) {

echo 'Please <a href="login.php">log in</a> to access your account';

exit();

}

//Connect to the database through our include

include_once "connect_to_mysql.php";

// Place Session variable 'id' into local variable

$userid = $_SESSION['id'];

// Query member data from the database and ready it for display

$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");

while($row = mysql_fetch_array($sql)){

$name = $row["name"];

$phone = $row["phone"];

$username = $row["username"];

$address = $row["address"];

$city = $row["city"];

$state = $row["state"];

$zip = $row["zip"];

$cell = $row["cell"];

$email = $row["email"];

$accounttype = $row["accounttype"];

$rank = $row["rank"];

$badges = $row["badges"];

}

// Set error message as blank upon arrival to page

$errorMsg = "";

// First we check to see if the form has been submitted

if (isset($_POST['username'])){

$name = ereg_replace("[^A-Z a-z0-9]", "", $_POST['name']); // filter everything but numbers and letters

$phone = ereg_replace("[^A-Z a-z0-9]", "", $_POST['phone']); // filter everything but spaces, numbers, and letters

$username = ereg_replace("[^A-Z a-z0-9]", "", $_POST['username']); // filter everything but spaces, numbers, and letters

$address = ereg_replace("[^A-Z a-z0-9]", "", $_POST['address']); // filter everything but spaces, numbers, and letters

$city = ereg_replace("[^A-Za-z0-9]", "", $_POST['city']); // filter everything but lowercase letters

$state = ereg_replace("[^A-Za-z0-9]", "", $_POST['state']); // filter everything but lowercase letters

$zip = ereg_replace("[^A-Za-z0-9]", "", $_POST['zip']); // filter everything but lowercase letters

$cell = ereg_replace("[^A-Za-z0-9]", "", $_POST['cell']); // filter everything but lowercase letters

$email = stripslashes($_POST['email']);

$email = strip_tags($email);

$email = mysql_real_escape_string($email);

if((!$email)){

$errorMsg = "You did not submit the following required information!<br /><br />";

if(!$email){

$errorMsg .= "--- Email Address";

}

} else { $sql = mysql_query("INSERT INTO events (name, phone, username, address, city, state, zip, cell, email)

VALUES('$name','$phone','$username','$address','$city','$state','$zip','$cell','$email") or die (mysql_error());

$to = "$email";

// Change this to your site admin email

$from = "[email protected]";

$subject = "Complete your registration";

//Begin HTML Email Message where you need to change the activation URL inside

$message = '<html>

Hi ' . $username . ',

You must complete this step to activate your account with us.

Please click here to activate now >>

ACTIVATE NOW</a>

Your Login Data is as follows:

E-mail Address: ' . $email . ' <br />

Password: ' . $password . '

Thanks!

</body>

</html>';

// end of message

$headers = "From: $from\r\n";

$headers .= "Content-type: text/html\r\n";

$to = "$to";

// Finally send the activation email to the member

mail($to, $subject, $message, $headers);

// Then print a message to the browser for the joiner

print "<br /><br /><br /><h4>OK $firstname, one last step to verify your email identity:</h4><br />

We just sent an Activation link to: $email<br /><br />

<strong><font color=\"#990000\">Please check your email inbox in a moment</font></strong> to click on the Activation <br />

Link inside the message. After email activation you can log in.";

exit(); // Exit so the form and page does not display, just this success message

} // Close else after database duplicate field value checks

} // Close else after missing vars check

//Close if $_POST

?>

<?php

// if no id is specified, list the available articles

if(!isset($_GET['eventid']))

{

$self = $_SERVER['PHP_SELF'];

$query = "SELECT eventid, event, startdate, enddate FROM Registration ORDER BY eventid";

$result = mysql_query($query) or die('Error : ' . mysql_error());

// create the article list

while($row = mysql_fetch_array($result, MYSQL_NUM))

{

list($eventid, $event, $startdate, $enddate) = $row;

$as = "<a href=\"$self?eventid=$eventid\">$startdate - $enddate --- $event</a>\r\n";

}

$Events = 'Events';

} else {

// get the article info from database

$query = "SELECT event, description, startdate, enddate, location, subevent1, subevent2, subevent3, subevent4, subevent5, subevent6, subevent7, subevent8, price1, price2, price3, price4, price5, price6, price7, price8 FROM Registration WHERE eventid=".$_GET['eventid'];

$result = mysql_query($query) or die('Error : ' . mysql_error());

$row = mysql_fetch_array($result, MYSQL_ASSOC);

$event= $row["event"];

$subevent1 = $row['subevent1'];

$subevent2 = $row['subevent2'];

$subevent3 = $row['subevent3'];

$subevent4 = $row['subevent4'];

$subevent5 = $row['subevent5'];

$subevent6 = $row['subevent6'];

$subevent7 = $row['subevent7'];

$subevent8 = $row['subevent8'];

$title1 = $row['title1'];

$title2 = $row['title2'];

$title3 = $row['title3'];

$title4 = $row['title4'];

$title5 = $row['title5'];

$title6 = $row['title6'];

$title7 = $row['title7'];

$title8 = $row['title8'];

$price1 = $row['price1'];

$price2 = $row['price2'];

$price3 = $row['price3'];

$price4 = $row['price4'];

$price5 = $row['price5'];

$price6 = $row['price6'];

$price7 = $row['price7'];

$price8 = $row['price8'];

$date1 = $row['date1'];

$date2 = $row['date2'];

$date3 = $row['date3'];

$date4 = $row['date4'];

$date5 = $row['date5'];

$date6 = $row['date6'];

$date7 = $row['date7'];

$date8 = $row['date8'];

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Register</title>

#apDiv1 {

position:absolute;

left:33px;

top:320px;

width:252px;

height:48px;

z-index:1;

}

#apDiv2 {

position:absolute;

left:33px;

top:361px;

width:254px;

height:46px;

z-index:2;

}

#apDiv3 {

position:absolute;

left:33px;

top:525px;

width:256px;

height:43px;

z-index:3;

}

#apDiv4 {

position:absolute;

left:33px;

top:402px;

width:250px;

height:48px;

z-index:4;

}

#apDiv5 {

position:absolute;

left:106px;

top:616px;

width:263px;

height:255px;

z-index:5;

}

#apDiv6 {

position:absolute;

left:327px;

top:277px;

width:898px;

height:1097px;

z-index:5;

}

#apDiv7 {

position:absolute;

left:33px;

top:443px;

width:266px;

height:42px;

z-index:6;

}

#apDiv8 {

position:absolute;

left:111px;

top:500px;

width:125px;

height:37px;

z-index:7;

}

#apDiv8 strong {

font-size: 24px;

}

#apDiv9 {

position:absolute;

left:33px;

top:408px;

width:267px;

height:49px;

z-index:8;

}

#apDiv10 {

position:absolute;

left:33px;

top:449px;

width:242px;

height:23px;

z-index:9;

}

#apDiv8 a {

color: #000;

}

#apDiv11 {

position:absolute;

left:101px;

top:490px;

width:168px;

height:42px;

z-index:10;

font-size: 24px;

font-weight: bold;

}

#apDiv11 a {

color: #000;

}

#apDiv12 {

position:absolute;

left:33px;

top:210px;

width:205px;

height:107px;

z-index:11;

}

#apDiv12 {

text-align: center;

}

#apDiv13 {

position:absolute;

left:33px;

top:320px;

width:248px;

height:47px;

z-index:12;

}

#apDiv {

position:absolute;

left:33px;

top:484px;

width:225px;

height:35px;

z-index:11;

}

#apDiv14 {

position:absolute;

left:33px;

top:566px;

width:298px;

height:51px;

z-index:12;

}

#apDiv15 { position:absolute;

left:101px;

top:611px;

width:168px;

height:42px;

z-index:10;

font-size: 24px;

font-weight: bold;

}

#apDiv5 a {

font-size: 24px;

color: #000;

font-weight: bold;

}

#apDiv23 table tr td1 {

font-size: 14px;

}

</style>

function MM_swapImgRestore() { //v3.0

var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;

}

function MM_preloadImages() { //v3.0

var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();

var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)

if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}

}

function MM_findObj(n, d) { //v4.01

var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {

d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}

if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];

for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);

if(!x && d.getElementById) x=d.getElementById(n); return x;

}

function MM_swapImage() { //v3.0

var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)

if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}

}

</script>

<style type="text/css">

#apDiv6 #form1 table tr th {

text-align: center;

}

#apDiv6 table tr td table tr td {

text-align: center;

}

#apDiv16 {

position:absolute;

left:330px;

top:45px;

width:208px;

height:100px;

z-index:13;

}

#apDiv6 table tr td #apDiv16 table tr th {

font-size: 36px;

}

#apDiv17 {

position:absolute;

left:183px;

top:342px;

width:427px;

height:65px;

z-index:13;

}

#apDiv6 table tr td #Accordion1 .AccordionPanel.AccordionPanelOpen .AccordionPanelContent #apDiv17 table tr th {

color: #999;

}

</style>

<style type="text/css">

#apDiv19 {

position:absolute;

left:33px;

top:320px;

width:271px;

height:33px;

z-index:13;

}

#apDiv20 {

position:absolute;

left:578px;

top:368px;

width:157px;

height:87px;

z-index:14;

}

#apDiv21 {

position:absolute;

left:8px;

top:705px;

width:270px;

height:683px;

z-index:15;

}

#apDiv22 {

position:absolute;

left:476px;

top:313px;

width:596px;

height:124px;

z-index:16;

}

#apDiv6 table tr td table tr th {

text-align: left;

}

#apDiv23 {

position:absolute;

left:151px;

top:30px;

width:247px;

height:85px;

z-index:16;

text-align: center;

font-size: 36px;

}

#apDiv23 table tr td {

text-align: center;

font-size: 24px;

}

#apDiv24 {

position:absolute;

left:151px;

top:71px;

width:479px;

height:63px;

z-index:17;

text-align: center;

font-size: 20px;

}

.klgjsa {

font-size: 18px;

color: #000;

}

#apDiv24 {

font-size: 16px;

}

#apDiv24 {

font-size: 18px;

}

#apDiv24 {

color: #C90;

}

#apDiv23 {

color: #F00;

text-align: left;

}

#apDiv24 {

color: #000;

font-size: 18px;

text-align: left;

}

a:link {

color: #C90;

}

a:visited {

color: #C90;

}

a:hover {

color: #00F;

}

#apDiv6 table tr td p a {

color: #00F;

}

#apDiv25 {

position:absolute;

left:184px;

top:139px;

width:316px;

height:65px;

z-index:16;

}

.asdfsad {

color: #000;

font-size: 18px;

}

.fgsdfg {

color: #000;

font-size: 18px;

}

.adfasdf {

color: #000;

font-size: 18px;

}

.adfdas {

color: #000;

font-size: 18px;

}

afgafgd {

color: #000;

}

</style>

</head>

<div id="apDiv6">

<table width="600" border="0" align="center" cellpadding="10" cellspacing="1" bgcolor="#336699">

<tr>

<td height="1093" bgcolor="#FFFFFF"><h1 align="center"><?php echo $Events; ?></h1>

<p> </p>

<p><strong><?php echo $as; ?></strong> </p>

<p> </p>

<?php

// when displaying an article show a link

// to see the article list

if(isset($_GET['eventid']))

{

?>

<div id="jQueryUIAccordion">

<h3> </h3>

<div>

<p>

<div id="apDiv23"><?php echo $event; ?> <br />

<span class="asdfsad">Date(s):</span> <?php echo $startdate; ?> <span class="klgjsa">-</span> <?php echo $enddate; ?><br />

<span class="fgsdfg">Location:</span> <?php echo $location; ?><br />

<span class="adfasdf">Description</span><span class="adfdas">:</span> <?php echo $description; ?>

</div>

<div id="apDiv25"><?php

$sql = mysql_query("SELECT * FROM Registration WHERE eventid=".$_GET['eventid']." LIMIT 1");

while($row = mysql_fetch_array($sql)){

$event= $row["event"];

$subevent1 = $row['subevent1'];

$subevent2 = $row['subevent2'];

$subevent3 = $row['subevent3'];

$subevent4 = $row['subevent4'];

$subevent5 = $row['subevent5'];

$subevent6 = $row['subevent6'];

$subevent7 = $row['subevent7'];

$subevent8 = $row['subevent8'];

$title1 = $row['title1'];

$title2 = $row['title2'];

$title3 = $row['title3'];

$title4 = $row['title4'];

$title5 = $row['title5'];

$title6 = $row['title6'];

$title7 = $row['title7'];

$title8 = $row['title8'];

$price1 = $row['price1'];

$price2 = $row['price2'];

$price3 = $row['price3'];

$price4 = $row['price4'];

$price5 = $row['price5'];

$price6 = $row['price6'];

$price7 = $row['price7'];

$price8 = $row['price8'];

$date1 = $row['date1'];

$date2 = $row['date2'];

$date3 = $row['date3'];

$date4 = $row['date4'];

$date5 = $row['date5'];

$date6 = $row['date6'];

$date7 = $row['date7'];

$date8 = $row['date8'];

//this will echo the contents of each db row as they are iterated in the loop

#############################

if (!empty($subevent1)) { echo "<br/><strong>$title1</strong><br />$date1<br />$ $price1<br /><br />"; }

if (!empty($subevent2)) { echo "<br/><strong>$title2</strong><br />$date2<br />$ $price2<br /><br />"; }

if (!empty($subevent3)) { echo "<br/><strong>$title3</strong><br />$date3<br />$ $price3<br /><br />"; }

if (!empty($subevent4)) { echo "<br/><strong>$title4</strong><br />$date4<br />$ $price4<br /><br />"; }

if (!empty($subevent5)) { echo "<br/><strong>$title5</strong><br />$date5<br />$ $price5<br /><br />"; }

if (!empty($subevent6)) { echo "<br/><strong>$title6</strong><br />$date6<br />$ $price6<br /><br />"; }

if (!empty($subevent7)) { echo "<br/><strong>$title7</strong><br />$date7<br />$ $price7<br /><br />"; }

if (!empty($subevent8)) { echo "<br/><strong>$title8</strong><br />$date8<br />$ $price8"; }

}

//etc etc

?></div>

<p> </p>

<hr />

</p>

<?php

if (isset($_GET['eventid'])) {

include('connect1.php');

$sql = mysql_query("SELECT * FROM Registration WHERE eventid='$eventid' LIMIT 1");

while($row = mysql_fetch_array($sql)){

$eventid = $row["eventid"];

$event = $row["event"];

$date = $row["date"];

$description = $row["description"];

$location = $row["location"];

}

$result = mysqli_query($dbcon, $query) or die('error getting data');

echo "<table>";

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {

echo "<tr><td>";

echo "<a href=\"registration.php?eventid=".$_GET['eventid']."\"><ul>Register Now!</ul></a>";

echo "</td></tr>";

}

echo "</table>";

}

?>

<div id="apDiv18"></div>

<p align="center"><a href="<?php echo $_SERVER['PHP_SELF']; ?>">Back to Events</a></p>

<?php

}

?></td></tr>

</table>

</div><div id="apDiv2"><a href="register.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image3','','button/register2.png',1)"><img src="button/register1.png" name="Image3" width="235" height="50" border="0" id="Image3" /></a></div>

<div id="apDiv11"><?php if ($accounttype == "Scout") {

echo '<a href="../logout.php">Logout</a>';} ?></div>

<div id="apDiv12"><?php echo "$accounttype"; ?>

<p><?php echo "$name"; ?></p>

<p>Troop 78</p>

</div>

<div id="apDiv5"><?php if ($accounttype == "Admin") {

echo "<a href=\"../logout.php\">Logout</a>";

}

?></div>

<div id="apDiv"> <?php if ($accounttype == "Admin") {

echo "<a href=\"../search1.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image7','','../button/membermanager2.png',1)\"><img src=\"../button/membermanager1.png\" name=\"Image7\" width=\"235\" height=\"50\" border=\"0\" id=\"Image7\" /></a>";

}

?></div>

<div id="apDiv3"><?php if ($accounttype == "Admin") {

echo "<a href=\"../eventmanager.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image8','','../button/eventmanager2.png',1)\"><img src=\"../button/eventmanager1.png\" name=\"Image8\" width=\"235\" height=\"50\" border=\"0\" id=\"Image8\" /></a>";

}

?>

</div>

<div id="apDiv14"><?php if ($accounttype == "Admin") {

echo "<a href=\"../newsmanager.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image9','','../button/newsmanager2.png',1)\"><img src=\"../button/newsmanager1.png\" name=\"Image9\" width=\"235\" height=\"50\" border=\"0\" id=\"Image9\" /></a>";

}

?>

</div>

<div id="apDiv21"><img src="button/red.png" width="282" height="687" /></div>

<img name="boyscout" src="buttons/boyscout.jpg" width="1180" height="700" border="0" id="boyscout" alt="" />

</body>

</html>

Sign In

what is wrong with this code?

Recommended Posts

searls03

Link to comment

Share on other sites

PFMaBiSmAd

Link to comment

Share on other sites

searls03

Link to comment

Share on other sites

searls03

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information