Using SELECT function

[futhonguy]

I would like to make some query using the SELECT function. However i wasnt able to get the results i want.
My code is as follow:

$sql = "SELECT *
FROM device 
WHERE ((device_num like '%$val_d%') OR (dib like '%$val_dp%')) ";

can i write it in this way? pls advise thanks people..:)

[cwarn23]

Try replacing it with the following:

$sql = 'SELECT * FROM device WHERE `device_num` LIKE "'.mysql_real_escape_string($val_d).'" OR `dib` LIKE "'.mysql_real_escape_string($val_dp).'"';

[futhonguy]

Hi..
where should i place the wildcard?

[cwarn23]

If you want wildcards then the following contains the wildcards:

$sql = 'SELECT * FROM device WHERE `device_num` LIKE "%'.mysql_real_escape_string($val_d).'%" OR `dib` LIKE "%'.mysql_real_escape_string($val_dp).'%"';

[network18]

I would like to make some query using the SELECT function. However i wasnt able to get the results i want.
My code is as follow:

$sql = "SELECT *
FROM device 
WHERE ((device_num like '%$val_d%') OR (dib like '%$val_dp%')) ";

can i write it in this way? pls advise thanks people..:)

in first place check whether $val_d and $val_dp variables are set when this query is formed, otherwise your query may get executed like -

$sql = "SELECT * FROM device WHERE ((device_num like '') OR (dib like '')) ";