Hello,
Thank you for taking the time to read my message.
I'm a newbie and have a question regarding my script.
I keep getting this message:
Parse error: syntax error, unexpected T_VARIABLE in /home/mckinley/public_html/includes/getconcert.php on line 42
I assume there are many more messages like this waiting for me, but I can't seem to get past this one.
here is the full script I wrote:
<?php
//This script will retrieve the next Up Coming Concert.
$page_title = "Mckinley's Next Upcoming Concert";
//Connect to the db.
require_once('mysql_connect.php');
//Select the Database
mysql_select_db( 'mckinley_mckinley' );
//Make the Query
$sql = 'EXPLAIN SELECT cms_concerts.concert_date, concert_time, concert_addres, concert_city
FROM cms_concerts';
$result = @($sql, $connection);//run the query
if ($result) //If it ran OK, display the records.
//Table Header
echo'<table align="center" cellspacing="0" cellpadding="5">
<tr>
<td align="left"><b>DATE</b></td>
<td align="left"><b>TIME</b></td>
<td align="left"><b>NOTES</b></td>
<td align="left"><b>VENUE</b></td>
<td align="left"><b>ADDRESS</b></td>
<td align="left"><b>CITY</b></td>
<td align="left"><b>COUNTRY</b></td>
</tr>
';
//Fetch and print all the records.
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
printf("Date: %s Time: %s Notes: %s Venue: %s Address: %s City: %s Country: %s", $row["concert_date"], $row["concert_time"] $row["concert_notes"], $row["concert_venue"], $row["concert_addres"], $row["concert_city"], $row["concert_country"],);
}
{
echo'<tr>
<td align="left">'. $row ['concert_date']. '</td>
<td align="left">'. $row ['concert_time']. '</td>
<td align="left">'. $row ['concert_notes']. '</td>
<td align="left">'. $row ['concert_venue']. '</td>
<td align="left">'. $row ['concert_addres']. '</td>
<td align="left">'. $row ['concert_city']. '</td>
<td align="left">'. $row ['concert_country']. '</td></tr>
';
}
echo'</table>';
mysql_close();//Close the database connection.
?>
