RE: FN-FORUM: MySQL Query

date posted 11th August 2005 14:06

Should the price parameters $from and $to be in quotes? ... What type of
field are they in your database?

Dave.

___________________________________________________________
Dave Boulden, Director. DA Media Limited
web: http://www.da-media.co.uk/ Skype: callto://daveboulden
Tel: 01795 559456 Fax: 07092 011488



> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On
> Behalf Of Paul Summers
> Sent: 11 August 2005 13:42
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: MySQL Query
>
>
> 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.
>
> --
> Freelancers, contractors earn more with Prosperity4 Call 0870
> 870 4414 or visit www.prosperity4.com and benefit from Inland
> Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>