[Resolved] MySQL Query Problem

thekidscareya

I get this error:

Parse error: parse error, unexpected T_IF in /home/joel/public_html/petition/list.php on line 25

List.php


<html>
<head>
<HEAD>

<title>List</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?php

# Require Database Info
include 'mysql.php';

# Define String
$string = 'SELECT `firstname` , `lastname` , `email` , `bus` , `school` '
        . ' FROM `tblPetition` '
        . ' WHERE 1 AND `privatepolicy` = \'Yes\' AND `petition` = \'Yes\''
        . ' ORDER BY `firstname` ASC LIMIT 0, 30'; 

# Define Query
$result = mysql_query($string) or die(mysql_error())

# Error Messages
if(!$result) error_message(sql_error())

# Send out Query
$query_data = mysql_fetch_row($result)

# Number of Pages and Error Messages
$total_num_user = $query_data[0];
if(!$total_num_user) error_message('Nobody has signed the Petition!');
$page_num = $cur_page + 1;

$total_num_page = $last_page_num 
                   = ceil($total_num_user/$records_per_page);

# Define Data		   
$query_data = mysql_fetch_array($result);

# Redefine Query Results
$firstname = $query_data["firstname"];
$lastname = $query_data["lastname"];
$bus = $query_data["bus"];
$email = $query_data["email"];
$school = $query_data["school"];

# Define Total
$Total = 0;

?>
<DIV ALIGN="CENTER">
  <table width="717" border="2" align="left">
    <tr> 
      <td width="50"><strong>Petition</strong></td>
      <td width="100"><strong>First Name</strong></td>
      <td width="100"><strong>Last Name</strong></td>
      <td width="250"><strong>Email</strong></td>
      <td width="50"><strong>Bus #</strong></td>
      <td width="75"><strong>School</strong></td>
    </tr>
    <tr> 
      <td height="22"><?php echo $Total++ ?></td>
      <td><?php echo $firstname ?></td>
      <td><?php echo $lastname ?></td>
      <td><?php echo <A HREF=\"mailto:$email\">$email</A>"; ?></td>
      <td><?php echo $bus ?></td>
      <td><?php echo $school ?></td>
    </tr>
  </table>
</DIV>
<p>&nbsp; </p>
<p> 
  <?php

/*
# Enter data neatly - NOT WORKING
while($row = mysql_fetch_array($query)) 
	{
   echo "First Name: " . $row["firstname"] . "<br>";  

   echo "Last Name: " . $row["lastname"] . "<br>"; 
   echo "E-Mail: " . $row["email"] . "<br>"; 
   echo "Bus: " . $row["bus"] . "<br>"; 
   echo "School: " . $row["school"] . "<br>"; 
   echo "Agreed to <a href='privatepolicy.php'>Private Policy</a>: " . $row["privatepolicy"] . "<br>"; 
   echo "Signed Petition: " . $row["petition"] . "<br>"; 
	}

*/

# Close Database Connection
mysql_close($hosting)
?>
</p>
</body>
</html>

What did I do wrong? Also, I'm a newbie at this, so if you can make it look better with more features, etc. I will be really happy.

Thanks.

CrimsonSoul

I'm not far removed from a newbie myself. 😃

This may not resolve the problem you're getting but it looks as though your build of string is incorrect as you've used the same quotes within quotes:

$string = 'SELECT `firstname` , `lastname` , `email` , `bus` , `school` ' 
        . ' FROM `tblPetition` ' 
        . ' WHERE 1 AND `privatepolicy` = 'Yes' AND `petition` = 'Yes''
        . ' ORDER BY `firstname` ASC LIMIT 0, 30';

I would recommend that you change your string terminators to double quotes rather than single quotes.

$string = "SELECT `firstname` , `lastname` , `email` , `bus` , `school` " 
        . " FROM `tblPetition` " 
        . " WHERE 1 AND `privatepolicy` = 'Yes' AND `petition` = 'Yes'"
        . " ORDER BY `firstname` ASC LIMIT 0, 30";

thekidscareya

Still get the error:

Parse error: parse error, unexpected T_IF in /home/joel/public_html/petition/list.php on line 25

CrimsonSoul

My next suggestion is to put semi-colons on the end of your lines.

Silly I didn't see it before. :rolleyes:

thekidscareya

I fixed it. Thanks for your help.

Here's the new page:



<html>
<head>
<HEAD>

<title>List</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?php

# Require Database Info
include 'mysql.php';

# Define String
$string = "SELECT `firstname` , `lastname` , `email` , `bus` , `school` "  

        . " FROM `tblPetition` "  

        . " WHERE 1 AND `privatepolicy` = 'Yes' AND `petition` = 'Yes'" 
        . " ORDER BY `firstname` ASC LIMIT 0, 30";

# Define Query 
$result = mysql_query($string); 

$numrows = mysql_num_rows($result); 
while($row = mysql_fetch_array($result)){ 
    echo "Number of Signatures: <strong>$numrows</strong>";
	echo "<br><br>"; 

?>
<table border="2">
  <tr> 
    <td width="150"><strong>First Name</strong></td>
    <td width="150"><strong>Last Name</strong></td>
    <td width="250"><strong>E-Mail</strong></td>
    <td width="50"><strong>Bus </strong></td>
    <td width="100"><strong>School</strong></td>
  </tr>
  <tr> 
    <td height="21"> <?php echo "$row[firstname] "; ?> </td>
    <td><?php echo "$row[lastname] "; ?></td>
    <td><?php echo "<a href='mailto:$row[email]'>$row[email]</a> ";  ?></td>
    <td><?php echo "$row[bus] "; ?></td>
    <td><?php echo "$row[school] "; ?></td>
  </tr>
</table>
<?php
} 
# Close Database Connection
mysql_close($hosting)
?>
</p>

<p>&nbsp;</p></body>
</html>