fenway

Really? You can't search the web? That would be the easiest way to "get a move on". here.

Sure, but what I'm saying is that TIME_FORMAT() allows you get back the desired format from the database.

You DON'T change the format of the database field -- you format the field when you SELECT this column back. Does that make sense?

"Undefined index" sounds like a php error....

Depends if those two values are different.

I'm hoping you've read this. Give this a good read.

I don't know what that means.

Try "DELETE FROM cancellations WHERE row_number='".$_POST[row_number]."'"

Just be very careful -- indexing is handled fundmentally different in InnoDB, so queries will perform differently too. At some point auto_increment was funny too, maybe this has been fixed.

Try "HAVING evaluator = 23".

There's an entire refman page dedicated to this issue.

Echo $sqldelete.

Don't double-post -- topic locked.

You still want BIGINT.

That depends on the nature of the table, the column you're extracting, and how the query performs... post the EXPLAIN.

Where does this error -- "Unknown column 'Array' in 'where clause' " -- come from? Which line?

Did you index it?

Fine... so what's the issue? You simply store all of the fields from each page whereever they belong... I'm confused.

Try using $gettheteam['cityname']. You're not bothering me, it's just synatx.

Not in the where clause you posted...?!?

Any other details? That's quite general and vague.

What is this for? What do you have so far?

You don't need to keep explaining it to me. You're issuing a query, storing the result set in $gettheteam... and then you're assigning the fetch_assoc() to itself (and assuming that only a single one will come back). But you're not pulling the field out of this hash.

If course... and bracket matching... how could I have forgotten?

Why?