[RESOLVED] Need help with some linking

Seitan

I need help with linking my records.
This is what I have so far

while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {
      echo '<a href = "recipes.php?id=' . $row['Recipe_Number']'">' . $row['Recipe Name']'</a>';?><br><br>

<?
    }

I just keep getting an error here....I ve looked it over a million times and I cant find what is wrong.

bpat1434

What's the error?

Nevermind. IT's a concatenation error:

]'</a>'

Should be:

].'</a>'

Seitan

hmmmm.....well I tried that, and I keep getting this error message

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /homepages/29/d178597021/htdocs/php/breakfast.php on line 17

and line 17 is the 'echo' part of the code that I posted before, I don't see anything wrong tho

bpat1434

It happens more than once. Go through very carefully.

Seitan

Here is my whole page, I swear I can't find any missing ';' .

<?php # view_users.php
// This script retrieves all the records from the users table.

$page_title = 'Breakfast';
$header = 'Breakfast';
include ('../php/header.php');

require_once ('../shhhhhhhh/mysql_connect.php');
$query = "SELECT `Recipe Name` AND 'Recipe_Number' FROM `Recipes` WHERE `Category` LIKE 'Breakfast' ORDER BY `Recipe Name` ASC";
$result = @mysql_query ($query);  

if ($result) { // If it ran OK, display the records.


// Fetch and print all the records.
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {
    echo '<a href = "recipes.php?id=' . $row['Recipe_Number']'">' . $row['Recipe Name'] . '</a>'\n;

}

} else { // If it did not run OK
echo '<p class="error">There is no recipes?!?</p>'; //Public message.
} 
mysql_close(); // Close the database connection.  


include ('../php/footer.php'); // Include the HTML footer.
?>