server_processing.php HELP

server_processing.php HELP

naftalin3naftalin3 Posts: 5Questions: 0Answers: 0
edited December 2010 in General
Hello All,

I need help but it's really hard for me to explain what I need.
I will try :)

First i want say that server_processing working for me very well :), but i want to assign another database query for each (tr) record of the first query;
I can query perfectly the second query with the id of the first query but i don't find a way how to output this in the table!
JUST AN EXAMPLE:
normally datatables working like this:

$aColumns = array('A','B','C' );



A 1
B 1
C 1


A 2
B 2
C 2


A 3
B 3
C 3



AND I NEED:




A 1
B 1
C 1


// this is new

g 1
f 1
e 1



g 2
f 2
e 2

// this is end of new


A 2
B 2
C 2



A 3
B 3
C 3





$aColumns = array('id','data_completa', 'rag_soc', 'email', 'cell' );


while ( $aRow = mysql_fetch_array( $rResult ) )
{

$a = "";
$id_cliente = $aRow['id'];
$sql2 = "SELECT * FROM tbl_richieste WHERE id_cliente = '$id_cliente'";
$query2 = @mysql_query($sql2);
$mynrows2 = mysql_num_rows($query2);
while ($ok2 = mysql_fetch_array($query2)) {
$id_articolo = $ok2['id_articolo'];
$quantita = $ok2['quantita'];
$a = $a . $quantita; // Array
}


$row = array();

for ( $i=0 ; $i
This discussion has been closed.