Sorting Problem

2004-05-21 Thread H Bartel
Hi, I have a problem with selecting / ordering by different criteria from different tables. Maybe this doesn't even work, or there is a much better way? I have the following tables which look like this: table tartist ++--+--+---+---+ | id | name | info | image | genre | +

Date Question 2

2004-05-10 Thread H Bartel
Hi again, I got the MONTH() selection thing working now, but it seems like I'm not getting the hang of the concept with the sql date.. With PHP and a UNIX timestamp I would just insert a timestamp, the select it and after selection, go ahead and manipulate it to fit my needs, like extracting day

Select month from Date

2004-05-10 Thread H Bartel
Hi, I am trying to start using the mySQL Date functions instead of the unix timestamp from PHP. I have read the man page several times now, but still haven't come up with a solution for this simple query: SELECT id, datecol, text FROM table WHERE month-in-date-col = $mySelectedMonth; This should