Passing data to an array

Original - php Code $sql="SELECT count(*) as 'number' FROM ttable, tnotes as ant WHERE datename(mm, dtindate) = datename(mm, ant.dtDatum) and datepart (yy, dtindatem) = $ar and ttable.iId = ant.iID and ant.chcomment like 'This is great' group by datepart(mm, dtindate) order by 'Number'"; $result = odbc_exec($conn_id,$sql); while($a=odbc_fetch_array($result)) { //print("Comment: " . $a["antal"] . "Month:" . $a["Number"] . "<br>n"); array_push ($ydata, $a['Number']); } odbc_fetch_array($result,$row); echo " Number is $row"; echo $row['Number']."bla bla"; odbc_close($conn_id); } include ("jpgraph.php"); include ("jpgraph_line.php"); $ydata = $a;

 
$sql="SELECT count(*) as 'number'
FROM ttable, tnotes as ant
WHERE datename(mm, dtindate) = datename(mm, ant.dtDatum)
      and datepart (yy, dtindatem) = $ar
      and ttable.iId = ant.iID
      and ant.chcomment like 'This is great'
group by datepart(mm, dtindate)
order by 'Number'";
$result = odbc_exec($conn_id,$sql);
while($a=odbc_fetch_array($result)) {
  //print("Comment: " . $a["antal"] . "Month:" . $a["Number"] . "<br>n");
array_push ($ydata, $a['Number']);
}
 
 
odbc_fetch_array($result,$row);
echo " Number is $row";
echo $row['Number']."bla bla";
 
odbc_close($conn_id);
}
include ("jpgraph.php");
include ("jpgraph_line.php");
$ydata = $a; 

Original - php Code $sql="SELECT count(*) as 'antal',datepart(mm,dtinlagddatum) as 'Nummer' FROM tPlatsannons, tPlatsannonsDaganteckning as ant WHERE datename(mm, dtInlagddatum) = datename(mm, ant.dtDatum) and datepart (yy, dtinlagddatum) = $ar and tPlatsannons.iPlatsannonsid = ant.iPlatsannonsID and ant.chKommentar like 'Granskning pågår' group by datepart(mm, dtinlagddatum) order by 'Nummer'"; $result = odbc_exec($conn_id,$sql); if ($myrow=odbc_fetch_array($result)) { do { $datay[] = $myrow["antal"]; }while ($myrow=odbc_fetch_array($result)); } echo $datay;

 
$sql="SELECT count(*) as 'antal',datepart(mm,dtinlagddatum) as
'Nummer'
FROM tPlatsannons, tPlatsannonsDaganteckning as ant
WHERE datename(mm, dtInlagddatum) = datename(mm, ant.dtDatum)
      and datepart (yy, dtinlagddatum) = $ar
      and tPlatsannons.iPlatsannonsid = ant.iPlatsannonsID
      and ant.chKommentar like 'Granskning pågår'
group by datepart(mm, dtinlagddatum)
order by 'Nummer'";
$result = odbc_exec($conn_id,$sql);
if ($myrow=odbc_fetch_array($result)) 
{ do 
{ 
$datay[] = $myrow["antal"]; 
 
}while 
($myrow=odbc_fetch_array($result)); } 
echo  $datay;