Display results

[spectsteve7]

I have a page with links such as http://mysite.com/results.php?category=TVs. On the results page I want all items using the URL defined category to display. I have the following code on the results page but it's not working. Any ideas?

<?
$sql="select * from profiles where category = $HTTP_GET_VARS[category] ";
$sql_result=mysql_query($sql,$connection) or die("couldn't execute query");
?>

[Houdini]

Try this instead

<?php 
//$category=$HTTP_GET_VARS['category'];//uncomment in case the below doesn't work
$category=$_GET['category'];

$sql="select * from profiles where category = '$category' ";
$sql_result=mysql_query($sql,$connection) or die("couldn't execute query");
?>

[cgraz]

A small addition to houdini's code that may help you debug MySQL in this situation and in the future.

1. Print the query string
2. Use mysql_error()

   <?php
   
   $category = $_GET["category"];
   
   $sql = "SELECT * FROM profiles WHERE category ='".$category".'";
   
   // Print Query String Just to see if it's being sent correctly
   print $sql;
   
   // Run query using mysql_error() for additional error checking
   $sql_result = mysql_query($sql,$connection) or die(mysql_error());
   
   ?>