Newbiee

Anon

Hai,
i have a question..
if i have 2 table like this
Table1
| id | name | id_group |
| 1 | Hasan | 1 |
| 2 | Amin | 1 |
| 3 | Azlan | 1 |
| 4 | Nurul | 2 |
| 5 | Linda | 2 |

how i want this data to display using array
to be like this

Result :->

1 Software | Hassan,Amin,Azlan |
2 Designer | Nurul,Linda |

in this also must consider if we want to delete one name from the result how we want to do that...

Anon

I am not sure if this is what you are looking for but this will list the results one at a time.

select a.name from table1 a, table2 b where a.id_group = b.id_group

which would produce:

Hasan

Amin

Azlan

Nurul

and then you could put the results in a array

$results = mysql_query("select a.name from table1 a, table2 b where a.id_group = b.id_group");
$info = mysql_fetch_array($results);

Anon

yes i know how to do like this but the problem is when i want to delete only one name in the result like example

1Software | Hassan,Amin,Azlan

how i want to delete only one name

stephanie

//will output
// 1 Software | Hassan,Amin,Azlan |
// 2 Designer | Nurul,Linda |
//etc...

mysql_connect($hostname, $username, $password);

$result_group = mysql_query("SELECT * FROM Table2 order by id_group");
$nb_of_group = mysql_numrows($result_group);

//for each group

for ($i=0; $i<$nb_of_group; $i++){

//print group name
$id_group = mysql_result($result_group,$i,"id_group");
$group_name = mysql_result($result_group,$i,"group_name");
print "<br>$id_group $group_name | ";

$result_people =  mysql_query("select * from Table1 where id_group='$id_group' ");  
$nb_of_people = mysql_numrows($result_people);

// print people for the group
for ($j=0;$j<$nb_of_people; $j++){
	$name = mysql_result($result_people,$j,"name");
	print "$name";
	if ( $j < $nb_of_people - 1) print ","; //print comma separator except for last name
}

print " | ";//end of array

}

?>

Anon

how about if i want to delete one name in the table

stephanie

sql ex to delete Hasan:

delete from Table1 where id=1;

php ex:

mysql_db_query( "$database_name", "delete from Table1 where id='$id'");
//this would delete 1 row from Table1

Table1
| id | name | id_group |
| 1 | Hasan | 1 |
| 2 | Amin | 1 |
| 3 | Azlan | 1 |
| 4 | Nurul | 2 |
| 5 | Linda | 2 |