Citire unui sir de numere dintr-o tupla

Salutare, avem tabela in baza dedate numita cldgroup in care este un string de genul 1,2,3,4. iar in
Cum se pt afisa individual fiecare element din sir? Eu am facut urmatoarea chestie dar afisaza doar 1 fiindca eu am pus condita sa existe query atunci sa fiseze dar e doar 1 query.

$query = mysql_query("SELECT cldgroup from user WHERE u.uuid='$uuid'");
		 while($dnn=mysql_fetch_array($query)){
echo htmlentities($dnn['cldgroup']);

Si mai stiu varianta asta

SELECT SUBSTR(cldgroup, 1,INSTR(cldgroup, ",")-1) as ic1,
			  SUBSTR(cldgroup, INSTR(cldgroup,",")+1, LENGTH(cldgroup)) as ic2
			  FROM user where uuid='$uuid'

dar problema e ca numarul de elemente din sir nu e fix si in plus de asta daca afisez folosind

echo htmlentities($dnn['ic1']);

Nu afiseaza nimic dar interogarea in sql console merge

Edited by BIT2GB, 21 February 2017 - 23:22.

SELECT SUBSTR(cldgroup, 1,INSTR(cldgroup, ",")-1) as ic1,

in php exista o functie numita explode

am reusit deja atata doar ca am facut mai "babeste" dar e ok, aveti codul mai jos:

$query = mysql_query("SELECT cldgroup,grpid from user WHERE uuid='$uuid'");
		  $dnn=mysql_fetch_array($query) ;
		 
		  $cldg = explode(",", $dnn['cldgroup']);
		  $grpid = explode(",", $dnn['grpid']);
		  if($cldg[0]!==NULL){
		  echo'<div>Grades Assigned on Server: <img src="../icons/'.$cldg[0].'.png" alt="groupicon" title="">';
		  }
		  if($cldg[1]!==NULL){
		  echo'<img src="../icons/'.$cldg[1].'.png" alt="groupicon" title="">';
		  }
		  if($cldg[2]!==NULL){
		  echo'<img src="../icons/'.$cldg[2].'.png" alt="groupicon" title="">';
		  }
		  if($cldg[3]!==NULL){
		  echo'<img src="../icons/'.$cldg[3].'.png" alt="groupicon" title="">';
		  }
		  if($grpid[0]!==NULL && $grpid[0]!=0 ){
		  echo'<br>Grades Assigned By Tracker: <img src="../icons/'.$grpid[0].'.png" alt="groupicon" title="">';
		  }

ce ai facut tu nu este "babeste", ci "hardcodare" (o chestie pe care ar trebui sa o eviti)
ti-as recomanda sa salvezi datele din acea coloana ca XML-uri.

am facut asta si da arata mai "frumos" ca sa folosesc un cuvant simplu dar cuprinzator

Edited by BIT2GB, 27 February 2017 - 11:45.