fenway

I see INSERT, not update.

Please post the offending query here.

OK, then make it easier to digest for the rest of us. Take a single script, find the sql query, echo it to the browser, check for error messages, and drop the redirect for testing.

You can issue an ALTER statement with MODIFY, and then specify BEFORE/AFTER.

I'm saying that you can specify NOT NULL, and use different values.

Please use code tags next time -- is this solved?

I don't need to see you code -- compare $getaddress with $list and you'll see what I mean.

You don't need to run the alter statement, truncate does that automatically.

Depends how the records in A and B are related... a LEFT JOIN may be enough.

How about a column list?

Oh, I see... you mean your query, not "SQL" in general. Yes, NULL aren't fun to use for date ranges. DATE supports '1000-01-01' to '9999-12-31' -- if you use these values (or 0000-00-00, depending on your sql mode), instead of NULLs, then your queries will work just fine -- besides, it makes the data and index smaller anyway .

You can, but why does it matter?

Use: select trxtal.groupno as groupn,artwork.artworkno as artworkno,count(trxtal.groupno) as grp from (trxtal, mstcus) LEFT JOIN artwork ON (trxtal.groupno=artwork.groupno and trxtal.classcode=artwork.classcode) where trxtal.groupno=mstcus.groupno group by mstcus.groupno having sum(artwork.artworkno)>0 But really, don't use commas to join tables... it's very bad form.

Not sure I understand what the code is really doing...

Sure, use CASE.

If it's not being inserted, it's either not being called or there's an error. The statement you're passing to mysql_query()

Why not simple add the day part and use proper date math?

What do you mean "SQL doesn't work with NULL"?

That's a prepared statement.

Like I said, get the unique, ordered list of letters, and limit that -- if used in a derived table, you can join that back to whatever you want.

That's impossible.

DISTINCT isn't a function... and since you're getting back IDs, it won't do anything. What do you want grouped?

Sure, you can use an IF().

Can we see the sql statement and any associated error messages?

I prefer EXTRACT( YEARMONTH from yourField ) rather than using string functions... it's more explicit and future-proof.