SQL quicky pls

drak3 · 10 Mar 2007 at 18:51

Hello,

I developed a php script to take info from post and insert it in a table in mySQL db. Everything works fine, BUT only once!

I click post and it works, then I try post again but it wont get the second post. However, if I delete the first post from phpMyAdmin and try then it works. So I can have like 1 entry max there? :confused:

ps: I use CURDATE() and CURTIME() to fill some fields btw, dunno if it matters.

Thanks

drak3 · 10 Mar 2007 at 19:24

The primary key is the problem it seems. I droped the primary key and now it works like a charm

I do not plan to do any relationships btw with this table, so it should be fine without a primary key? (I know its only needed for relationships? or?)

Thanks

drak3 · 10 Mar 2007 at 23:01

I sorted the problem. However, I would like my table to be kept always sorted by date (first) and then (time).

For example,

if there 2 entrys on the same date then it sorts by time.

Is this a setting or I need to do timed queries?

Thanks a lot!

drak3 · 10 Mar 2007 at 23:55

ok, so I have to do it manually every time I add a new entry?

drak3 · 11 Mar 2007 at 00:21

Thanks, I understand how it works now