//
$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

skyhighweb:
//
$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

What you should add is another column and not another table.

This isn't where to easily assist you. Get in touch with me let me see more parts of the code and how they interconnect.
Hope you can easily take and understand instructions when guided.

bassdow:


What you should add is another column and not another table.

This isn't where to easily assist you. Get in touch with me let me see more parts of the code and how they interconnect.
Hope you can easily take and understand instructions when guided.

sorry i meant another column my mistake, yeah assist as u can thanks i follow info