query problems

[brauchi]

Finally, I was able to process two variables into another page -- thanks to this message board.

I think I might have to tell you want I plan to accomplish in this scribt.

I will have a database that will have associated advertisement categories asociated with the article. I passed the ID variable (id_new) into the follow up page and would like to create an array for all the ads that would fall into the same category and display the ads.

Here is the code I wrote -- but I guess it is wrong.

$ads = @("select adcategory, id from articles where id = id_new");

if (!$ads)
{
echo("<p>Error retrieving ad categories from database!"."</p>");
exit();
}
while ($ad = mysql_fetch_array($ads))
{
$id = $articles["id"];
$adcategory = htmlspecialchars($jarticles["id"]);
echo($adcategory);

}

Thank you in advance

andrea

[majik-sheff]

Give this a try:

$ads = @mysql_query("select adcategory, id from articles where id = '$id_new'") /* you left the $ off of your variable.  It's also a VERY GOOD IDEA to enclose any inserted value in single quotes */
	or die("<p>Error retrieving ad categories from database!"."</p>"); // This replaces your flawed if-then set

while ($ad = mysql_fetch_assoc($ads)) {  //use mysql_fetch_assoc() to conserve memory
	$id = $ad['id'];  //$ad now contains an associative array, use it
	$adcategory = htmlspecialchars($ad['adcategory']); //more of the same
	echo($adcategory);
}