loop within a loop

[tsm1248]

Is it possible to have a loop run in a loop ?

[kenrbnsn]

Yes. Are you having a problem?

[tsm1248]

Yes i connect and do the normal routine and i echo out all the rows that have a $row->type==tickets

the issue is can i now call from a different table a loop os users into that table?

 

So another question arrises can i loop from another table within a loop

[kenrbnsn]

If you're having problems with your code, please post the relevant pieces between

tags.

 

Ken

[tsm1248]

Scroll all the way to the bottom!

 

<?php
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());
$query = "SELECT * FROM tickets";
$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result))
{

can i have another loop here from a different table				

}
?>

[tsm1248]

Sry had to shorten the code..sry it took a little long

[johnsmith153]

You can, but ensure you don't use $result as the variable.

 

This should be ok:

<?php
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());

$query = "SELECT * FROM tickets";
$result = mysql_query($query) or die(mysql_error());

$query = "SELECT * FROM more_tickets";
$result2 = mysql_query($query) or die(mysql_error());



while($row = mysql_fetch_array($result))
{

    while($row = mysql_fetch_array($result2))
    {


    }	

}
?>

[johnsmith153]

Actually, do this also:

 

while($row = mysql_fetch_array($result))
{
   
    while($row2 = mysql_fetch_array($result2))
    {

[Jerred121]

You can, but ensure you don't use $result as the variable.

 

This should be ok:

<?php
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());

$query = "SELECT * FROM tickets";
$result = mysql_query($query) or die(mysql_error());

$query = "SELECT * FROM more_tickets";
$result2 = mysql_query($query) or die(mysql_error());



while($row = mysql_fetch_array($result))
{

    while($row = mysql_fetch_array($result2))
    {


    }	

}
?>

Unless you want the inner loop to increment the same table as the first loop - i've hade to need to do this a couple of times - it starts getting really confusing when there are about 5-6 embedded loops all incrementing the same thing...

[tsm1248]

Thanks guys that worked fantastically can i have a forum within a forum and have the button within the html forum tag send to a different php page

 

<forum>

<forum>

both forums go to dif pages

</forum>

</forum>

[kenrbnsn]

There is no such HTML tag "<forum>". Do mean "<form>"?

 

No, you can not have nested <form> tags.

 

Ken

[tsm1248]

Wow just figured it out just placed an if statement on one page for both of them..thanks for all your help guys great community and great people

[tsm1248]

OK so the first time loop outputs the first line both loops work then after that only the first loop works?