sql search

[garyneedham]

Hi Everyone

 

I have the following search which works fine But I only want to bring back an exact match in the Nif field for example if I want to search for 123456 I only want to bring this one back and not 12345, 1234, 12 etc etc can anyone help

 

$sql = "SELECT * FROM Customer WHERE Nif Like '%" . mysql_escape_string($_GET['Nif']) . "%' ORDER BY Nif ";

if (empty($_GET['Nif']))

$sql = "SELECT * FROM Nif WHERE 1 = 2 ";

$res = mysql_query($sql);

 

?>

 

Please keep all replies very simple as I am very new to this

[Maq]

Then compare with '=' not LIKE.

$Nif = mysql_escape_string($_GET['Nif']);
WHERE Nif = '$Nif'

[garyneedham]

Then compare with '=' not LIKE.

$Nif = mysql_escape_string($_GET['Nif']);
WHERE Nif = '$Nif'

 

 

Hi I am still having problems with this can you please lay it out step by step for me Sorry I am a real beginner at this.

[Pikachu2000]

Describe your current problem, and post the relevant current code, please.

[garyneedham]

I have the following search which works fine But I only want to bring back an exact match in the Nif field for example if I want to search for 123456 I only want to bring this one back and not 12345, 1234, 12 etc etc can anyone help

 

$sql = "SELECT * FROM Customer WHERE Nif Like '%" . mysql_escape_string($_GET['Nif']) . "%' ORDER BY Nif ";
if (empty($_GET['Nif']))
   $sql = "SELECT * FROM Nif WHERE 1 = 2 ";
$res = mysql_query($sql);

?>

 

Please keep all replies very simple as I am very new to this

 

 

[Pikachu2000]

Replace LIKE with an = sign and remove the % sign.

[garyneedham]

Thanks very much worked perfect