Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

search question

vandereyde 18 May, 2009

dear all

I implemented the search code as suggested by user 'benblee' on your forum. However, when I search for a part of a field (eg search for 'pierro' in the name field 'del pierro'), no results show up. Is there a solution for this?
Thanks and all the best

GreyHead 18 May, 2009

Hi vandereyde,

You don't say what code you are using but you probably want something likeecho "WHERE `field_name` LIKE '%{value}%'";

Bob

vandereyde 18 May, 2009

Code I use:

<?php
$search_array = array('client', 'serial', 'vehicle'); 
$where = array();
foreach ( $search_array as $search ) {
  $value = JRequest::getVar($search, '' , 'post');
  if ( $value ) {
    $where[] = " $search LIKE '$value%' ";
  }
}
if ( !empty($where) ) {
  echo " WHERE ".implode(' AND ', $where);
}?>

Changed $value% into %$value% and it works now

THANKS very much

This topic is locked and no more replies can be posted.