[Resolved] Echo problem

Jon12345

What is wrong with the syntax with this?

echo "<a href='http://www.mysite.com'>test</a>";

bpat1434

There's nothing wrong with that syntax. Everything should be fine.

Now, is that the code giving you the problem, or a piece inside of a huge concatenated string?

And, what error are you getting? Or, what output are you getting?

~Brett

Jon12345

I get the following error...

Parse error: parse error, unexpected T_ECHO in /home/alwaysac/public_html/pealist.php on line 37

Is it in this code:

while ($row = mysql_fetch_assoc($result)) {
echo "<a href='http://www.mysite.com'>test</a>";
$row['TopicName']
echo $row['MetaTitle'];
echo "<br>";

}

Jon12345

If it makes any difference, I haven't got any html tags set up. Full code follows:

<?
$dbh=mysql_connect ("localhost", "alwaysac", "xxx") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("alwaysac_MyArticles"); 

// Perform Query
$result = mysql_query("SELECT * FROM Articles WHERE upper(left(TopicName,1))='".$filter."' ORDER BY TopicName");

// Check result
// This shows the actual query sent to MySQL, and the error. Useful for debugging.
if (!$result) {
   $message  = 'Invalid query: ' . mysql_error() . "\n";
   $message .= 'Whole query: ' . $query;
   die($message);
}

// Use result
// Attempting to print $result won't allow access to information in the resource
// One of the mysql result functions must be used
// See also mysql_result(), mysql_fetch_array(), mysql_fetch_row(), etc.
while ($row = mysql_fetch_assoc($result)) {
   echo "<a href='http://www.mysite.com'>test</a>";
   $row['TopicName']
   echo $row['MetaTitle'];
   echo "<br>";

}

// Free the resources associated with the result set
// This is done automatically at the end of the script
mysql_free_result($result);
?>

bpat1434

Originally posted by Jon12345

while ($row = mysql_fetch_assoc($result)) {
   echo "<a href='http://www.mysite.com'>test</a>";
   $row['TopicName']
   echo $row['MetaTitle'];
   echo "<br>";

}

Woopsie!!

You ended your echo query early, and never terminated the line: $row['TopicName']. I think your code probably should look like:

while ($row = mysql_fetch_assoc($result)) {
   echo "<a href='http://www.mysite.com'>test</a>".$row['TopicName'];
   echo $row['MetaTitle'];
   echo "<br>";
}

But that is just a guess. Your error is that you didn't put the termination character after $row['TitleName'] so the next command echo $row['MetaTitle'] causes an error because the previous line isn't terminated. Make sense?

~Brett

Jon12345

I meant to comment that line out but forgot. Would have thought it wouldn't impact it as it would not have reached that line yet. But I deleted the line and it works fine now.

Thank you!

bpat1434

Don't forget to mark this as resolved if it's doing what is expected.

Glad to hear it works now.

~Brett