$active = 'active';
$query_view2 = "CREATE VIEW admin_bookings2 (name,mob,fixed,cstatus,email,bookingid,dateplaced,status,datep,dated,Locationp,Locationd,days,mostdaysrate,vat,off,total,cat,discount2) AS
SELECT $CustomersTable.name,$CustomersTable.mob,$CustomersTable.fixed,$CustomersTable.status,$CustomersTable.email,$BookingsTable.bookingid,$BookingsTable.dateplaced,$BookingsTable.status,$BookingsTable.datep,$BookingsTable.dated,$BookingsTable.Locationp,$BookingsTable.Locationd,$BookingsTable.days,$BookingsTable.mostdaysrate,$BookingsTable.vat,$BookingsTable.off,$BookingsTable.total,$BookingsTable.cat,$BookingsTable.discount2 
FROM $CustomersTable, $BookingsTable
WHERE $CustomersTable.email = $BookingsTable.email AND cstatus='active'"; //$CustomersTable.status = $active 
//  ----------
$result_view = @mysql_query($query_view2,$linkid);
$query = "SELECT * FROM admin_bookings2 WHERE dated>='$today' ORDER BY $orderby "; // dateplaced  dated  AND dated>='$today'";  email='$email6' AND status!='canceled'   // appear bookings  dated>=time() AND time()<='$dated'canceled
$result = @mysql_query($query,$linkid);
$count = @mysql_num_rows($result);
echo "  ( Your query returned " . $count . " items. )";
?>