fenway

That's correct, if you want to find multiple http://, you'll have to find out how many there are first, and then do this for each one.

LOAD DATA FROM INFILE...?

I tried this but it gaves me an error, then I tried this and it gave me a date but not the date that was in the database, seems to be some date that was already set. $datetime = strtotime('$entrydate'); echo date("l, jS F, Y h:i:s a", $datetime); This is a MYSQL function, not a php function.

You want one query for each user, and left join them....

Or you you mean using LEFT( yourColumn, 1 )

I'm quite confused... you'd have all of the letters regardless.

Then backticks are in order.

I don't know, since you're not giving us (a) the expected results or (b) the current results.

Check the refman on innodb settings...

That's the definition of what truncate does.

Why not use DATE_FORMAT( entry_date, <your desired format> )?

That's hard to believe.

select id, count(id) as total_count from table_name group by id

Then you'd have to to pull all the track for each user in seperate select statements, and left join them in mysql.

Well, ibdata files have a fixed size unless you allow them to grow.

You mean replication?

You could join with user & track if both were known....

I can't find such a post.

Define "wrong".

"displayed in phpmyadmin"? so it's not an sql issue at all?

You can UNION DISTINCT as long as you keep the columns consistent.

DELETE doesn't work that way... depending on how you write it, it can delete all matching records from the tables you specify.

"another table"?

Be careful, COUNT doesn't count nulls.

Format the time correct, then use str_to_date() to make it a true mysql TIME field, and only then case you do date math on it.