Hi all,
I am currently having alot of trouble trying to select * from 2 tables and ordering these results via their timestamp.
I have the following table structures:
[B]pm_messages
[code]
pm_message_id int(10) unsigned NOT NULL auto_increment,
client_id int(10) NOT NULL default ‘0’,
pm_project_id int(10) NOT NULL default ‘0’,
pm_categories_id int(10) NOT NULL default ‘0’,
pm_message_title tinytext NOT NULL,
pm_message_text text NOT NULL,
pm_message_date timestamp(14) NOT NULL,
PRIMARY KEY (pm_message_id)
[B]pm_milestones
[code]
pm_milestone_id int(10) unsigned NOT NULL auto_increment,
pm_project_id int(10) NOT NULL default ‘0’,
pm_milestone_title varchar(255) NOT NULL default ”,
pm_milestone_date date NOT NULL default ‘0000-00-00’,
assigned_group int(10) NOT NULL default ‘0’,
pm_milestone_subdate timestamp(14) NOT NULL,
PRIMARY KEY (pm_milestone_id)
And this is my query so far:
[code]
$query_messages_today = mysql_query(“SELECT * FROM pm_messages,pm_milestones WHERE pm_messages.pm_project_id=pm_milestones.pm_project_id AND pm_messages.pm_project_id = ‘” . $_SESSION[‘project_info’][‘2’] . “‘ AND pm_messages.pm_message_date BETWEEN CURDATE() AND NOW()”);
$total_messages = mysql_num_rows($query_messages_today);
Any ideas on how i can achieve this?
Cheers,
camcim