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 |
+
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
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