Parse error query

[sprint10s]

here is the error i get and below is the query on that line please help, am i missing a quote or something?

 

Parse error: syntax error, unexpected ';' in /home/weiland2/public_html/standridgemotorsports.com/jeremy_schedule1.php on line 79

 

 $result = mysql_query("SELECT *,DATE_FORMAT(h0237,\'%M %e %Y\') as dt FROM jos_jforms_72563 WHERE uid = 63 ORDER BY h0237 ASC";

[aeroswat]

here is the error i get and below is the query on that line please help, am i missing a quote or something?

 

Parse error: syntax error, unexpected ';' in /home/weiland2/public_html/standridgemotorsports.com/jeremy_schedule1.php on line 79

 

 $result = mysql_query("SELECT *,DATE_FORMAT(h0237,\'%M %e %Y\') as dt FROM jos_jforms_72563 WHERE uid = 63 ORDER BY h0237 ASC";

 

you are missing a ) at the end of the query

[sprint10s]

that fixed that then i get this error

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/weiland2/public_html/standridgemotorsports.com/jeremy_schedule1.php on line 90

 

line 90 is in marked

 

//$result = mysql_query("SELECT *, DATE_FORMAT(h0237,"%M %e %Y") FROM jos_jforms_72563 WHERE uid = 63 ORDER BY h0237 ASC ");

$result = mysql_query("SELECT *,DATE_FORMAT(h0237,\'%M %e %Y\') as dt FROM jos_jforms_72563 WHERE uid = 63 ORDER BY h0237 ASC");

 

echo "<table align='center' border='1'>

<tr>

<th>Date</th>

<th>Track</th>

<th>Description</th>

<th>Special Show</th>

<th>Race Type</th>

</tr>";

 

while($row = mysql_fetch_array($result)) //line 90

  {

  echo "<tr>";

  echo "<td>" . $row['h0237'] . "</td>";//Date

  echo "<td>" . $row['h9ca9'] . "</td>";//Track

  echo "<td>" . $row['hf6a6'] . "</td>";//Description

  echo "<td>" . $row['h67d6'] . "</td>";//Special Show

  echo "<td>" . $row['heb76'] . "</td>";//Race Type

  echo "</tr>";

  }

echo "</table>";

 

[aeroswat]

Firstly the backslashes are not necessary in your SQL query. They are single quotes surrounded by double quotes so they are fine.