How to replace a database rendered repeat region menu with button graphics

maxwell_

I have a web page that echos out words from a database as a repeat region.
The words automatically become hyperlinks to other pages.
There are currently three in total.

The target pages then display records from another database table occording the the class_id

Example url

/softwarelist.php?class_id=777

The words echoing onto the page as text look very plain.
Is it possible to replace the database words with button graphics.

This is the php code

recordset

$query_rs_level = "SELECT key_id, `keyword` FROM `keywords_lit` ORDER BY `keyword` ASC";
$rs_level = mysql_query($query_rs_level, $abe) or die(mysql_error());
$row_rs_level = mysql_fetch_assoc($rs_level);
$totalRows_rs_level = mysql_num_rows($rs_level);

repeat region

<?php do { ?>
    <a href="softwarelist.php?class_id=<?php echo $row_rs_class['class_id']; ?>"><?php echo $row_rs_class['classtitle']; ?></a>&nbsp;

<?php } while ($row_rs_class = mysql_fetch_assoc($rs_class)); ?>

Weedpacket

Yes, it is possible. What is the problem you're having?

maxwell_

Can you give me some information or point me to a tutorial on how to do this?

Appologies the previous post has the wrong recordset.

Recordset

mysql_select_db($database_abe, $abe);
$query_rs_class = "SELECT class_id, classtitle FROM `class` ORDER BY classtitle ASC";
$rs_class = mysql_query($query_rs_class, $abe) or die(mysql_error());
$row_rs_class = mysql_fetch_assoc($rs_class);
$totalRows_rs_class = mysql_num_rows($rs_class);

Bunkermaster

Easiest way would be to create a default CSS class for your buttons with a placeholder and slap a class named after your sanitized keyword (removing accents, etc) and define the CSS classes you need to display the right graphics.
CSS

.default-icon{
background-image: url( placeholder.png);
}
.keyword12{
background-image: url( keyword12.png);
}

PHP

<div class="default-icon <?php echo stripslashes($row_rs_level['keyword'])?>"></div>

Output

<div class="default-icon keyword12"></div>

maxwell_

Thanks for that I will give it a try.

Best regards Maxwell