Re: FN-FORUM: MySQL Query

date posted 11th August 2005 13:26

Try:

$Query = "SELECT * FROM `property` WHERE `location`='$location' AND
`type`='$type' AND `price` >= '$from' AND `price` Can anyone confirm this is a valid query?
>
> $Query = "SELECT * FROM property WHERE location='$location' AND
> type='$type' AND (price >= '$from') AND (price
> When I use this directly on the database using SSH no problem but
> doesn't pull anything out when using PHP?
>
> Thanks
> Paul
>
>
>
>
> Paul Summers
> Systems Developer
>
>
> Digital Arts IT Consultancy
>
>
> Telephone. 0870 01 02 226
> Fax. 0870 01 02 227
> Email. [EMAIL REMOVED]
>
>
> http://www.daitc.com
>
>
> Please Note:
> This message contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender.
>
>
> This message has been scanned by Symantec Enterprise AV Version 9.0 prior to dispatch.
>
>
> The views of the author may not necessarily reflect those of the Company. Any opinions or other information in this message that do not relate to the official business of the Company are neither given nor endorsed by it.
>