<?php
require_once './includes/connection.php';
//$year=$_POST['year'];
$auction_id=$_POST['auction_id'];
// $winner=$_POST['winner'];
$i=0;
$data = array();
$vendor_id=array();
$ini_price=array();
$data[0][0]="Sr";
$n=1;
$result= mysql_query("select * from auction_members where
auction_id='".$auction_id."' order by vendor_id ASC ");
while($row= mysql_fetch_array($result))
{
$result1= mysql_query("select * from users where
user_id='".$row['vendor_id']."'");
$row1= mysql_fetch_array($result1);
$data[0][$n]=$row1['fullname'];
$vendor_id[$i]=$row['vendor_id'];
$ini_price[0][$n]=$row['initial_price'];
$i++;
$n++;
}
$time=array();
$j=1;
$result2= mysql_query("select auction_pro_id from
auction_process where auction_id='".$auction_id."' group by vendor_id");
$cnt=mysql_num_rows($result2);
while($row2= mysql_fetch_array($result2))
{
//$time[$j]=$row2['time'];
//$data[$j][0]=$row2['time'];
$data[$j][0]=$j;
for($f=0;$f<$cnt;$f++)
{
//$result3= mysql_query("select * from auction_process where
auction_id='".$auction_id."' and time='".$row2['time']."' and
vendor_id='".$vendor_id[$f]."'");
$result3= mysql_query("select * from auction_process where
auction_id='".$auction_id."' and vendor_id='".$vendor_id[$f]."' ");
$cnt2=mysql_num_rows($result3);
for($b=0;$b<$cnt2;$b++){
$row3=mysql_fetch_array($result3);
$data[$j][$b+1]=(int)$row3['vend_price'];
}
}
$j++;
}
echo json_encode($data,JSON_NUMERIC_CHECK);
//echo "Hi";
?>
--
You received this message because you are subscribed to the Google Groups
"Google Chart API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-chart-api.
For more options, visit https://groups.google.com/d/optout.
