Selecting firstName, LastName or Both (newbe)

[webber82]

Hi, My question is very easy but i not understand,

i have table with firstname, middlename and lastname, some time the firstname contain the whole name and the middle name and last name empty, some time last is empty and the other two contain name and in some time the middlename is empty and only the firstname and lastname contain the name in the table.

 

Now my question is if i pass a variable "$name" which contain the total name then how i search through table for the required name under the describe situation.

 

 

thanks

[fenway]

Sounds like you need to clean up your database.

[webber82]

I not understand why to clean up the database these entry are not fill by mistake but its often that someone have first name only and some have middle and/or last name also.

[MisterWebz]

I don't understand what you're trying to say.

 

Do you mean something like this?

<?php
$result = mysql_query("SELECT * FROM members WHERE name='$name'); 
?>

 

[fenway]

Sorry, I thought you had names spanning fields, not the reverse.

 

You can't pass the "total name" and make it work.  You'll have to search each field.

[webber82]

My query is like this

 

<?php

$result = mysql_query("SELECT * FROM members WHERE fname='$name' OR mname='$name' OR lname ='$name');

?>

 

but it not return the result in some casese $name contain the whole name and and the three fields fname, mname and lname contain the parts but in some cased the mname and/or lname are empty due to which its give the error.

 

Thanks for the time.

 

 

[fenway]

You'll need use LIKE and %.