dynamic query, search form

[sickdude]

Im buidling a search form with alot of search options

i want to make a dynamic query for postgresql to assign priorities to the search submit. this what i came up with but this isnt right

maybe you guys have any adeas 😃

$result = pg_query("SELECT * FROM vanoord WHERE location='$location', time_from='$start', time_to='$stop', under_construction='$construct', info='$info'");
if (!$result) {
  echo "An error occured.\n";
  exit;
}

[Norman_Graham]

Hi Sickdude

What exactly doesn't work? What happens when you run the query? You might like to specify this.

I know nothing about Postgresql, however I do know that the SQL syntax acceptable to MySQL DBs requires that multiple conditions in the WHERE clause be separated by the word AND and not by a comma.

HTH

Norman

[Weedpacket]

So does PostgreSQL.