Please help, problem in looping query, how to change variable name

Hello,

I have some problem with my php script. it's only basic script but i dont know how to make it fix.

I have a query to get a group id from table group, which is it will be shown in a html table, which can be selected & deleted by visitor.

But, i only allow to be deleted for a group which is not used by a member

this is the script

$src_get_group		= "select * from group";
$query_get_group	= mysql_query($src_get_group) or die (mysql_error());

for ($i = 1; $row_get_group = mysql_fetch_array($query_get_group) ; $i++)
{
	$group_ext	= $row_get_group["group_code"]; 
    $group_ext_enc	= mysql_real_escape_string($group_ext);
    
    $src_member_group	= "select * from member where group = '$group_ext_enc'";
	//==trouble here==
    $query_member_group	= mysql_query($src_member_group) or die (mysql_error());
	//================
	$num_member_group	= mysql_num_rows($query_member_group);
	
	if($num_member_group == "0")
	{
		echo "<INPUT type=\"button\" value=\"delete group".$row_get_group["group_code"]."/".$row_get_group["group_name"]."\" onClick=\"document.location.href='delete_group.php?id=".$row_get_group["id"]."';\" id=\"tombol_kembali\">";
	}
	else
	{
		echo "group ".$row_get_group["group_code"]."/".$row_get_group["group_name"]." cannot be deleted, used by member";
	}
}

PHP:

my problem is how to change automatically $query_member_group to be
$query_member_group_1
$query_member_group_2
$query_member_group_3
$query_member_group_n

also
$num_member_group_1
$num_member_group_2
$num_member_group_3
$num_member_group_n

Because it seem, it wont be worked if those variable names not changed like specified above..

Please give a solution with a right script that i have to use or my script is already right...

Best Regards

 

Hi,

Maybe you have troubles because group is reserved word.
Regards

 

Add the current loop number to the variable example:

 

Hi koko5, that's not my really problem. it's ok with that name, i already use it in my other queries, thanks for your answer.

Hi Mehdi, i'm not sure that the way you show me is a right rule in PHP... thanks for the answer.

my friend told me that i have to use array, could someone show me how to do that.....?

regards

 

maybe koko right about the group table is not OK, so i change the table to be like this, group => dept

$src_get_dept    = "select * from dept";
$query_get_dept    = mysql_query($src_get_dept) or die (mysql_error());

for ($i = 1; $row_get_dept = mysql_fetch_array($query_get_dept) ; $i++)
{
    $dept_ext  = $row_get_dept["dept_code"];
    $dept_ext_enc  = mysql_real_escape_string($dept_ext);
   
    $src_member_dept   = "select * from member where dept = '$dept_ext_enc'";
    //==trouble here==
    $query_member_dept = mysql_query($src_member_dept) or die (mysql_error());
    //================
    $num_member_dept   = mysql_num_rows($query_member_dept);
   
    if($num_member_dept == "0")
    {
        echo "<INPUT type=\"button\" value=\"delete dept".$row_get_dept["dept_code"]."/".$row_get_dept["dept_name"]."\" onClick=\"document.location.href='delete_dept.php?id=".$row_get_dept["id"]."';\" id=\"tombol_kembali\">";
    }
    else
    {
        echo "dept ".$row_get_dept["dept_code"]."/".$row_get_dept["dept_name"]." cannot be deleted, used by member";
    }
}

PHP:

please how to solve my problem, the point is how can i get the value from each query in that looping

Regards

 

Hello, junandya ,

SQL is not procedural language, so all you need is to do query like this / can't get your point exactly without table structure, but you'll modify it / :

SELECT group_name,group_code FROM dept GROUP BY group_name,group_code;

Code (markup):

Regards

 

thank's for your answer, but that is not the point. what i want to do is:
1. i want to get all of the value of the group/dept by the first query.
2. inside the looping, i have to check with another query, if that group/dept is being used by a member, so that's why i have to make another query inside it.

Please anyone here give me a right code to do that.....

best Regards