Re: [PHP] Why won't this query work?

2008-03-25 Thread Zoltán Németh
2008. 03. 24, hétfő keltezéssel 14.40-kor Daniel Brown ezt írta: On Mon, Mar 24, 2008 at 2:29 PM, Jason Pruim [EMAIL PROTECTED] wrote: It's already been escaped, $business is pulled out of the database after they log in. :) I don't care, Prune. (I still get a kick out of

[PHP] Why won't this query work?

2008-03-24 Thread Jason Pruim
Hi Everyone, Attempting to get this query: SELECT customerName, loginName, email, adminLevel FROM current WHERE customerBusiness=$business ORDER BY adminLevel to work. So far it doesn't like me... It pops up saying that Unknown column 'Raoset' in 'where clause' Here is what I get if I

Re: [PHP] Why won't this query work?

2008-03-24 Thread Jason Pruim
Okay... so as happens to me more times then I care to admit... as soon as I sent it I simply added: .WHERE customerBusiness='$business'. and it works just fine... Sorry for the noise! On Mar 24, 2008, at 1:47 PM, Jason Pruim wrote: Hi Everyone, Attempting to get this query:

Re: [PHP] Why won't this query work?

2008-03-24 Thread Daniel Brown
On Mon, Mar 24, 2008 at 1:47 PM, Jason Pruim [EMAIL PROTECTED] wrote: Hi Everyone, Attempting to get this query: SELECT customerName, loginName, email, adminLevel FROM current WHERE customerBusiness=$business ORDER BY adminLevel to work. So far it doesn't like me... It pops up saying

Re: [PHP] Why won't this query work?

2008-03-24 Thread Jason Pruim
On Mar 24, 2008, at 2:23 PM, Daniel Brown wrote: On Mon, Mar 24, 2008 at 1:47 PM, Jason Pruim [EMAIL PROTECTED] wrote: Hi Everyone, Attempting to get this query: SELECT customerName, loginName, email, adminLevel FROM current WHERE customerBusiness=$business ORDER BY adminLevel to work. So

Re: [PHP] Why won't this query work?

2008-03-24 Thread Daniel Brown
On Mon, Mar 24, 2008 at 2:29 PM, Jason Pruim [EMAIL PROTECTED] wrote: It's already been escaped, $business is pulled out of the database after they log in. :) I don't care, Prune. (I still get a kick out of knowing that. Who was it, Jochem or Zoltan who said that? ;-P) NEVER

Re: [PHP] Why won't this query work?

2008-03-24 Thread Eric Butera
On Mon, Mar 24, 2008 at 2:40 PM, Daniel Brown [EMAIL PROTECTED] wrote: On Mon, Mar 24, 2008 at 2:29 PM, Jason Pruim [EMAIL PROTECTED] wrote: It's already been escaped, $business is pulled out of the database after they log in. :) I don't care, Prune. (I still get a kick out