Re: [PHP-DB] odbc connect problem

2002-08-12 Thread chip . wiegand
salamander [EMAIL PROTECTED] wrote on 08/09/2002 04:31:35 PM: Chip, I wonder if you set the ODBCINI environment variable with the putenv()? Yep, they are there and I am getting this error when attempting to load the web page - Warning: SQL error: [iODBC][Driver Manager]Specified driver

[PHP-DB] select distinct with all columns

2002-08-12 Thread russ arbuthnot
I have a mysql table named equipment with 11 columns named: id, staff_member, class, type, manufacturer, model, description, picture, created, modified, and published. I'm trying to write a select statement similar to this: SELECT DISTINCT type FROM equipement WHERE class = microphones; yet

RE: [PHP-DB] select distinct with all columns

2002-08-12 Thread Ryan Jameson (USA)
SELECT DISTINCT type,* FROM equipement WHERE class = microphones; Ryan -Original Message- From: russ arbuthnot [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 12:07 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] select distinct with all columns I have a mysql table named

[PHP-DB] Re: select distinct with all columns

2002-08-12 Thread Dan Koken
SELECT * FROM equipement WHERE class = microphones GROUP BY type; Russ Arbuthnot wrote: I have a mysql table named equipment with 11 columns named: id, staff_member, class, type, manufacturer, model, description, picture, created, modified, and published. I'm trying to write a select

RE: [PHP-DB] select distinct with all columns

2002-08-12 Thread Ryan Jameson (USA)
Sorry, I wasn't thinking... you actually want to do something like this: select type, max(id) as id, max(staff_member) as staff_member, max(class) as class, max(manufacturer) as manufacturer, max(model) as model, max(description) as description, max(picture) as picture, max(created) as created,

Re: [PHP-DB] best way to stare true, false

2002-08-12 Thread leo g. divinagracia iii
if you are storing a bunch of T/F, you can store 8 of them into a single byte... each bit position will represent one question... you just have to do some BIT manipulation on your end... andy wrote: Hi there, I am searching for the best way to store true or false inside a MySQL DB. With