[Resolved] Problem with a query in a row

natman3

I am seeking to pull out information for my dba where I have three different types of categories. I am wanting to display only two of them I tried using this statment but it only selects the collegiate divisionType. I am wanting also the divisionType for highschool to be displayed as well. Does anyone have any suggestions on what i should try. Oh the three typs are collegiate, highschool, admin. I only wish to display all but admin.

<table class="tableFont" width="400" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#999999">
<tr align="center" bgcolor="#CCCCCC"> 
  <td colspan="6"><strong>All registered athletes</strong></td>  

</tr>
<tr align="center" bgcolor="#CCCCCC"> 

	<td>School Name</td>
	<td>Coach Name</td>
	<td>Division Type</td>



</tr>
<?php


		$result = mysql_query("SELECT id, schoolName, firstName, divisionType FROM users WHERE divisionType='collegiate' OR 'highschool' ORDER BY schoolName") or die('Error : ' . mysql_error());


while(list($id, $schoolName, $firstName, $divisionType) = mysql_fetch_array($result, MYSQL_NUM))
    {

?>
<tr bgcolor="#FFFFFF"> 


  	<td><a href="school_roster.php?team_id=<?php echo $_SESSION['id'];?>"><?php echo $schoolName; ?></a></td>
	<td><?php echo $firstName; ?></td>
	<td><?php echo $divisionType; ?></td>
</tr>
<?php
    }
 ?>

</table>
<?php

 $row = "SELECT * FROM users WHERE divisionType='collegiate' OR 'highschool' ";
 $result = mysql_query($row); 

 ?>

devinemke

SELECT * FROM users WHERE divisionType = 'collegiate' OR divisionType = 'highschool'

bradgrafelman

The 'OR' statement in MySQL separates two entirely different expressions. At current, you're two expressions are:

divisionType='collegiate'

and

'highschool'

Notice the error now? See if you can figure it out on your own. If not, let us know.

EDIT: Neeeevermind... posted too late.

natman3

Thanks that resolved the issue