Re: FN-FORUM: MySQL Query

date posted 11th August 2005 14:02

On 11 Aug 2005 12:42:32 -0000, Paul Summers [EMAIL REMOVED] wrote:
>=20
> Can anyone confirm this is a valid query?
>=20
> $Query =3D "SELECT * FROM property WHERE location=3D'$location' AND
> type=3D'$type' AND (price >=3D '$from') AND (price =20
> When I use this directly on the database using SSH no problem but
> doesn't pull anything out when using PHP?

MySQL I guess?

Hard to say whether it's a valid query without knowing the contents of
$location, $type, $from and $to.

What does mysql_error() say the problem was?

Have you tried printing $Query to make sure that it looks the same as
the one you tried from the command line?

Were you using the same mysql user as php on the command line?

-robin