theres a bug somewhere in this query and i can't seem to find it. does anyone else see it?

$query = "insert into templates (tuid,tname,tdescription,template,archivedefault) values (1,'Sample Archive Template','A sample archive template that only shows the name of the article with a link to the default article viewer.','<a href='viewarticle1.php?aid=[id]'>[articletitle]</a>',FALSE)";

the whole code is correct for PHP but datebase will have problem parsing your query becuase of the single quotes used in the 2nd to the last value.

and by the way should there be a dollar sign in id and article? like $id, $article?

This post has been edited by saga: Mar 10 2007, 12:37 AM

each element that is add to your table is separated by a aposthrophy, so you can't have them in your link unless you add an escape character (which in php is \ ) before the apostrophy in the link (as Saga said).



This code replaces [id] and [articletitle] with $id and $title:


This post has been edited by andybebad: Mar 11 2007, 06:46 PM