>From MS-SQL Server Manual:
A subquery is a SELECT query that returns a single value and is nested
inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside another
subquery. A subquery can be used anywhere an expression is allowed.
Unfortunately you do not have Sub-queries in mySQL ...
Try this script...
<?php
$link = mysql_connect('localhost', 'root', '') or die('Could not
connect');
mysql_select_db('test') or die('Could not select database');
// Declare vars..
$sports = $graduation = $both_activities = array();
// Get all the schools where there is "Sports"
$sql = "select distinct sid from school_highlight_details where hid =
'2'";
$result = mysql_query($sql) or die("Query failed");
while (list($school_id) = mysql_fetch_row ($result)) $sports[] =
$school_id;
mysql_free_result($result);
// Get all the schools where there is "Graduation"
$sql = "select distinct sid from school_highlight_details where hid =
'4'";
$result = mysql_query($sql) or die("Query failed");
while (list($school_id) = mysql_fetch_row ($result)) $graduation[] =
$school_id;
mysql_free_result($result);
// Find common in both..
$both_activities = array_intersect($sports, $graduation);
$condition = '(';
foreach($both_activities as $anything => $school_id) $condition .=
"$school_id, ";
$condition = substr($condition, 0, -2) . ')';
$sql = "Select sID, school_name FROM school where sID in $condition";
$result = mysql_query($sql) or die("Query failed");
while (list($sID, $school_name) = mysql_fetch_row ($result)) echo "$sID.
$school_name<br>";
mysql_free_result($result);
mysql_close($link);
?>
If you are using mySQL 4, read on UNION ...
(SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY a LIMIT 10)
UNION
(SELECT a FROM table_name WHERE a=11 AND B=2 ORDER BY a LIMIT 10)
ORDER BY a;
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
