whats wrong with this query?

[seby]

Hi.

The first query works perfectly fine, but the second query does not. The second query gives no errros but doesn't return any results.

any ideas?

	$result = $db->sql("SELECT * FROM $table WHERE id = '$HTTP_GET_VARS[id]'");
        while ($row = mysql_fetch_row($result)) {

   $newsid = $row[0];
   $author = $row[1];
   $category = $row[9];

   $result = $db->sql("SELECT topic FROM $table WHERE category = '$category' ORDER BY id DESC");
     while ($row = mysql_fetch_row($result)) {

	 $related = $row[4];
}

the second query is suppose to get the $category from the first query and match it with the topic.

[DigitalExpl0it]

give the second query another var name

   $result2 = $db->sql("SELECT topic FROM $tabe WHERE category = '$category' AND active = '1' ORDER BY id DESC LIMIT 5");

 while ($row2 = mysql_fetch_row($result2)) {

     $related = $row2[4];

}

see if this helps

[seby]

i tried that. still, no errors, just no results.

[DigitalExpl0it]

add a mysql erro handle to your sql statements like

or die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");

[DigitalExpl0it]

example on a working script

<?
		$connect = mysql_connect($hostname, $user_name, $user_pass) or 
				die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
		$db = mysql_select_db($database, $connect) or 
				die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
		//First Query
		$sql = "SELECT * FROM snipplets WHERE PID LIKE '".$_REQUEST["snip"]."'";
		$sql_result = mysql_query($sql, $connect) or 
				die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
		//Second Query
		$sql_comment = "SELECT * FROM comment WHERE CSection LIKE '".$_REQUEST["snip"]."'";
		$sql_result_comment = mysql_query($sql_comment, $connect) or 
				die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");

//Get Data for first Query
while ($row = mysql_fetch_array($sql_result)){
	$Title = $row["PTitle"];
}

//Get Data for Second Query
while ($row_comment = mysql_fetch_array($sql_result_comment)){
	$Comment = $row_comment["CTitle"];
}
?>

[seby]

the funny thing is when I execute the query via phpmyadmin it returns results just fine, yet in the script i get no results, and no error at the same time. The error handling didn't help.

any other way to formulate this query?

[DigitalExpl0it]

try chnaging the query string first

SELECT * FROM $tabe WHERE category = '$category' AND active = '1'

try that and see if you get anything