Forum: MySQL 15 Days Ago |
| Replies: 2 Views: 414 In PHP the strtotime (http://au2.php.net/manual/en/function.strtotime.php) and date (http://au2.php.net/manual/en/function.date.php) functions might be useful to you. You can go:
for($i=0; $i<10;... |
Forum: MySQL Oct 12th, 2009 |
| Replies: 3 Views: 368 Not sure what DaniWeb's policy is, but for other forum-type sites that I have contributed to we kept all PM's, emails, forum posts in database tables. If the owner of the message deleted it (by... |
Forum: MySQL Mar 19th, 2009 |
| Replies: 1 Views: 603 I think in this situation you are better off explicitly joining the tables by account id. Like so:
SELECT COUNT(J.account) from JanTable J
INNER JOIN FebTable F
ON J.account = F.account
WHERE... |
Forum: MySQL Oct 7th, 2008 |
| Replies: 5 Views: 1,008 First, make sure that the SQL file has statements that read like this:
CREATE TABLE IF NOT EXISTS Example
-- table definition goes here
Then you actually need to run the mysql query by typing... |