$HTTP_POST_VARS[ ] problem 1

[Roberti]

I have a form where you enter the titel of a movie which I post to another page wich has this sql query:

$SQL = "SELECT artikel_id, titel, acteur, beschrijving, prijs FROM tbl_dvd WHERE titel = $HTTP_POST_VARS[zoeken]";

But It works only if you fill in a number in the form, when you enter text it gives the following error:

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in.

Does anybody know how to fix this?

 

[SPYDERIX]

Hi,

Try this:

$titel = $HTTP_POST_VARS["zoeken"];

$SQL = "SELECT artikel_id, titel, acteur, beschrijving, prijs FROM tbl_dvd WHERE titel = '$titel'";

Hope this helps!

Nate

http://www.mainframe-webdesign.com

 

[Roberti]

Thanx SPYDERIX it works.