Hi everyone, I have been trying to write a php script to display a div and its contents depening on a result from mysql.
Inside the div is a basic input form etc, nothing special, some error & validation checking.
What I would like to do is, to only display the div and contents if a result from my database was true.
$res = mysql_query("SELECT var, var1 FROM tbl_name WHERE var='$var' && var1='0'") or die(mysql_error());
$checkvar = mysql_num_rows($res);
if($checkvar > 0){
$row = mysql_fetch_array($res);
$var = $row['var'];
if ($var1 == 0)
{ //if result is false
// do not display the div and contents
}
else
{
//if the result = 1 display the div and contents here
}
}
Here is the complete form. Inside the form there are php tags so I am not sure how to get around this
<!-- Begin #optIn -->
<div id="optIn">
<div class="optBox">
<h3><?php if($headline){echo $headline; }?></h3>
<p><?php if($dealdetails){echo $dealdetails; }?></p>
<form style="width:100%;" action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>" method="post">
<label class="previewLabel" for="awf_field"></label>
<select name="country" tabindex="1" class="select" value='<?php echo $country; ?>' id="country" onChange="get_country_code();">
<?php if($country!=''){?>
<option value="<?php echo $country;?>"><?php echo $country;?></option>
<?php }else{ ?>
<option value="">Please Select Country</option>
<?php }?>
<?php
while($country_arr = mysql_fetch_array($result_country)){
$tag_selected = ( (isset($_POST['country']) and $_POST['country'] == $country_arr['Country'] )? 'selected="selected"' : '' );
?>
<option value="<?php echo $country_arr['Country']?>" <?php echo $tag_selected; ?>><?php echo $country_arr['Country']?></option>
<?php
}
?>
</select>
<input type="text" class="text" id="smsmobnum" maxlength="11" size="11" name="smsmobnum" title="Enter your full mobile number" value="<? echo $smsmobnum; ?>" tabindex="2">
<input type="submit" name="submit" class="submit btn" title="Click & Be Rewarded" value="Get This Deal Now" tabindex="502">
<input type="hidden" name="dialingCode" id="dialingCode" maxlength="5" size="5" readonly value="<? echo $dialingCode; ?>">
</form>
<div class="p">
<?php printErrors(); ?>
<?php echo $msg_success; ?></div>
<p>Select your country and enter your full mobile number to subscribe. <strong>All Sms Coupons & Deals Are 100% FREE To Receive.</strong></p>
<div align="left">
<form action="unsms.php" method="LINK"><input type="submit" class="orange-btn" title="Remove your mobile number" value="Unsubscribe"></form>
</div>
</div>
<div class="optBoxb"></div>
</div>
<!-- end #optIn -->
Any help would be appreciated,