I'm a newbie to MySql/PHP so please be gentle!!
I'm writing a web reservation system for a small hotel and the
following sql query works perfectly locally on my machine using MySql5
& PHP5, but not on messrs Fasthosts server with PHP4.xx and MySql4.xx
(The connection to the DB seems to be working correctly).
On the server it throws up an error saying "Unknown column
'Av.AvailDate' in 'where clause'"
$sql = "SELECT Distinct RoomTypeID,
RoomName,RoomDesc,RoomTerms,RoomConfig,RoomPhoto FROM roomtypes RT
Inner Join availability AV ON RT.RoomTypeID = Av.AvailRoomID Where
(Av.AvailDate between'".$ArrDate."' and '" .$DelOcc."') AND NOT EXISTS
(Select Distinct NoAv.AvailRoomID FROM availability ...