At 23:11 13.03.2003, Charles Kline said:
[snip]
>On Thursday, March 13, 2003, at 05:08 PM, Ernest E Vogelsinger wrote:
>
>> - if your query is exactly as you sent it here you're missing a comma
>> after
>> the closing bracket of "concat()", just before "name
On Thursday, March 13, 2003, at 05:08 PM, Ernest E Vogelsinger wrote:
- if your query is exactly as you sent it here you're missing a comma
after
the closing bracket of "concat()", just before "name"
name is supposed to be an alias for the concatenated values of
fname,lname,mname.
Let me try to
At 22:31 13.03.2003, Charles Kline said:
[snip]
>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
>
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 .= "%\' ORDE
4 matches
Mail list logo
