Original code
Code: Select all
if (strlen(mysql_real_escape_string($_GET['lang'])) == 2){$lc = mysql_real_escape_string($_GET['lang']);};
$lar = array('empty');
$langselect = "SELECT * FROM lang ORDER BY lid";
$langf = mysql_query($langselect, $dbConn);
while ($lf = mysql_fetch_array($langf, MYSQL_ASSOC)) {
$lar[] = $lf[$lc];
}Code: Select all
if (strlen(mysql_real_escape_string($_GET['lang'])) == 2){$lc = mysql_real_escape_string($_GET['lang']);};
$lar = array('empty');while ($lf = mysql_fetch_array(mysql_query("SELECT * FROM lang ORDER BY lid", $dbConn), MYSQL_ASSOC)) {$lar[] = $lf[$lc];}