>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

Reply via email to