0

This is my php code, I was wondering if you could help me,

<link rel="stylesheet" href="style.css" />
<script type="text/javascript" src="script.js"></script>
<?php $cat = mysql_real_escape_string($_GET['category']);

include '../includes/db-conns.php';



    //The file is being accessed on the staging site
    $hostname = $hostname3;
    $username = $username2;
    $password = $password2; 
    $databasename = $databasename3;


$link = mysql_connect($hostname, $username, $password);
mysql_select_db($databasename, $link);

//sets encode to utf8
mysql_query("set names utf8");

ini_set ("display_errors", "on");
//ini_set ("error_reporting", 6143);


 $query = "SELECT * FROM 100_people WHERE '$cat' IN (ppl_cat1,ppl_cat2,ppl_cat3,ppl_cat4,ppl_cat5,ppl_cat6,ppl_cat7,ppl_cat8,ppl_cat9,ppl_cat10,ppl_cat11,ppl_cat12) ORDER BY ppl_id ASC";




$result = mysql_query($query) or die(mysql_error());
?>                              <?php /*?>Navigation Loop<?php */?>
<TABLE cellpadding="0" cellspacing="0" border="0" class="sortable" id="sorter">
<tr class="nosort">
<td>Rank</td>
<td class="nosort">Image</td>
<td class="nosort">Name</td>
<td class="nosort">Title</td>
<td class="nosort">Category</td>

</tr>
<?
while ($row = mysql_fetch_assoc ($result)) {
echo "<TR>\n";
echo "<td>" . $row['ppl_id'] . "</td><td><img src='http://defensenews.com/assets/100people/" .$row['ppl_image']."' width='50px'/></td><td><a href='www.defensenews.com/100people/person?vip=". $row['ppl_id'] . "'>" . $row['ppl_name']."</a></td><td>" . $row['ppl_title'] . "</td>\n";
?>
<td><?php if ($row['ppl_cat1']){






    echo '<a href="www.defensenews.com/people/category?category='. $row['ppl_cat1'].' ">'. $row['ppl_cat1'].'</a>';  }

    if ($row['ppl_cat2']){






    echo ', <a href="www.defensenews.com/people/category?category='. $row['ppl_cat2'].' ">'. $row['ppl_cat2'].'</a>';  }if ($row['ppl_cat3']){






    echo ', <a href="www.defensenews.com/people/category?category='. $row['ppl_cat3'].' ">'. $row['ppl_cat3'].'</a>';  }if ($row['ppl_cat4']){






    echo ', <a href="www.defensenews.com/people/category?category='. $row['ppl_cat4'].' ">'. $row['ppl_cat4'].'</a>';  }if ($row['ppl_cat5']){






    echo ', <a href="www.defensenews.com/people/category?category='. $row['ppl_cat5'].' ">'. $row['ppl_cat5'].'</a>';  }if ($row['ppl_cat6']){






    echo ', <a href="www.defensenews.com/people/category?category='. $row['ppl_cat6'].' ">'. $row['ppl_cat6'].'</a>';  }if ($row['ppl_cat7']){






    echo ', <a href="www.defensenews.com/people/category?category='. $row['ppl_cat7'].' ">'. $row['ppl_cat7'].'</a>';  }if ($row['ppl_cat8']){






    echo ', <a href="www.defensenews.com/people/category?category='. $row['ppl_cat8'].' ">'. $row['ppl_cat8'].'</a>';  }if ($row['ppl_cat9']){






    echo ', <a href="www.defensenews.com/people/category?category='. $row['ppl_cat9'].' ">'. $row['ppl_cat2'].'</a>';  }if ($row['ppl_cat9']){






    echo ', <a href="www.defensenews.com/people/category?category='. $row['ppl_cat10'].' ">'. $row['ppl_cat10'].'</a>';  }if ($row['ppl_cat11']){






    echo ', <a href="www.defensenews.com/people/category?category='. $row['ppl_cat11'].' ">'. $row['ppl_cat11'].'</a>';  }if ($row['ppl_cat12']){






    echo ', <a href="www.defensenews.com/people/category?category='. $row['ppl_cat12'].' ">'. $row['ppl_cat12'].'</a>';  }?></td>
<?php
echo "</TR>\n";
}
echo "</TABLE>\n";
?>
<script type="text/javascript">
var sorter=new table.sorter("sorter");
sorter.init("sorter",1);
</script>

When I run this, If I run the query in phpMyAdmin it works fine. But if I use this on my page Id returns all records not ust the records that have $cat in one of the 12 columns. Any Ideas on what I am doing wrong. I have tried removing the single quotes from around my variable but no dice.

Thanks,

2
Contributors
2
Replies
3
Views
4 Years
Discussion Span
Last Post by AMADH
0

Are you sure the catagory is being set properly? What do you get if you var_dump($cat); or echo $query; ?

0

Thanks for your help Glider Pilot, I got it working. I moved the part where I set $get down and it works fine now. Thanks for the help.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.