Re: question about passing field name in sql statement as variable.
- From: "nephish" <nephish@xxxxxxxxx>
- Date: 30 Aug 2006 15:20:56 -0700
Andy Hassall wrote:
On 30 Aug 2006 14:14:27 -0700, "nephish" <nephish@xxxxxxxxx> wrote:
can anyone tell me if this is legal php/mysql ?
Did you try running it?
i am trying to write a simple function to get a single stat from a
single table.
$field = 'phone_number';
$customer = 'fred';
$query = mysql_query("SELECT `'{$field}'` FROM `customers` WHERE `name`
= '{$fred}' ");
// note the back quotes around $field
The single quotes inside the back quotes will break it.
or is this an accident waiting to happen ?
Probably, yes; depends where the data from the $field and $customer variables
comes from.
--
Andy Hassall :: andy@xxxxxxxxxxx :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
thanks for the quick reply,
Did you try running it?yep, didn't work. i think the quotes did broke it it too. I got this:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL
result resource in
yadda yadda.
Tried it without the quotes and got a blank page.
i dont get that because i know the values are there.
so, will go ahead and make the individual queries.
thanks for your time.
sk
.
- Follow-Ups:
- Re: question about passing field name in sql statement as variable.
- From: Jerry Stuckle
- Re: question about passing field name in sql statement as variable.
- References:
- question about passing field name in sql statement as variable.
- From: nephish
- Re: question about passing field name in sql statement as variable.
- From: Andy Hassall
- question about passing field name in sql statement as variable.
- Prev by Date: Re: Serving a website based on source internet address ?
- Next by Date: Re: question about passing field name in sql statement as variable.
- Previous by thread: Re: question about passing field name in sql statement as variable.
- Next by thread: Re: question about passing field name in sql statement as variable.
- Index(es):
Relevant Pages
|
