I am trying to get this sql query to work and am getting the error "Insufficient data supplied". Can anyone help with this?

$sql =  "SELECT id, concat(fname, ' ', lname, ' ', degree1) name
              FROM tbl_personnel "WHERE name LIKE \'%";
$sql .= $attributes['nametofind'];
$sql .= "%\' ORDER BY lname ASC";

What I am trying to do is allow the user to find a personnel record that contains the name to find.

Thanks,
Charles



-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to