[jQuery] jQuery .post and.load with some PHP
Okay, so I have This PHP code.
It creates a list of all the categories from database and it creates a
div with all the items from the database. Each item is associated with
a category id as to which category it is apart of. The list of
categories should be clicked on and then the jQuery will run a post of
the category id and then reload the list of items to only show items
in the selected category.
if(!empty($_POST) || $catSortID != "") {
$catSortID = $_POST['catSortID'];
$catSortItem = " WHERE category_id = " . $catSortID;
} else {
$catSortItem = "";
}
$catList = mysql_query("SELECT * FROM adminCategory ORDER BY
CategoryName");
$catLinks = array();
while ($catlistRow = mysql_fetch_array($catList)) {
$catLinks[] = '<a href="javascript:;" class="sortCat" id="sortCat_'.
$catlistRow['id'].'" onclick="sortItemCat('.$catlistRow['id'].')">'.
$catlistRow['CategoryName'] .'</a>';
}
echo "<p id=\"catSortList\">" . implode(' | ', $catLinks) . "\n
\n";
$result = mysql_query('SELECT * FROM adminItems'.$catSortItem.' ORDER
BY id');
while ($row = mysql_fetch_array($result)) {
$textmsg = $line = str_replace("|", "</li><li>", $row['textmsg']);
$catID = $row['category_id'];
$catsql = "SELECT * FROM adminCategory WHERE id = " . $catID;
$catName = mysql_query($catsql);
while ($catRow = mysql_fetch_array($catName)) {
print '<div id="Item_' . $row['id'] . '" class="itemListBox">
<img src="../content/img/items/imgresize.php?src=../content/'.$row
['image_url'].'&w=100" alt="'.$row['name'].'" title="'.$row['name'].'"
class="itemListImg" />
<div><h3 class="itemTitle">' . $catRow['CategoryName'] . '
» '.$row['name'].'</h3>
<p class="itemDesc"><strong>Description: </strong>'.$row
['description'].'
<p class="itemMsg"><strong>Text Message(s): </strong>
<ol class="itemMsgList"><li>'.$textmsg."</li></ol></div>
</div>\n\n";
}
}
Problem is, whenever jQuery runs a post and then loads it, it never
returns with only the selected category items.
function sortItemCat(id) {
var catList = $("#sortCat_"+id).text();
$.post('lib/loadItem.php', { catSortID: id }, function(data) {
if(dataq){
$("#itemList").load("lib/loadItem.php");
}else{alert(data+" -- "+id+" -- "+catList);}
});
}
Any idea as to what might be going on?