newbwoi

Hi, I'm new to Mysql database and I'm in the process of creating a CMS using PHP and mysql. I came across this challenge when I decided to display the related contents of this video like for example youtube when you click on a particular video you get related videos on the site similar to that I want to display related video using similar tags. Or another popular example would be a blog article and it displays similar related article on the page. In my table it has the following fields Id, title, description, tags...... and all other information about each video including specific tags. The tags are determined by the title of the video EX: the title of the video is "Today is a holiday in Canada 05/04/2010" and then I used the php code strtolower to lower case the title and then I used explode(" ",$tags); to separate the title into each word and using a loop I inserted those separated words into the tag field of the table. So now the tags field contains "today is a holiday in canada 05/04/2010 ". Now that you know about my database and the table On the video display page, I want to show the related videos on the side. I tired the following but it does not adequate my goal. Please write up a mysql query to suit my needs and please give your feedback to improve the table/website or any other suggestion that may help me. Thank you

Thank you so much! I really appreciate it

Hi, I'm new to PHP and I took on the challenge to build a simple blog using PHP that is similar to wordpress. My question is how can I display the title of the entry in the URL of that specific entry page like for example www.example.com/hello-world or real life example would be this random site that i pulled from wordpress http://lesbonurse.wordpress.com/ and when you click on each blog entry title it redirects to its own page with the title in the URL like so http://lesbonurse.wordpress.com/2010/03/21/i-think-the-word-youre-looking-for-is-possible/ and the title of entry that i clicked on the main page is " I think the word youre looking for is possible" I hope you understand what i m trying to acheive, its really complicated to explain when I m new to PHP. My blog script consists of PHP with mysqel and i can get the blog running perfectly except when i click on the entires of my blog the URL is similar to /view.php?$id=246 My goal is to change "..../view.php?$id=246" into the title of the entry for example "..../hello-world" Is it possible to hide "view.php?$id=246" and change it to title of entry? Can you please help me to solve this problem?