fenway

How are these two tables related?

You can run queries whenever you want -- on a schedule, use the 5.1 event scheduler or cron.

You could have an auto-increment across both columns... but otherwise, yes, get the MAX(line_num) for a given receipt_num, then add one -- this can be done in a single statement

hate to disagree, but this is in fact exactly what happened. some of the dates were changed to 00-00-0000. promise. wouldn't lie to you. I think PFMaBiSmAd meant that it won't STR_TO_DATE() it for you.

Sort of... you can implement a queue using INSERT... ON DUPLICATE KEY UPDATE..., triggers, staging tables, etc.

You can't use an aggregate expression in the WHERE clause -- move it to a HAVING clause.

I suppose if you dupe every table, that would work too... but now you need joins.

Files? You need to check the priviledges table.

They should be different rows, not columns...

Wait a sec... did you actually create a multi-column fulltext index? I meant the string, not the result.

What does the query look like after? My guess is you're missing single quotes around $keywords.

They have different precedence, that's all -- if you wrap the RHS of an || in parens, it will be the same as "or". Otherwise, they're the same.

Could you post a few lines from the output?

So you double-posted... that's a no-no.

This will get out of control VERY fast if you have 20 tables with 20 fields each... easier to dupe the records within the table.

I thought it was mysql_fetch_assoc()....

Sounds like there's a missing grant from the other IP.

The way you've set it up, you'll have to JOIN as many levels deep as you want to display -- you may want to look into the list adjacency model too.

It's virtually impossible to implement this feature -- it would make calculating the join plan practically impossible.

Yes, but "how"?

That's right -- you know what day of the week it is now, so you can easily subtract/add the difference to sunday.

Did you run the inner query alone to see if the output makes sense?

First, use an IN clause, or BETWEEN. Second, you never use ic_index_cities -- and you're not joining it properly either -- please clarify.

Which line?

Assuming it's NOT NULL already..... and it should be UNSIGNED, too.