//
$query = "SELECT shoe_id, shoes_image, shoes FROM " . $DBPrefix . "shoes";
$params[] = array(':shoe_id', floor($time_passed), 'int');
$db->query($query, $params);
$TPL_shoe1_list = '<select name="shoe1">' . "\n";
while ($row = $db->fetch())
{
$selected = ($row['shoes'] == $shoe1) ? 'selected="true"' : '';
$TPL_shoe1_list .= "\t" . '<option value="' . $row['shoes'] . '" ' . $selected . '>' . $row['shoes'] . '</option>' . "\n";
}
$TPL_shoe1_list .= '</select>' . "\n";

shoe1 in the code is a table of its own, i want to add another table shoe_image, how do i go about it?
thanks