I know what you are trying to do. I am thouroghly confused by how you are trying to do it. Your code does not make sense to me.
Quote:
$metasettings = @mysql_fetch_assoc(@mysql_query("SELECT * FROM $table WHERE RecipeName, RecipeDescription, Author"));
$title = $metasettings['RecipeName'];
$description = $metasettings['RecipeDescription'];
$random_tags = $metasettings['Author'];
|
This looks all sorts of wrong to me.
Your query makes no sense.
SELECT * FROM $table WHERE RecipeName, RecipeDescription, Author
You say:
Quote:
What I'm trying to do in the SQL data is to add the 'RecipeName', 'RecipeDescription' and 'Author' rows as meta tags.
|
You select columns (field names) from a table then you read through the rows returned. Rows do not have names, unless this is some new fangled sql that I have never seen before.
What fields are in your table? The Recipes table we were working with before had the fields 'recipeid', 'title', 'method' and 'ingredients' in it.
It now has RecipeName, RecipeDescription and Author also?
If so then you need to pull those fields like you pulled the other fields from the table. You did that by calling for a result by id.
In this case you have not grabbed your input variable so you don't know what id the recipe you are pulling has.
What does the entire .php file look like right now?
.