I'm not so good in .htaccess, so I don't know how to it work, I have a site and my site link like that: mysite.com/pagee.php?menu_id=1 I use this .htaccess code:
<IfModule mod_rewrite.c>
RewriteEngine on
# 1-level
RewriteRule ^home/{0,1}$ pagee.php?menu_id=1 [QSA,L]
</IfModule>
and it work like that: mysite.com/home/
But my problem is I have lot of page like:
mysite.com/pagee.php?menu_id=2, mysite.com/pagee.php?menu_id=3, mysite.com/pagee.php?menu_id=4, mysite.com/pagee.php?menu_id=5, mysite.com/pagee.php?menu_id=6,
and my pagee.php code is:
<?php
require_once('config2.php');
$menu_id = intval($_GET['menu_id']);
$query = "SELECT * FROM menu WHERE `menu_id`=$menu_id";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
{
echo '<h1>'.$row['mname'].'</h1>';
}
?>
pagee.php work with mysql
so how to while code work inside the .htaccess
like that:
<IfModule mod_rewrite.c>
RewriteEngine on
# 1-level
<?php
$query = "SELECT * FROM menu WHERE `menu_id`=$menu_id";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
{
$menu_id=$row['menu_id'];
$linkname=$row['linkname'];
echo 'RewriteRule ^'.$linkname.'/{0,1}$ pagee.php?menu_id='$menu_id' [QSA,L]';
} ?>
</IfModule>