|
|
|
|
query("select * from tbl_maincategory where status=1 and parent_id=0");
while($reccategory=$obj->fetchNextObject($sqlcategory)){ ?>
|
slug; ?>
|
|
|
|
|
|
|
query("select * from stores where status=1 and in_stock=1");
while($rec=$obj->fetchNextObject($sql)){ ?>
|
storename); ?>
|
|
|
|
|
|
|
|
|
|
|
|
|
query("select * from stores where status=1 and in_stock=1");
while($rec=$obj->fetchNextObject($sql)){
$sqlcategory=$obj->query("select * from tbl_maincategory where status=1 and parent_id=0 and storeid like '%$rec->storeid%'");
while($reccategory=$obj->fetchNextObject($sqlcategory)){ ?>
| slug."/".str_replace(' ','-',$rec->storename); ?> |
query("select * from stores where status=1 and in_stock=1");
while($rec=$obj->fetchNextObject($sql)){
$sqlcategory=$obj->query("select * from tbl_maincategory where status=1 and parent_id=0 and storeid like '%$rec->storeid%'");
while($reccategory=$obj->fetchNextObject($sqlcategory)){
$sqlsubcategory=$obj->query("select * from tbl_maincategory where status=1 and parent_id='$reccategory->id'");
while($recsubcategory=$obj->fetchNextObject($sqlsubcategory)){ ?>
| slug."/".str_replace(' ','-',$rec->storename); ?> |
query("select * from tbl_product where status=1");
while($rec=$obj->fetchNextObject($sql)){ ?>
| product_name))."/".$rec->id; ?> |
query("select * from tbl_blog where status=1");
while($rec=$obj->fetchNextObject($sql)){ ?>
| id."/".str_replace(' ','-',$rec->title); ?> |
|
|
|
|
|
|
|
|
|
|