movieprodw
asked on
PHP, MySQL, check for record, if empty then
Hello,
I need to have it so that if there is no for propid then it shows:
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>' ;
if there is a record then it shows the below I tried to do:
if(($garage == ''))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>' ;
But it does not work
I need to have it so that if there is no for propid then it shows:
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>'
if there is a record then it shows the below I tried to do:
if(($garage == ''))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>'
But it does not work
<?php
$query = "SELECT * FROM properties WHERE propid = '$propid'";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
if(($garage == ''))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '1'))
print '<option></option><option selected value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '2'))
print '<option></option><option value="1">No Dedicated Parking</option><option selected value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '3'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option selected value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '4'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option selected value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '5'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option selected value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '6'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option selected value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '7'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option selected value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '8'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option selected value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '9'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option selected value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '10'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option selected value="10">Other</option>';
}
?>
what is "$garage"
ASKER
garage is one of the fields in the property table. I need it to check if a propid is posted if not then make it 'n' if it is then it works as usual.
Below is how I just fixed it but I want to make sure that its ok to do it.
Below is how I just fixed it but I want to make sure that its ok to do it.
<?php
if (empty($propid))
{
$propid2 = 'n';
}
if(($propid2 == 'n'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($propid == $propid))
$query = "SELECT * FROM properties WHERE propid = '$propid'";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
if(($garage == '1'))
print '<option></option><option selected value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '2'))
print '<option></option><option value="1">No Dedicated Parking</option><option selected value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '3'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option selected value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '4'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option selected value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '5'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option selected value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '6'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option selected value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '7'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option selected value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '8'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option selected value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '9'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option selected value="9">Four Car Garage</option><option value="10">Other</option>';
if(($garage == '10'))
print '<option></option><option value="1">No Dedicated Parking</option><option value="2">Street Parkng</option><option value="3">Assigned Parking Spot</option><option value="4">One Car Carport</option><option value="5">Two Car Carport</option><option value="6">One Car Garage</option><option value="7">Two Car Garage</option><option value="8">Three Car Garage</option><option value="9">Four Car Garage</option><option selected value="10">Other</option>';
}
?>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked great, thanks