将变量匹配到两列连接（PHP）

Question

A previous variable from a query gave me a value $name. I need to find the user id associated with that name, however in my users table I have two fields, firstName and lastName.

I cannot explode $name as I have both cases of double names (e.g. John Eric Smith) and last names (e.g. Jan van der Worde), so my attempt was to find a way to match firstName + lastName with $name.

My attempt was this:

$drid = "SELECT id FROM users WHERE CONCAT(firstName,' ',lastName)='$name'";
$rest = mysql_query($drid);
while ($row = mysql_fetch_row($rest)) {
    $driver_id = $row[0];
} 

Unfortunately, nothing comes out as a result for $driver_id (whereas $name returns a result).

Thank you for your help!

Answer 1

Are you looking for something like this:

<?php
$drid = "SELECT id FROM users WHERE CONCAT(firstName, ' ', lastName) LIKE '%".$name."%'";
$rest = mysql_query($drid);
while ($row = mysql_fetch_row($rest)) {
    $driver_id = $row[0];
}
?>