This is what i'm getting
and only "38" is outputting....HmmmmHotelRoomID: array(2) {
[0]=>
string(2) "24"
[1]=>
string(2) "38"
}
Moderator: General Moderators
No, i only get those errors when i edit the URL, apart from that i dont get the errorsvolka wrote:Did you change anything else?
When i do edit the url I for the first array(string(2) "24") i dont get any errors:http://pb-sql/roomhold.php?datefrom=19% ... D%5B%5D=24[/b]&datefrom=19%2F06%2F2007&dateto=25%2F06%2F2007&datefrom=19%2F06%2F2007&dateto=25%2F06%2F2007&datefrom=19%2F06%2F2007&dateto=25%2F06%2F2007&datefrom=19%2F06%2F2007&dateto=25%2F06%2F2007&datefrom=19%2F06%2F2007&dateto=25%2F06%2F2007&datefrom=19%2F06%2F2007&dateto=25%2F06%2F2007&datefrom=19%2F06%2F2007&dateto=25%2F06%2F2007&datefrom=19%2F06%2F2007&dateto=25%2F06%2F2007&datefrom=19%2F06%2F2007&dateto=25%2F06%2F2007&HotelRoomID%5B%5D=38
When i edit it for the second array output(string(2) "38", i get this error output,http://pb-sql/roomhold.php?datefrom=19% ... lRoomID=24[/b]&datefrom=19%2F06%2F2007&dateto=25%2F06%2F2007&datefrom=19%2F06%2F2007&dateto=25%2F06%2F2007&datefrom=19%2F06%2F2007&dateto=25%2F06%2F2007&datefrom=19%2F06%2F2007&dateto=25
HotelRoomID: string(2) "38"
Warning: Invalid argument supplied for foreach() in C:\Inetpub\wwwroot\salessys\roomhold.php on line 22
Notice: Undefined variable: count in C: line 42
Code: Select all
$reso=mssql_query($query);
$count=mssql_num_rows($result);
echo '<div>Debug: $count=', $count, "</div>\n";
}}
?>
<form method=get name=f1 action='confirmmholdroom.php'>
<?php
$i=0;
echo "<div>Debug: while ($i < $count) { </div>\n";
while ($i < $count) {
$rows=mssql_fetch_array($result);Code: Select all
$dateto = $_GET['dateto'];
if(isset($_GET['HotelRoomID']))
{
foreach($_GET['HotelRoomID'] as $k=>$k1)
{
echo "<fieldset><legend> foreach($k => $k1) </legend>\n";
$sql="SELECT * FROM HotelRooms WHERE HotelRoomID=$k1";
$ques="SELECT dbo.Hotels.HotelName FROM Hotels INNER JOIN HotelRooms ON dbo.Hotels.HotelID = dbo.HotelRooms.HotelID WHERE HotelRoomID=$k1";
$query="SELECT dbo.RoomAssociations.RoomAssociation FROM RoomAssociations INNER JOIN HotelRooms ON dbo.RoomAssociations.RoomAssociationID = dbo.HotelRooms.RoomAssociationID WHERE HotelRoomID=$k1";
echo "mssql_query($sql) <br />\n
mssql_query($ques) <br />\n
mssql_query($query) <br />\n";
$result=mssql_query($sql);
$res=mssql_query($ques);
$reso=mssql_query($query);
$count=mssql_num_rows($result);
echo 'count=', $count;
echo '</fieldset>';
}
}
?>
<form method=get name=f1 action='confirmmholdroom.php'>
<?php
$i=0;
while ($i < $count) {
echo "while ($i < $count)\n";
$rows=mssql_fetch_array($result);
foreach(0 => 46) mssql_query(SELECT * FROM HotelRooms WHERE HotelRoomID=46)
mssql_query(SELECT dbo.Hotels.HotelName FROM Hotels INNER JOIN HotelRooms ON dbo.Hotels.HotelID = dbo.HotelRooms.HotelID WHERE HotelRoomID=46)
mssql_query(SELECT dbo.RoomAssociations.RoomAssociation FROM RoomAssociations INNER JOIN HotelRooms ON dbo.RoomAssociations.RoomAssociationID = dbo.HotelRooms.RoomAssociationID WHERE HotelRoomID=46)
count=1
foreach(1 => 47) mssql_query(SELECT * FROM HotelRooms WHERE HotelRoomID=47)
mssql_query(SELECT dbo.Hotels.HotelName FROM Hotels INNER JOIN HotelRooms ON dbo.Hotels.HotelID = dbo.HotelRooms.HotelID WHERE HotelRoomID=47)
mssql_query(SELECT dbo.RoomAssociations.RoomAssociation FROM RoomAssociations INNER JOIN HotelRooms ON dbo.RoomAssociations.RoomAssociationID = dbo.HotelRooms.RoomAssociationID WHERE HotelRoomID=47)
count=1
while (0 < 1)