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

V4NT0M · 10 Mar 2007 at 18:52

First thought in my head is a problem with AUTO_INCREMENT?

toString · 10 Mar 2007 at 18:54

I agree, check you have that selected for your primary key. Also some code might be useful too.

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

Beansprout · 10 Mar 2007 at 19:32

What's your table structure and the query you're using?

Primary keys are essential

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!

Beansprout · 10 Mar 2007 at 23:14

Look up the 'ORDER BY' part of SQL queries

drak3 · 10 Mar 2007 at 23:55

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

JonC · 11 Mar 2007 at 00:14

The "order by" is used when you query the database to order the results returned.

e.g. select * from xxx where aaa = bbb order by ccc

There is nothing wrong with having keys defined on your file, and the way that the data is actually stored is a rather esoteric requirement.

I would investigate the use of indexes/logicals/views for what you require.

Beansprout · 11 Mar 2007 at 00:14

The order in the table doesn't matter at all. 'ORDER BY' is added to your Select query for when you're displaying the data, so you can tell the database to order the result set

drak3 · 11 Mar 2007 at 00:21

Thanks, I understand how it works now