How do I merge 2 querys together
$result = @mysql_query("SELECT * FROM records_cal ORDER BY `date` DESC");
and
$result = @mysql_query("SELECT * FROM records_scrim ORDER BY `date` DESC");
mad easy quick question
Moderator: General Moderators
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
-
Cruzado_Mainfrm
- Forum Contributor
- Posts: 346
- Joined: Sun Jun 15, 2003 11:22 pm
- Location: Miami, FL
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
-
Cruzado_Mainfrm
- Forum Contributor
- Posts: 346
- Joined: Sun Jun 15, 2003 11:22 pm
- Location: Miami, FL
i think...
note: i edited it
note: edited again... after u posted
Code: Select all
SELECT * FROM records_cal,records_scrim ORDER BY records_cal.date DESC, records_scrim.date DESCnote: edited again... after u posted
Last edited by Cruzado_Mainfrm on Thu Feb 12, 2004 8:41 pm, edited 2 times in total.
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
This is really weird..
basically my script checks to see which variable is being loaded and depending which one a different queries are loaded.
http://www.jcartonline.com/xe
on the left you will see the records thing and it sais cal-o - info....scrim - info.... total - info.....
check out cal-o and scrim info then look at total... the only different in between these are that a different query is being loaded. They are all running from records.php.. check it out
the total is basically just getting both the queries together, oither than that they r identical scripts but the total is really weird.
basically my script checks to see which variable is being loaded and depending which one a different queries are loaded.
http://www.jcartonline.com/xe
on the left you will see the records thing and it sais cal-o - info....scrim - info.... total - info.....
check out cal-o and scrim info then look at total... the only different in between these are that a different query is being loaded. They are all running from records.php.. check it out
the total is basically just getting both the queries together, oither than that they r identical scripts but the total is really weird.
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact: