[Resolved] unexpected $ at end of code

[demosthenes705]

I have the following code I am using to get song information out of a database

<?
include('inc/config.php) ?>

<b>Last Song played, Author, and When Played</b>

<?

$result = mysql_query(\"SELECT * FROM `historylist` \");

echo \"<table>\";
while ($row=mysql_fetch_assoc($result)) {

$date_played=$row[\'date_played\'];
$title=$row[\'title\'];
$artist=$row[\'artist\'];

echo \"

<tr><td>
$date_played - $name</td>
</tr>\";

}

echo \"<table>\";

?>

when I run the script I get the error

Parse error: parse error, unexpected $ in /home/your4rum/public_html/song/song.php on line 27

the problem for me is that line 27 is

?>

what should I do to fix that

[Roger_Ramjet]

The problem is the \ escape on the lines with echo - you need them.

<?
include('inc/config.php'); ?>

<b>Last Song played, Author, and When Played</b>

<?

$result = mysql_query("SELECT * FROM `historylist` ");

echo "<table>";
while ($row=mysql_fetch_assoc($result)) {

$date_played=$row['date_played'];
$title=$row['title'];
$artist=$row['artist'];

echo "<tr><td>
$date_played - $name</td>
</tr>";

}

echo "<table>";

?> 

[demosthenes705]

when I run the code you give me i get the error

Parse error: parse error, unexpected T_STRING in /home/your4rum/public_html/song/song.php on line 13

[Roger_Ramjet]

And all the other escaping \ and misplaced quotes needed editing out. Took me 3 edits to spot them all. Basically, you seem to have missunderstood when and where you need to escape. Try using single quotes, except for sql query strings, you will make fewer basic mistakes. Remember, with single quotes you cannot embed vars but have to concatenate them into the string. Stops you making the sort of hash that you did with that script.

Try the code again now I've edited it all.

[demosthenes705]

thanks that works now

also thanks for the fast responding