mysql helps

hsteo, This is all pretty much one problem. Please keep it contained here rather than posting across multiple forums. This only creates confusion. Users will have to surf the forums just to see all the replies.

Thanks. :wave:

Is this design of table needed in your application?

It would be far easier to query if you had something like:

Code:

---

NAME      |    VALUE
------------------------
able      |    12/1/2005
donkey    |    1/5/2006

---

Quote:

---

Originally Posted by HairyMonkeyMan

Is this design of table needed in your application?

It would be far easier to query if you had something like:

Code:

---

NAME      |    VALUE
------------------------
able      |    12/1/2005
donkey    |    1/5/2006

---

---

The idea for that design is to locate those items that took place within the time specified however if there is no occurance off such event, then the date should be chosen such that it is smaller than the range of the date.

I am also helpless at those demands

If you were to use my idea for a design, you could query for things between dates like this:

Code:

---

select * from table
where `name` = 'able'
and date(value) between date(?date1) and date(?date2)

---