fenway

I'm not too familiar with "custom" drivers... it's hard to believe that standard OBDC doesn't work, though.

I assume this isn't a one-off type thing.

No you didn't... you ran the query... please echo the query string that you're passing to mysql_query().

A separate input page -- you mean like with htaccess? That must be PITA to maintain. I was simply assuming you had some php code checking credentials.

Well, a column list for the TMP table would help....

Yeah, that's almost impossible to do... usually, I have a sortorder within each level of category... so a simple order by clauses suffices.

Please echo that query.

Well, you don't need distinct in this case, since there will only be one manufacturer/date pair in any case. But yes, maybe it's not correctly converting all of them?

Then only make you page available during these dates.. .this isn't a mysql issue.

First, your live would be SO much easier if your DB was like this: Table 1 = users: user_id username password Table 2 = profiles: profile_id user_id firstName lastName Table 3 = friends: friend_id user_id other_friend_id Then the JOIN itself should be easily constructed.

You're looking to make a pivot table... data stored in this way isn't not really easily coerced into other formats.

You're missing a comma between PRIMARY KEY ... and FOREIGN KEY.

Where's the authentication code?

Try this: SELECT FIELD( Clarity, 'Flawless', 'VVS-1', 'VVS-2', 'VS-1', 'VS-2', 'SI-1', 'SI-2', 'SI-3', 'I-1', 'I-2', 'I-3' )

With a few JOINs, that shouldn't be too hard... but what are you going to order by? Don't say UID...

Never heard of that!

yeah, that one...

There's a great book called high availability mysql, 2nd ed.

It's complex because it's all on one line... could you format that nicely?

It's a bad idea to run this regularly, since it locks the table... every few weeks would be fine.

I'm sorry, I don't really understand.

Now I understand... you'll need to collect the LAST_INSERT_ID() as you go along.

Help with what?

I'm still lost.

I don't understand.