phpmonkey
-
Posts
3 -
Joined
-
Last visited
Never
phpmonkey's Achievements
Newbie (1/5)
0
Reputation
-
nobody????
-
You don\'t actually setup relationships, but it is instead in how you query the database. If you have a SQL book, just look at queries and this will become quite clear. You could also look at JOIN in the SQL manual.
-
Here\'s what I\'m trying to get: How can I retrieve all the records from last month (table has date field) by looking at today\'s date. This can\'t be that hard can it??? CREATE TABLE slota ( showid int(10) unsigned NOT NULL auto_increment, date date NOT NULL default \'0000-00-00\', program varchar(25) NOT NULL default \'\', airtime1 varchar(12) NOT NULL default \'00:00 AM\', airtime2 varchar(12) NOT NULL default \'00:00 AM\', topic text NOT NULL, description text NOT NULL, category varchar(50) NOT NULL default \'\', audiolink varchar(100) NOT NULL default \'\', repeat char(1) NOT NULL default \'\', repeatdate date NOT NULL default \'0000-00-00\', duration time NOT NULL default \'00:00:00\', type varchar(25) NOT NULL default \'\', PRIMARY KEY (showid) ) I want to: SELECT * from slota WHERE date = \"Last Month\" SELECT * from slota WHERE date = \"Two Months Ago\" SELECT * from slota WHERE date = \"Three Months Ago\" :?