0

Am having a hard time printing all record percent in my db

my sql statement

$query="SELECT *, duedate,(TO_DAYS(duedate) - TO_DAYS(CurDate())) as difference FROM vehicle_info ORDER by svreg";
				
//$query="SELECT * FROM vehicle_info WHERE id='$id' ORDER by vreg";
	$pager = new PS_Pagination($conn,$query,10,10);
	$accra = $pager->paginate();
	while($row = mysql_fetch_assoc($accra)) 
	{
	$id = $row['id'];
	$ymodel = $row['ymodel'];
	$make = $row['make'];
	$chassis = $row['chassis'];
	$color = $row['color'];
	$driver = $row['driver'];
	$svreg = $row['svreg'];
	$engine = $row['engine'];
	$trans = $row['trans'];
	$tsize = $row['tsize'];
	$fleet_no = $row['fleet_no'];
	$axles = $row['axles'];
	$company = $row['company'];
	$account = $row['account'];
	$premium = $row['premium'];
	$duedate = $row['duedate'];
	$dvla_date = $row['dvla_date'];
	$intax_date = $row['intax_date'];
	$cur_date = $row['cur_date'];
	$numDays = $row['difference'];
								}

I want to select all archives in

vehicle_info

and print all at once.

Edited by accra: n/a

2
Contributors
1
Reply
2
Views
5 Years
Discussion Span
Last Post by pritaeas
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.