What the code is supposed to be doing is reading the button Comp.If the value is COLT2 it carries
out the query and prints the result, this will then happen for all rooms using the
button Comp.
But when I go to run it I have a parse error come up on the first line of
code, and I am not sure why.
Should where I have put ("Comp") be putting the complete address as to where
to find button Comp or not, or is there something very obviously wrong with
the code.
myComp = request.form("Comp")
Select Case ucase(MyComp)
case "COLT2"
$result = mysql_query =("SELECT FROM Room WHERE RoomName ='COLT2'");
echo ($result,0,"RoomName");
case "CC01"
$result = mysql_query = "SELECT FROM Room WHERE RoomName ='CC01'";
echo ($result,0,"RoomName");
case "CC02"
$result -mysql_query = "SELECT FROM Room WHERE RoomName ='CC02'";
echo ($result,0,"RoomName");
case "CC03"
$result = mysql_query = "SELECT FROM Room WHERE RoomName ='CC03'";
echo ($result,0,"RoomName");
case "CC04"
$result = mysql_query = "SELECT * FROM Room WHERE RoomName ='CC04'";
echo ($result,0,"RoomName");
End Select
