PHP - Put Query On Row 2 For Excel While Looping

I am trying to loop through the array that I have created to check to see if any of the dates in the array match the date I am passing (which is todays date) and then asks the user to consider making another booking.

This is what I have so far but I am not sure how to finish it off:

Code: [Select]
$table_id = 'booking';
$query = "SELECT * FROM booking WHERE bookingDate = 'newDate'";
$result = mysql_query($query);

$loop = $end_Time - $start_Time;
echo $loop;

while($row = mysql_fetch_assoc($result)){
if ($startTime || $end_Time == 'booking.startTime'){
echo "choose another booking";
}{
echo "booking is ok";
}

Apologies if this should be in the mysql forum but hopefully this is the correct one.

I am trying to extract the sum of a column from my database for each financial year, at the moment I am doing each year as a separate recordset but I am certain there must be a more automated way!

The financial year is 1st April to 31st March each year and I need to create a variable which is a sum of each year, you'll see in my code below what I mean, any help gratefully appreciated as I am going to end up with decades of info in the db and am keen to get the code right now!

The relevant recordsets are 2,5,7.  db is readingID, date, reading

The code and page does work fine, it's just long winded!

Code: [Select]
<?php
mysql_select_db($database_wind, $wind);
$query_Recordset1 = "SELECT readingID, date_format(date,'%d/%m/%Y') as date, reading FROM solar ORDER BY readingID DESC LIMIT 5";
$Recordset1 = mysql_query($query_Recordset1, $wind) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

mysql_select_db($database_wind, $wind);
$query_Recordset2 = "SELECT SUM(reading) as year1total FROM `solar` WHERE date between '2010-04-01' and '2011-03-31'";
$Recordset2 = mysql_query($query_Recordset2, $wind) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);

mysql_select_db($database_wind, $wind);
$query_Recordset3 = "SELECT * FROM solar ORDER BY readingID DESC Limit 29";
$Recordset3 = mysql_query($query_Recordset3) or die(mysql_error());

mysql_select_db($database_wind, $wind);
$query_Recordset4 = "SELECT readingID, YEAR(date) as yeardate, MONTHNAME(date) as monthdate, SUM(reading) as sumreading FROM `solar` Group by yeardate, monthdate Order by readingID ASC";
$Recordset4 = mysql_query($query_Recordset4) or die(mysql_error());

mysql_select_db($database_wind, $wind);
$query_Recordset5 = "SELECT SUM(reading) as year2total FROM `solar` WHERE date between '2011-04-01' and '2012-03-31'";
$Recordset5 = mysql_query($query_Recordset5, $wind) or die(mysql_error());
$row_Recordset5 = mysql_fetch_assoc($Recordset5);
$totalRows_Recordset5 = mysql_num_rows($Recordset5);

mysql_select_db($database_wind, $wind);
$query_Recordset6 = "SELECT datediff( Max(date), Min(date)) as DateDiff, Sum(reading) as LatestReading, date_format(MAX(date),'%d/%m/%Y') as LatestDate FROM solar";
$Recordset6 = mysql_query($query_Recordset6, $wind) or die(mysql_error());
$row_Recordset6 = mysql_fetch_assoc($Recordset6);
$totalRows_Recordset6 = mysql_num_rows($Recordset6);

mysql_select_db($database_wind, $wind);
$query_Recordset7 = "SELECT SUM(reading) as year3total FROM `solar` WHERE date between '2012-04-01' and '2013-03-31'";
$Recordset7 = mysql_query($query_Recordset7, $wind) or die(mysql_error());
$row_Recordset7 = mysql_fetch_assoc($Recordset7);
$totalRows_Recordset7 = mysql_num_rows($Recordset7);

$average = (int)(($row_Recordset6['LatestReading'])/($row_Recordset6['DateDiff']));
 
$income1 = $row_Recordset2['year1total']*0.428;
$income2 = $income1 + $row_Recordset5['year2total']*0.464;
$income = $income2 + $row_Recordset7['year3total']*0.464;

$saving = $row_Recordset2['year1total']*0.0675;
$saving = $saving + $row_Recordset5['year2total']*0.0675;
$saving = $saving + $row_Recordset7['year3total']*0.0675;

?>

Sorry, I originally posted part of this in MYSQL Help, but I was advised to post it here. I'm hoping someone can help me out.

I have 2 tables. "categories" and "subcats" (sub categories). I used a JOIN query for both..

Code: [Select]
SELECT categories.*, subcats.* FROM categories JOIN subcats on (categories.cat_id = subcats.cat_id) ORDER BY cat_name
Then I used a while loop to echo all the categories from the "categories" table and their respective sub-categories from the "subcats" table.

$sql = "SELECT categories.*, subcats.* FROM categories JOIN subcats on (categories.cat_id = subcats.cat_id) ORDER BY cat_name";
$cats_result = $connection->query($sql) or die(mysqli_error($connection)); 

    while ($row = $cats_result->fetch_assoc()) { 
$cat_id = $row['cat_id'];
$cat_name = $row['cat_name'];
$subcat_name = $row['subcat_name'];

       //should output all categories once and nest their subcategories
echo "<strong>".$cat_name."</strong>"; 
echo "<br />";
echo $subcat_name; 
echo "<br />";

}

No MYSQL errors but unfortunately I get this output..

Technology
Computers

Technology
Gadgets

Technology
Robots

Health
Fitness

Health
Diet

What sort of code can use in the loop to echo categories just once instead of multiple times for each topic?

I need some help and hopefully will respond. I'm trying to put some information to the second row of the excel sheet once extracted. Can somebody help me with this script? I'm trying to move the address line to the second row. Thanks.