[singabaloo]

Thanks and no need to apologise. I'm very thankful for the help.

Here's what I have now

PHP Code:

$query="SELECT thread.title, firstpostid, recipe_time, recipe_description, recipe_prep,
recipe_difficult, recipe_ingrediants, recipe_size, recipe_steps, pagetext FROM thread
LEFT JOIN post ON (thread.firstpostid = post.postid)
WHERE recipe_ingrediants IS NOT NULL AND recipe_ingrediants<>''";
$result = mysql_query($query);
/*
 * Count and echo the number of rows just to make
 * sure the amount of data returned looks about right.
 */
$num_rows = mysql_num_rows($result);
echo "$num_rows Rows\n </br>";

while($row = mysql_fetch_array($result))
{
    $postid = $row['firstpostid'];
    $recipe = "[center][size=5][color=black]{$row['title']}[/color][/size][/center][size=5][color=black][/color][/size][color=black][/color]\r\n
        [b]Recipe Description[/b][indent]{$row['recipe_description']}[/indent]        [b]Preparation Steps:[/b][indent]{$row['recipe_prep']}[/indent]        [b]Level of Difficulty:[/b][indent]{$row['recipe_difficult']}[/indent]        [b]Time Needed:[/b][indent]{$row['recipe_time']}[/indent]        [b]Ingredients:[/b][indent]{$row['recipe_ingrediants']}[/indent]        [b]Serves:[/b][indent]{$row['recipe_size']}[/indent]";

    echo "<br /><b>Post ID:</b>" . $postid . "<br />". $recipe;
} 


The echo is there so I can see what it looks like. I had this laid out already using HTML tags but didn't even think to use BBCode instead. Formatting is I have is sufficient...

Except

Under Ingredients the contents of the field come out on a single line separated by a space. They should be a list. Is there anyway easy way to do that ?

I've attached a screenshot of phpmyadmin showing the format of the ingredients (and directions) filed that has the items separated by a cr (i think)

Once I can sort out this little bit of the formatting then I think I am good to try updated the posts table.

Again, thanks for your help.