Php If in MySql query (hiding labels if a field is empty)
Posted on
16th Feb 2014 07:03 pm by
admin
Okay, I've been trying to do this for a while, and I'm finally going to ask for help so I can get the simple answer and feel like an idoit .
Anyway, I'm building a dynamic driver profile page for my NASCAR website. I have sections for hometown, driver website, spouse, etc.
Did you know?Explore Trending and Topic pages for more stories like this.
This is all displayed down the side of the page. However, if there is a single driver that has no spouse, there is still an area where the Spouse label is displayed when it is on the website.
Each page has labels going down for each field in the MySql table. These show when the MySql database is queried.
Hopefully that makes since?
Anyway, here is what I have tried and all it does is break the page.
<?php
// Connects to your Database
mysql_connect("BLAH BLAH BLAH", BLAH BLAH BLAH", "BLAH BLAH BLAH") or die(mysql_error());
mysql_select_db("BLAH BLAH BLAH") or die(mysql_error());
$data = mysql_query("SELECT * FROM `BLAH BLAH BLAH` WHERE `BLAH BLAH BLAH` = 'BLAH BLAH BLAH'") or die(mysql_error());
while($info = mysql_fetch_array( $data ))
{
if (".$info['spouse']."=="")
{echo "None";}
else {echo "Spouse: ".$info['spouse'] . "";}
}
?>
Any help is really, really, really, really appreciated
No comments posted yet
Your Answer:
Login to answer
126 
17 
Other forums
Doubles are giving me problems
Ok so, first of all i made a double = 0.05, but when running the debugger it shows up as 0.04999. I
Sessions work for me and not others?
I'm having a bit of bad luck with sessions. In the past they have worked fine for me, but this time
for loop without same $i digits?
Hi,
Can some guru please advise how can I accomplish this with a simple for loop ?
I
selectbox+database connection retrive problem
Code: [Select]
<tr>
<th align="left" scope="c
understanding functions and classes
Code: [Select]
class person {
var $name = "Jimmy Goe";
function get_nam
Working with Dates, help.
Sooo to make a long story short, here's what im trying to accomplish.
I need to create a drop
php libs/ browsercap.in
ok i have a host that refuses to stay current. they control my php settings and libs. is there a way
returning data from an ssh2_exec()
here's what i got.
$conn = ssh2_connect($this->_host);
ssh2_auth_password($c
Chat Box in PHP
I was thinking in doing a Chat Box in PHP. For that I would use a form with two fields, Nick and Mes
How a counter of users ? such as ---> (231 Viewing)
I want to count how many users are actually viewing the page, How is that possible?
Thank you guy
