Current location: Hot Scripts Forums » Programming Languages » PHP » [SOLVED] PHP Search


PHP Search

Closed Thread
  #1 (permalink)  
Old 03-01-10, 04:31 AM
xEX3CUT1ONx xEX3CUT1ONx is offline
Wannabe Coder
 
Join Date: Jun 2008
Posts: 122
Thanks: 2
Thanked 0 Times in 0 Posts
PHP Search

I have a query to search my database that looks like this

PHP Code:

$Retrieve=mysql_query("SELECT id,user,title,DATE_FORMAT(date,'%M %Y') FROM blogs WHERE tags LIKE '%$search%' AND privacy='1' AND status='1' ORDER BY id DESC"); 

this is for a blog system, so when a user creates a blog they have the option to add tags (seperated by a comma) the problem I believe lies with that comma as it will bring up the first result in this case it's rap but anything after the first word/comma is a no go.

any suggestions ?
Closed Thread

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP Search Feature Problem jilawatan PHP 2 08-13-09 08:21 AM
mysql search page in php gavenp PHP 1 06-10-07 09:19 PM
How to create a php mysql site searchable from search engines? Klesti PHP 2 05-16-04 04:09 PM
Simple search script niceguyonline Script Requests 3 03-07-04 11:09 PM
PHP search engine flipsix PHP 3 10-19-03 02:07 PM


All times are GMT -5. The time now is 08:11 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.