I'm trying to use a mysql query for showing some entries related to a category. First, I've sent the category_id using a form and get method in a file named compare.php !!!
In a new file named step2.php, I wanted to show the names of all the entries related to chosen category.
So, the code I have used, is this :
$category = (int)$_GET['category_id'];
$query = mysql_query ("SELECT * FROM mt_entry where `entry_category_id`=$category")or die(mysql_error());
Unfortunately, there is no Category ID in entry_category_id and all of results are NULL !
Can somebody help me to write this query ?! I would really appreciate it.
Reported on Movable Type 5