Searching problem.

[GB_001]

<?php
mysql_connect("mysql.x10hosting.com", "gb_GB", "*****************") or die(mysql_error());
mysql_select_db("gb_USERInfo") or die(mysql_error());

session_start();

$var = $_POST['email'] ;
$trim = trim($var);
$earray = explode(" ",$trim);

$result = mysql_query("SELECT * FROM Ysers WHERE firstname LIKE '%{$earray[0]}%'")
or die(mysql_error());

while($row = mysql_fetch_array( $result )or die(mysql_error())) {
echo $row['firstname'];
echo"<br/>";
}

 

My search script seems to bring up all names in the database, instead of what is searched for.

Thankyou for your help.

[revraz]

echo $earray[0] and see what it contains.

 

Since it looks like you are exploding $var on a space which shouldn't exist since there should be no spaces on a email, I'm not sure what you are trying to achieve really.  Did you mean do do this on a first name last name?

[GB_001]

No, I just switch to first name and last name to test it out

[GB_001]

I'm still having the same problem.

 

I tried taking out explosion and using $trim.

 

But it still showed every email in the database.

 

So then I tried to echo trim, and it showed as blank.

[revraz]

Post your form.

[janim]

yes you should post your form

couse you use $_post['email']

while you searching in username