help needed !!! where query using variables and wildcards

[rcabrera]

i'm sure this must be easy but i'm newby in php so I better call for help, this is the case...

i'm trying to show all the rows of a table based on user variable previosly input by an user, for instance if a get a "smith" in the variable i'd must get all the rows that contains de word "smith" in the NAME field from the USERS table, by the way i'm workin with mysql. Here the script i'm using and from which I get nothing

$result = mysql_query("SELECT * FROM user WHERE name LIKE '% $TEXTO %'",$db);

any help will be appreciated.

[Frag]

Remove all spaces from the "like" string. Then try it.

'%$TEXTO%'

[rcabrera]

😕

honestly i've tried that before..... i'm sure i miss some step.....well anyway i'm happy it works now...... truly, thanks for your help and time....

[tomhath]

Try it this way, it has to work or something else is wrong:

$query = "SELECT * FROM user WHERE name LIKE '%" . $TEXTO . "%' ";

echo $query;

$result = mysql_query( $query, $db);

[jonki]

This is what I did in detail - it works;

This is in my inital html document

<select name="marca">
<option value="">Da igual</option>
<option value="VW">VW</option>
<option value="OPEL">OPEL</option>
<option value="etc ">etc</option>
</select>

This is in my php one; I have also put in some number comparisons incase they are of any help.

$result = mysql_query("select * from db WHERE marca
LIKE '%".$marca."%' AND
modelo LIKE '%".$modelo."%' AND
tipo = '$tipo' AND
tercio_tf LIKE '%".$tercio_tf."%' AND
combustible LIKE '%".$combustible."%' AND
techo LIKE '%".$techo."%' AND
caja_cambios LIKE '%".$cambios."%' AND
fecha_de_1 >= '$edadmax' AND
kms <= '$kmmax' AND
potencia >= '$cvmin' AND
litros >= '$litrosmin' AND
precio >= '$precio_min' AND
precio <= '$precio_max' order by 'precio' ")

	or die (mysql_error() );