.....
<select name='category' value='<? echo $_POST['category'];?>' width="45">
<?
build_category_select($languages_id);
?>
</SELECT>
......
......
function build_category_select($languages_id) {
$sql_string = "SELECT c.categories_id, cdes.categories_name from categories c, categories_description cdes where c.categories_id = cdes.categories_id AND cdes.language_id='".$language_id. "'";
echo $sql_string;
$sql = my_db_query($sql_string);
echo $sql;
$output = "";
while ($cat = mysql_fetch_array($sql)) {
$output .= "<option value='" . $cat['categories_name'] . "' >" . $cat['categories_name'] . "</option>\n";
}
}
function my_db_query($query, $link = 'db_link') {
global $$link;
if (STORE_DB_TRANSACTIONS == 'true') {
error_log('QUERY ' . $query . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);
}
$result = mysql_query($query, $$link) or die('error...');
if (STORE_DB_TRANSACTIONS == 'true') {
$result_error = mysql_error();
error_log('RESULT ' . $result . ' ' . $result_error . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);
}
return $result;
}
.......