use brackets where (sub1 or sub2) and geo
-----Original Message----- From: phplist [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 2:41 PM To: [EMAIL PROTECTED] Subject: [PHP] Fetching 1 array from either one of 2 possible columns? I'm working on a query by selection type of form, where if a user selects a subject to get information. Each database entry will have 2 subject fields, Subject 1 being the main subject and Subject 2 being the cross-subject. A table is set up like this: +------+--------------+------+----------+----------+-------------+ | ID | Organization | URL | SUBJECT1 | SUBJECT2 | Geographic | +------+--------------+------+----------+----------+-------------+ | 1 | Acme | www | Math | English | Canada | | 2 | Loony Toons | www | Comedy | Math | Brazil | ... The idea is that the query will check the database to see if $Subject has a match in either Subject1 or Subject2. the geographic is an optional selection. If I select Math as a subject, and left the Geographic option unselected, I want it to go into either Subject1 and Subject2 to find Math. In this case both records would be a hit. Below is my query setup and formatting: ******* $sql = "SELECT * FROM links WHERE SUBJECT1='$subject' OR SUBJECT2='$subject' AND GEOGRAPHIC='$geographic' ORDER BY ORGANIZATION ASC"; $sql_result = mysql_query($sql); if (!$sql_result) { echo "Can't execute $sql " . mysql_error(); exit; } // organizes data in an orderly manner (ie bulleted area) while ($row = mysql_fetch_array($sql_result)) { $esc_organization = $row["ORGANIZATION"]; $esc_desc = $row["DESCRIPTION"]; $esc_url = $row["URL"]; $esc_subject = $row["SUBJECT1"]; $esc_geographic = $row["GEOGRAPHIC"]; $organization = stripslashes($esc_organization); $description = stripslashes($esc_desc); $url = stripslashes($esc_url); $subject = stripslashes($esc_subject); $geographic = stripslashes($esc_geographic); $option_block .= " <li> <a href=\"http://$url\";>$organization</a></li><br> $description<br> URL: <a href=\"http://$url\";>$url</a></li>\n"; } ******** Now, of course, if I were to use this, it will only use the Subject1 data. How do I tell it to use the results from either Subject 1 or Subject 2? Thanks in advance, Laurie M. Landry -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
