Search found 10 matches

by d3chapma
Mon Nov 27, 2006 1:42 pm
Forum: Databases
Topic: Error with SELECT.....WHERE... Statement
Replies: 16
Views: 1745

wow. 8O

Well, that fixed all my problems :D Thanks so much for the help. I never would have noticed that.
by d3chapma
Mon Nov 27, 2006 12:53 pm
Forum: Databases
Topic: Error with SELECT.....WHERE... Statement
Replies: 16
Views: 1745

feyd | Please use , and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color] [color=gr...
by d3chapma
Mon Nov 27, 2006 12:31 pm
Forum: Databases
Topic: Error with SELECT.....WHERE... Statement
Replies: 16
Views: 1745

Try changing the where clause to 'default = 1', like this... SELECT * FROM `form` WHERE `defaultform` = 1; That gives me a Syntax error. But, SELECT * FROM form WHERE 'defaultform' = 1 gives me no error. Although it also doesn't return any rows even though in the table there is an entry where defau...
by d3chapma
Mon Nov 27, 2006 9:58 am
Forum: Databases
Topic: Error with SELECT.....WHERE... Statement
Replies: 16
Views: 1745

Yes. Definitely.

If I take out the WHERE clause the statement works fine.
by d3chapma
Mon Nov 27, 2006 9:44 am
Forum: Databases
Topic: Error with SELECT.....WHERE... Statement
Replies: 16
Views: 1745

_______________________________________________________________________________________________________________ |id | defaultform | frequency | title | question1 | |2 | 1 | 0 | MMNP Questionnaire | Did you carry your smartphone with you today to sc...| The table basicly has this format. I don't see...
by d3chapma
Mon Nov 27, 2006 8:44 am
Forum: Databases
Topic: Error with SELECT.....WHERE... Statement
Replies: 16
Views: 1745

Ok, so I changed my column name to defaultform so now the code now reads: SELECT * FROM form WHERE defaultform IS TRUE and the error that I am getting from mysql_error() is: Unknown column 'defaultform' in 'where clause' I have checked and double checked to make sure that there were not any typos in...
by d3chapma
Fri Nov 24, 2006 1:49 pm
Forum: Databases
Topic: Error with SELECT.....WHERE... Statement
Replies: 16
Views: 1745

Error with SELECT.....WHERE... Statement

I'm trying to select a field in a row of a table where a boolean field is set to True. The field name is 'title', the table name is 'form' and the boolean field is 'default' and in the same table. The statement I am using is as follows: SELECT title FROM form WHERE default IS TRUE When I try to use ...
by d3chapma
Fri Nov 17, 2006 3:03 pm
Forum: PHP - Code
Topic: Identify individual users that are using mobile phones
Replies: 1
Views: 305

Identify individual users that are using mobile phones

I have a php page where users on mobile phones can fill out a survey. I'm looking for a way that I can get information from the header that will allow me to basically authenticate users so that I know that they are using a mobile phone. The key is that I only want the surveys of users who are using ...
by d3chapma
Thu Nov 16, 2006 10:32 am
Forum: PHP - Code
Topic: Retrieve IMEI from Mobile Devices Using PHP
Replies: 2
Views: 290

Hmmm, alright.

Thanks
by d3chapma
Thu Nov 16, 2006 10:07 am
Forum: PHP - Code
Topic: Retrieve IMEI from Mobile Devices Using PHP
Replies: 2
Views: 290

Retrieve IMEI from Mobile Devices Using PHP

Hi,

Is there any way to retrieve an IMEI number from a mobile device via php?

DC