Type: Posts; User:
I have tried to alter the query to call in the $page_id of each page but cannot seem to get the sql statement right. So far I have
$sql = "SELECT `description`, `keywords`,...
I have still not managed to get the query right to display the meta info and title for the page requested. I have stripped the code back to its very basic to ensure I was getting an output. As you...
You should take a look at a couple of tutorials, maybe video tutorials, just search youtube for ' join tables in mysql '. Hope this helps
Well obviously from when I removed the * from the select statement and did not call the title it obviously would not show, so now I have the following
$sql = "SELECT
Ok, I have made a few changes, whether they are for the better or not I will take advice. Currently in my fetchmeta.php file I have
$sql = "SELECT*
`description`, `keywords`, `author`,...
With the code NogDog has given me and my small amendments to my SELECT statement I now have the following code, the echo statement is not what I need to work on as the meta info is out of sync now so...
The first problem is that there is not a field called content in the DB. I see that 1, I have had several suggestions and think I have mixed them up at some point so re-entered the code you gave me....
Amended desc to description, now get
 => 42S22
 => 1054
 => Unknown column 'content' in 'field list'
The output gives me
 => 42S22
 => 1054
 => Unknown column 'desc' in 'field list'
I still have not managed to get anywhere with this, I would be grateful if someone could give me a little more direction to resolve this. Thanks
I forgot to ask is implode(); the way to go?
I am working my way through but initial tests give me
Notice: Array to string conversion in C:\xampp\htdocs\dynamicmeta\dynamic3\inc\fetchmeta.php on line 22
I will reply when I have...
I tried your solution, thanks for the reply.
Unfortunately I get
Fatal error: Call to a member function fetch() on a non-object in C:\xampp\htdocs\dynamicmeta\dynamic3\inc\fetchmeta.php on line...
Unfortunately that returns
Notice: Array to string conversion in C:\xampp\htdocs\dynamicmeta\dynamic3\inc\fetchmeta.php on line 28
echo "<meta name=\"$desc\" content=\"$content\"...
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="name" content="home" />
<meta name="title" content="Home Page" />
I have gone through the numerous threads regarding this subject but cannot translate any of the solutions over to my basic project. I have followed a tutorial on a basic dynamic site, the index page...