Help needed on qry response

RoCk

Ok. I make this short 🙂

I am going bald now from pulling my hair out I know this is going to be easy but I cant find how to do it.

I have a page that pulls information from one table and prints it out in a form on the screen. Now I want to limit the information returned.

There are two fields that in the table that have the information i want to look for.

ex: Players_table
Fields: name , emal, conferance, division.

Now I only want ti to return those records that have NFC in the conferance field and East in the division field.

Please help.....

RoCk

THis may help. This is the page code.

<?php
require('variables.php');
require('variablesdb.php');
include("extention.inc");
include("mainfile.$phpEx");
include("header.$phpEx");
include("example.htm");
?>
Standings
<div align="center">
<center>
<table border="2" cellpadding="1" width="90%" bordercolorlight="#0000FF" bordercolordark="#3366FF">
<tr>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap>Conference</td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap>Division</td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap>Team</td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap>Player</td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap>Wins</td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap>Losses</td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap>Points</td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap>Percentage</td>
</tr>
<tr>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="left" nowrap> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
</tr>
<?php
if ($standingsnogames == "yes") {
$where = 0;
}
else {
$where = 1;
}
?>
<?php
$db = mysql_connect($databaseserver, $databaseuser, $databasepass);
mysql_select_db($databasename,$db);
$sortby = "points DESC";
$sql="SELECT * FROM $playerstable WHERE games >= $where ORDER BY $sortby, games ASC";
$result=mysql_query($sql,$db);

$num = mysql_num_rows($result);
$cur = 1;

echo "<ol>";

while ($num >= $cur) {

$row = mysql_fetch_array($result);

$team = $row["team"];
$division = $row["division"];
$conference = $row["conference"];
$name = $row["name"];
$mail = $row["mail"];
$icq = $row["icq"];
$aim = $row["aim"];
$country = $row["country"];
$wins = $row["wins"];
$losses = $row["losses"];
$points = $row["points"];
$games = $row["games"];
if ($games <= 0) {
$percentage = 0.000;
}
else {
$percentage = $wins / $games;
}
$penalties = $row["penalties"];
$pen = $penalties;
if ($pen >= 5) {
$penplayer = "**";
}
if ($pen >= 4) {
$penplayer = "";
}
else if($pen >= 3) {
$penplayer = "";
}
else if($pen >= 2) {
$penplayer = "";
}
else if($pen >= 1) {
$penplayer = "*";
}
else {
$penplayer = "";
}

$streakwins = $row["streakwins"];
$streaklosses = $row["streaklosses"];

if ($streakwins >= $hotcoldnum) {
$color = "#FF0000";
$text = "hot";
}
else if($streaklosses >= $hotcoldnum) {
$color = "#0080FF";
$text = "cold";
}
else {
$color = "#FFFFFF";
$text = "";
}

?>
</ol>
<tr>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap><?php echo "$conference" ?></td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap><?php echo "$division" ?></td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap><?php echo "$team" ?></td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="left" nowrap> <?php echo "<img src='$directory/flags/$country.bmp' align='absmiddle'> <a href='$directory/profile.php?name=$name'>$name</a>"?> <?php echo "$penplayer" ?> "><?php echo"$text" ?> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap><?php echo "$wins" ?></td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap><?php echo "$losses" ?></td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap><?php echo "$points" ?></td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap><?php printf("%.3f", $percentage); ?></td>
</tr>
<?php

$cur++;
}

echo "</ol>";

?>
<tr>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
<td width="20%" bgcolor="<?php echo"$color3" ?>" align="center" nowrap> </td>
</tr>
</table>
</center>
</div>

If a player is hot he won 5 or more games in a row. 
If a player is cold he lost 5 or more games in a row. 
Stars (*) indicate the number of penalties for that player.

<?

LordShryku

Couple ways you could go about this.
First: I'd suggest putting it in your SQL statement...
$sql="SELECT * FROM $playerstable WHERE conference = 'NFC' AND division = 'EAST' AND games >= $where ORDER BY $sortby, games ASC";

Or you could throw a condition before your output:

if($division == "EAST" && ($conference == "NFC")) {
spit out results

RoCk

You is Da man.......

Thank you I used the qry statement.... works great... Thank you...