Page 1 of 1

if then statement in query display HELP

Posted: Sun Apr 04, 2004 1:59 pm
by speedamp
hello everybody,

here is my problem: i wrote this script format results from my database, however i do not want to display a blank area on the table if the field is empy in the database.

I guess this would be an optional if statement saying something like "if field is populated display....if not then do not display".

How would i code that?

---------------------------------------------------------------------

<?php


$db = mysql_connect("localhost", ".....", ".......");

mysql_select_db("..........",$db);

echo "<table width=100% border=0>";
//while($user_row = mysql_fetch_array($user_result)){
$run_query = "SELECT * FROM calendar order by event_state, month, day";
$run_result = mysql_query($run_query);
echo "<tr><td><center><font size=+2 color=red>.......Calendar: </font></center></td></tr>";
echo "<tr><td></td></tr>";
echo "<tr><td></td></tr>";
// echo "<tr><td><b>Race Name </b> </td><td><b>State</b></td><td><b>City</b></td><td><b>Date</b></td><td><b>Website</b></td></tr></table>";
while($run_row = mysql_fetch_array($run_result)){
$mydatarunname = $run_row['name'];
$mydatarunstart = $run_row['event_start'];
$mydataruncategory = $run_row['category'];
$mydataruncategoryother = $run_row['category_other'];
$mydatarundescription = $run_row['description'];
$mydataruneventone = $run_row['event_one'];
$mydataruneventtwo = $run_row['event_two'];
$mydataruneventthree = $run_row['event_three'];
$mydatarundistanceone = $run_row['distance_one'];
$mydatarundistancetwo = $run_row['distance_two'];
$mydatarundistancethree = $run_row['distance_three'];
$mydataruncity = $run_row['event_city'];
$mydatarunstate = $run_row['event_state'];
$mydatarunaddress = $run_row['event_address'];
$mydatarunzip = $run_row['event_zip'];
$mydatarunday = $run_row['day'];
$mydatarunhour = $run_row['start_hour'];
$mydatarunminute = $run_row['start_minute'];
$mydatarunzone = $run_row['start_zone'];
$mydatarunmonth = $run_row['month'];
$mydatarunyear = $run_row['year'];
$mydatarunphonea = $run_row['phone_a'];
$mydatarunphoneb = $run_row['phone_b'];
$mydatarunphonec = $run_row['phone_c'];
$mydatarunemail = $run_row['email'];
$mydataruncontactname = $run_row['contact_name'];
$mydatarun = $run_row[''];
$mydatarunwebsite = $run_row['website'];
$mydatarunwebsiteresults = $run_row['results_website'];



echo "<table><tr><td>

<b><font color=red size=+2>".$mydatarunmonth."/".$mydatarunday."/".$mydatarunyear."</font></b><br>


<b><font size=+1>".$mydatarunname. "</font>&nbsp;".$mydatarundescription. "&nbsp;</b>&nbsp<i>".$mydataruncategory. "&nbsp;".$mydataruncategoryother. "</i>&nbsp;&nbsp;<b><i>".$mydatarunhour. ":".$mydatarunminute. "&nbsp;".$mydatarunzone. "</b></i><br>


<b>Start Location:&nbsp;</b>".$mydatarunstart. ",&nbsp;".$mydatarunaddress. ",&nbsp;".$mydataruncity.",&nbsp;".$mydatarunstate."&nbsp;".$mydatarunzip."<br>

<b>Event(s):&nbsp;&nbsp;".$mydataruneventone. "&nbsp;<it>".$mydatarundistanceone. "</it></b>......".$mydataruneventtwo. "&nbsp;&nbsp;<it>".$mydatarundistancetwo. "</it>......".$mydataruneventthree. "&nbsp;<it>".$mydatarundistancethree. "</it>&nbsp;<br>

<a href=http://".$mydatarunwebsite." target=race>".$mydatarunname."</a>&nbsp;&nbsp;&nbsp;&nbsp;<a href=http://".$mydatarunwebsiteresults." target=past>Past Results</a><br>

<b>Race Contact:&nbsp;</b>".$mydataruncontactname.",&nbsp;".$mydatarunemail.",&nbsp;(".$mydatarunphonea.")".$mydatarunphoneb."-".$mydatarunphonec."

</td></tr></table><hr>";
}
echo "</table>"
?>


-------------------------

thanks,
-michael

Posted: Sun Apr 04, 2004 3:09 pm
by Illusionist

Code: Select all

if (!empty($val)){
//display
}else{
//don't display
}

Posted: Sun Apr 04, 2004 4:19 pm
by speedamp
where do i put that? when i place it in the display area, it just prints what i place...


if(!empty($mydatarunwebsiteresults)){
<a href=http://".$mydatarunwebsiteresults." target=past>Past Results</a><br>
}else{&nbsp;
};


