please can someone help me (a newbie) with this, i need to show rows of dates with availability. also i would like a query where you can select a date and also select upto four weeks


$selectthedate = $_POST['selectdate'];
$selecttheweeks = $_POST['selectweeks'];

$query="SELECT * FROM table WHERE date ='". $_POST['selectdate'] . "' and availability = 'available'";


$result=mysql_query($query);
$sd=$selectdate;

if ( $sd == ($result['date']))
{
$date = $database->get_row(null);

echo "this date $date->is $availablility->book now!";
}
else
{
echo "Sorry. this date is fully booked.</br>";
}





--> database table has date and availability columns <--

many thanks in advance

well you pretty much have the right idea.

Heres what I would do:

$selectthedate = $_POST['selectdate'];
$selecttheweeks = $_POST['selectweeks'];

$query="SELECT * FROM table WHERE date ='". $_POST['selectdate'] . "' and availability = 'available'";


$result=mysql_query($query);
if(!$result){
echo("error with query.");
exit;
}

if(mysql_num_rows($result)==0){
echo("No bookings...");
exit;
}

$row=mysql_fetch_array($result);

echo($row['date']." is ".$row['available']." Book now!";


As for the date up to for weeks. I have done this before but I am not sure how you are using your dates. But the query would be somthing likehtis

$query="SELECT * FROM yourtable WHERE date>=".$date1." AND date<=".$date2;

Hope this helps.