Problem with string comparison
| From: | Charles Kline | Date: | Thu, 13 Mar 2003 21:31:53 +0000 |
| Subject: | Problem with string comparison | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-139606@lists.php.net to get a copy of this message | ||
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