[searching a mysql database]

SELECT * FROM DVD WHERE title IS LIKE \'*$title*\'

 

or something similar.. it something with wildcards..

[not updating an update]

very choqing.. \"No Database Selected\" :oops:

thanks for helping.. very handy the mysql_error..

[not updating an update]

I got following code at my fanlisting-script..

$query = \\\"UPDATE fanlisting SET censor = \'n\' WHERE id = \'$uncensor\'\\\"; mysql_query ( $query ); echo $query . \'<br>\';

 

this should modify a record in the datebase + output the SQL-code to the screen with the echo. The output to the screen is

UPDATE fanlisting SET censor = \'n\' WHERE id = \'50\'

 

but in the DB isn\'t happening anything.. while when I copy the output that appears on the screen (second quote) and I paste it in my phpMyAdmin then it does update the record.

 

What might cause this ?

thanks