LIKE '%$SEARCHTEXT%' Ive got the seearch working - & a variable of $SEARCHTEXT - & using the above...
If I search for 678 and the actual number is in the fields - It does work & pick it up... HOWEVER If I search for LA 678 - If a field has LA678 it WONT be picked up... If I search for LA 678 - If a field has LA 678 it WILL be picked up... Is there a MYSQL command I can use in a SELECT query, that says to ignore spaces ? Ie - so both will be picked up ? (PS - Im not sure where (if any) the spaces occur....) - PS - Rest of script - Yesterdays problem - Fixed :) -- G Stewart Gmail invites - Hundreds available.. Gmail : [EMAIL PROTECTED] Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
