fenway

Like an echo of the sql statement that insert data.

It's great for TRIGGERS.

Why are you storing it that way/

That's not valid syntax. So it won't work. As for the actual question, you need to decide which one of the three records you want to use.

If that's the case, I think a self-join is more appropriate... why duplicate the info?

First, why not a JOIN? And it's very scary to use array references like that... in fact, you mean $arr1 on your last line. I'm just guessing column names here.... select t.ref, u.username from topref inner join users where u.username = t.username order by t.ref desc limit 100 As for your actual question, you can use WHERE signup_date > CURDATE() - INTERVAL 7 DAY.

Sure, just add more part to the where clause...

First ,please stop posting all of your script code. Second, make sure you turn on all error reporting in php. Third, if you can't echo, then there's something else wrong.

PLEASE don't use this code! You should only issue a single INSERT statement, with multiple VALUES().

How is that possible? Re-post the query.

Solved how?

I dont get what you want me to do ....... I want you find these records without using the date as the search criteria.

No, not huge... just one extra "AND" for each chosen drop-down (assuming you want it narrow the results... ) That depends... if there are "custom fields" for each product type, then yes.

No, not at all... that won't work. Why not use a datetime field to mark the record as expired, instead of deleting it?

And it had better be a INNER JOIN if you're going to use a where clause from the 2nd table!

First, "Not Recorded" should be stored as NULL in a database. Second, adding "all" to the default of a dropdown should be easily accomplished in HTML. Third, you need to examine each one of the fields that is POSTed to your form, and build each part of the WHERE clause sucessively. If it's "all", then leave it out. You'll also need to decide how "Not Recorded" is treated. Same goes for Capacity, where you'll have to translate your options.

Could you post the error message?

That IS the correct format.

So you just want to keep track of which distributor was signed up by which dealer?

You could do this in mysql, too....

I really hope you didn't change this field from a DATE column.

I guess I'm trying to figure out exactly what you're trying to query....

Precisely. Are all of these fields in a single table?

Um, you're missing a JOIN condition!

Those links were useless... hence "removed". Don't try and limit them by this field... use a differnet one.