Return Query Results issue

[psymon25]

Hi I am shiny new to php and have a site that displays the uploaded images from registered companies in a featured company area. I would like to have the ability to click the images and have the posts that the companies have placed show ie: show all company A's posts .

 

I am really stuck with this and any info would be grateful? here is what i have been trying..

 

 

<?php
$a = mysql_query("SELECT * FROM tableA");
while($b = mysql_fetch_array($a))
  {

if(!empty($b[image]))
{
$rq = mysql_query("SELECT * FROM tableB WHERE 'Company'='$b[CompanyName]'"); //this query works..
	echo "<ul><li><a href=http://$myurl/file/results.php?Company=$b[CompanyName]><img src=http://$myurl/images/$b[image] width='90' height='50'></a></li></ul>";
}
else {
echo " ";
}
  }
?>

 

I hope all this makes sense... Thanks in advance.

[DarkWater]

Can you elaborate a bit as to what you're trying to do?

[psymon25]

Hi Darkwater

 

I run a free recruitment site  that i started to learn about php, this is becoming a reasonably popular site for UK jobs and has been running only  3 months, I have a featured recruiters area... the recruiters that have uploaded a logo have this shown in the area.

 

I can link the image to the companies site url but I would like to have it where the logo can be clicked and all the jobs posted by that recruiter are shown.

 

I can PM you if you would prefer with the sources I am using?