Please help me
Posted: Thu Jan 17, 2008 5:32 am
Hello to All
I m new to PHP and Mysql, I have a problem plz help me.
my question is how to display rows from result resource in second loop, my script is like:
$_parent_id=$_GET['parent_id'];
if(!isset($_parent_id) OR $_parent_id==0){
$_parent_id=0;
}
$sql="SELECT * FROM menu WHERE parent_id=".$_parent_id;
$result=mysql_query($sql);
// this loop returns all rows
while($RS=mysql_fetch_array($result)){
echo "<a href=menu.php?parent_id=".$RS['id'].">".$RS['name']."</a> :: ";
}
// this loop does not return anything (same result resource as above)
while($ROW=mysql_fetch_array($result)){
echo "<a href=menu.php?parent_id=".$ROW1['id'].">".$ROW1['name']."</a> <br> ";
}
I m new to PHP and Mysql, I have a problem plz help me.
my question is how to display rows from result resource in second loop, my script is like:
$_parent_id=$_GET['parent_id'];
if(!isset($_parent_id) OR $_parent_id==0){
$_parent_id=0;
}
$sql="SELECT * FROM menu WHERE parent_id=".$_parent_id;
$result=mysql_query($sql);
// this loop returns all rows
while($RS=mysql_fetch_array($result)){
echo "<a href=menu.php?parent_id=".$RS['id'].">".$RS['name']."</a> :: ";
}
// this loop does not return anything (same result resource as above)
while($ROW=mysql_fetch_array($result)){
echo "<a href=menu.php?parent_id=".$ROW1['id'].">".$ROW1['name']."</a> <br> ";
}