server_processing.php HELP
server_processing.php HELP
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
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.