-Michael

Posted: Sun Apr 04, 2004 4:21 pm
by Illusionist
it just prints what i place...


i dont understand what that means.

Posted: Sun Apr 04, 2004 5:07 pm
by speedamp
do i put that in the display area? when i do it literally prints the code.

Posted: Sun Apr 04, 2004 5:33 pm
by Illusionist
probably because its inside of an echo?? maybe it'll help to see the full code...

Posted: Sun Apr 04, 2004 5:39 pm
by d3ad1ysp0rk
uhh.. instead of doing all that
$var = $row['var'];
stuff, use this:

Code: Select all

extract($run_row, EXTR_SKIP);

Posted: Sun Apr 04, 2004 5:41 pm
by speedamp
could you give me an example of how i would use that?

-michael

Posted: Sun Apr 04, 2004 5:43 pm
by Illusionist
[php_man]extract()[/php_man]

Posted: Mon Apr 05, 2004 9:05 am
by speedamp
here is the full code.


-----------------------------------------------------

<?php


$db = mysql_connect("localhost", ".....", ".....");

mysql_select_db("......",$db);

echo "<table width=100% border=0>";
$run_query = "SELECT * FROM calendar order by event_state, month, day";
$run_result = mysql_query($run_query);
echo "<tr><td><center><font size=+2 color=red>....... Events Calendar: </font></center></td></tr>";
echo "<tr><td></td></tr>";
echo "<tr><td></td></tr>";
while($run_row = mysql_fetch_array($run_result)){
$mydatarunname = $run_row['name'];
$mydatarunstart = $run_row['event_start'];
$mydataruncategory = $run_row['category'];
$mydataruncategoryother = $run_row['category_other'];
$mydatarundescription = $run_row['description'];
$mydataruneventone = $run_row['event_one'];
$mydataruneventtwo = $run_row['event_two'];
$mydataruneventthree = $run_row['event_three'];
$mydatarundistanceone = $run_row['distance_one'];
$mydatarundistancetwo = $run_row['distance_two'];
$mydatarundistancethree = $run_row['distance_three'];
$mydataruncity = $run_row['event_city'];
$mydatarunstate = $run_row['event_state'];
$mydatarunaddress = $run_row['event_address'];
$mydatarunzip = $run_row['event_zip'];
$mydatarunday = $run_row['day'];
$mydatarunhour = $run_row['start_hour'];
$mydatarunminute = $run_row['start_minute'];
$mydatarunzone = $run_row['start_zone'];
$mydatarunmonth = $run_row['month'];
$mydatarunyear = $run_row['year'];
$mydatarunphonea = $run_row['phone_a'];
$mydatarunphoneb = $run_row['phone_b'];
$mydatarunphonec = $run_row['phone_c'];
$mydatarunemail = $run_row['email'];
$mydataruncontactname = $run_row['contact_name'];
$mydatarun = $run_row[''];
$mydatarunwebsite = $run_row['website'];
$mydatarunwebsiteresults = $run_row['results_website'];



echo "<table><tr><td>

<b><font color=red size=+2>".$mydatarunmonth."/".$mydatarunday."/".$mydatarunyear."</font></b><br>


<b><font size=+1>".$mydatarunname. "</font>&nbsp;".$mydatarundescription. "&nbsp;</b>&nbsp<i>".$mydataruncategory. "&nbsp;".$mydataruncategoryother. "</i>&nbsp;&nbsp;<b><i>".$mydatarunhour. ":".$mydatarunminute. "&nbsp;".$mydatarunzone. "</b></i><br>


<b>Start Location:&nbsp;</b>".$mydatarunstart. ",&nbsp;".$mydatarunaddress. ",&nbsp;".$mydataruncity.",&nbsp;".$mydatarunstate."&nbsp;".$mydatarunzip."<br>

<b>Event(s):&nbsp;&nbsp;".$mydataruneventone. "&nbsp;<it>".$mydatarundistanceone. "</it></b>......".$mydataruneventtwo. "&nbsp;&nbsp;<it>".$mydatarundistancetwo. "</it>......".$mydataruneventthree. "&nbsp;<it>".$mydatarundistancethree. "</it>&nbsp;<br>


<b>Race Contact:&nbsp;</b>".$mydataruncontactname.",&nbsp;".$mydatarunemail.",&nbsp;(".$mydatarunphonea.")".$mydatarunphoneb."-".$mydatarunphonec."<br>

<a href=http://".$mydatarunwebsite." target=race>".$mydatarunname."</a>&nbsp;&nbsp;&nbsp;&nbsp

if(!empty($mydatarunwebsiteresults)){
<a href=http://".$mydatarunwebsiteresults." target=past>Past Results</a><br>
};
else{&nbsp;
};

</td></tr></table><hr>";
}
?>


-----------------------------------------------------------------------------------------------
-mike