Loops

[KrisCons]

Hi all,

I have a page which selects data from a database using $groupid and $personid as unique values to identify the record i need.

I now need to build thi spage so that it works in a loop for every $personid within the $groupid that is sent to the page.

My current code is something like this:

$personid = $GET['pid'];
$groupid= $GET['gid'];

$sqlquery = "Select my data where groupid = $groupid and personid = $personid";

echo the details of this record to the screen;

mysql_free_result;

I now need to pass ALL personid's ($_GET['pid']😉 to the page and then loop through my page for each one.

Can someone advise?

Thanks.
Newbie.

[harmor]

To get the personid and groupid you'll need to pass them through the URL using yoursite.com/your_script.php?pid=30&gid=4

What this is doing it getting ($_GET) the pid value (which is 30) and the gid (which is 4)

In "your_script.php" (can be anything you want) you run a query to retrieve data where those values are.

Code in "your_script.php"

$personid = $_GET['pid'];
$groupid= $_GET['gid']; 

$sqlquery = mysql_query("SELECT * FROM table_name WHERE groupid='$groupid' &&  personid='$personid' ")or die(mysql_error());
   while($row = mysql_fetch_array($sqlquery))
{
   //echo data here.
}

The query will get the pid (personid) and gid (groupid) and display the results for only where those match.

[KrisCons]

Hi harmor,

Apologies as I mustn't have made myself clear. I am actually already doing that, but instead of running th page for one $personid which i am doing now, I need to send an array (e.g. $personids[]) which contains ALL of the $personid's assigned to the $groupid in the database and run my page for each element in the array.

essentially, my page will display a different set of results for each $personid, whereas at the moment, my page only runs once for the one single $personid that it is passed.

Any ideas?

[harmor]

Try deleting this line in the query
&& personid='$personid'

Now just change your URL to
yoursite.com/your_script.php?gid=4

Now it'll get every personid where gid is "4"