Hi all,
I would like to thank drew010 and LordShryku for their replies on my previous questions. They helped me solve those problems. Thanks!
Excuse me asking an other:
I would like to call a php page based upon a resultset of a query.
I use this PHP script on my webpage:
<?php
mysql_select_db($database_jlmdigital, $jlmdigital);
$query_Categorie = "SELECT Url.Categorie FROM Url GROUP BY Url.Categorie";
$Categorie = mysql_query($query_Categorie, $jlmdigital) or die(mysql_error());
$row_Categorie = mysql_fetch_assoc($Categorie);
$totalRows_Categorie = mysql_num_rows($Categorie);
?>
<?php do { ?>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ucfirst($row_Categorie['Categorie']); ?></font></td>
</tr>
<?php } while ($row_Categorie = mysql_fetch_assoc($Categorie)); ?>
<?php
mysql_free_result($Categorie);
?>
It displays:
Cars
Shoes
Bikes
Wheels
I would like to display the resultset as hyperlinks. The links need to contain:
Cars (http://www.example.com/script.php?param=Cars)
Shoes (http://www.example.com/script.php?param=Shoes)
Bikes (http://www.example.com/script.php?param=Bikes)
Wheels (http://www.example.com/script.php?param=Wheels)
Who can help?
Thanks in advance,
Jack
