Billedescript med java/mysql/php!

Jeg har en shop-database med mine produkter med url til mine billeder. Men hvordan kan man vælge nogle af de ønskede billeder frem f.eks. en bestemt varergruppe i nedenstående?

<?php
//connect to the database - either include a connection variable file
//or type the following lines:
$connect = mysql_connect("localhost", "brugernavn", "password")
  or die ("check your server connection.");
mysql_select_db ("shop");
$query = "SELECT * FROM products";
$results = mysql_query($query)
  or die(mysql_error());

?>

<script type="text/javascript">
var prods = ["98798","879879","987987","987786","987"], actProd = 0;

function skiftDu(bil){
  document.images['mitBillede'].src=bil;
  actProd = prods[bil.replace(/^.*?(\d+)\.jpg$/,"$1")];
}

function putInBasket(){
  location.href = "http://www.minSide.dk/putInBasket.asp?prodId=" + actProd;
}

</script>

<td width="510" valign="bottom" align="left"><img name="mitBillede" src="images/startbillede.jpg" onclick="putInBasket();" onmouseover="this.title='Varenummer: '+actProd;" style="cursor:pointer;" title="Vare"></td>