- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
<?php
$lquery = mysql_query("SELECT * FROM language_settings ORDER BY language_id");
$llquery = mysql_query("SELECT * FROM language_settings ORDER BY language_id");
?>
<?php while($ldata = mysql_fetch_array($lquery)){ ?>
<a><?=$ldata['language_name'];?></a>
<?php } ?>
<?php while($lldata = mysql_fetch_array($llquery)){ // Language Loop
$lang_prefix = $lldata['language_prefix'];
language($lang_prefix);
$lang = strtolower($lldata['language_prefix']);
?>
....
<?php
$_lid = $lldata['language_id'];
$_nid = $_REQUEST['nid'];
if($_nid!=""){
// newsid=$_nid AND
$qry = "SELECT *
FROM tbl_products as pc JOIN tbl_products_content as pcc ON pc.product_id=pcc.product_id
WHERE pcc.lang_prefix='".strtolower($lldata['language_prefix'])."' AND pc.product_id='{$_nid}' ORDER BY product_order,product_cat_id";
$cquery = mysql_query($qry);
$cdata = @mysql_fetch_array($cquery);
}
...
}?>
Follow us!