Craigypoos

Many thanks.  Your solution works like a dream! Craigypoos

Help!  I'm pretty much a noob as far as php goes and I'd like to make a website for my band.  What I want to do is have a navigation panel with links (gigs, discography etc) on the index.php page that uses url variables (index.php?content=gigs for example) so that when visitors click on the link it opens up the content. The neo-php I have so far (which obviosly I can't get to work) is something like this:   <div id="menu">     <a_href="http://page2.php?content=news"><img src="images/news1.gif"></_a>     <a_href="http://page2.php?content=discography"><img src="images/discography2.gif"></_a>     <a_href="http://page2.php?content=biography"><img src="images/biography1.gif"></_a>   </div>   <div id="content">   <?php include $content.inc?>   </div> (Obviously I put the underscores in so that my code is displayed here!) Like I said, I'm very much a noob, and there are probably loads wrong with my code, so if anyone can give me a laymans description (like really spell it out please!) of how to use these things I would be most grateful. Cheers, Craigypoos

Thanks for your reply. However, I seem to have a MATCH AGAINST clause thing going on now, and it works lovely... except, some of the words used to search for will be the names of bikes (such as CBR or GSXR) so the 4 letter lower limit kicks in.  It's late now, but I reckon tomorrow I'll try it the LIKE way or write a php IF thingy to choose whether to do the query IN BOOLEAN MODE or not.... Thanks anyway for your (very prompt) help. Craigypoos

[quote author=fenway link=topic=106620.msg426569#msg426569 date=1157212260] Try using LIKE with % wildcards. [/quote] How, exactly? I've been having the same problem.  I have a database full of motorbike parts and I want to be able to search the entire database for a search string such as "clutch" to retrieve all the clutch related parts from my database (ie clutch levers, clutch cables, etc etc)... I've tried various different variations using LIKE and % and just can't seem to get it to work.  I've even tried using MATCH....AGAINST, but to no avail.  Could you give an example of the code syntax? Cheers, Craigypoos