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.

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

Your Answer:

Login to answer

Other forums

Number Format
Hi All,

I have number '000000000050085' I want to format it to 500.85 Can any one give me

Displaying pictures
i have worked my way through storing images in directory and storing the location in mySQL db.Now i

how to load a Sys file with system load and call images?
normally you need register the module as a service with CreateService, and start the service

Problems with strings containing
Hey all,

I have encountered something strange in a script. I am trying to write an XML heade

foreach and array need help combining
Hi guys.

Here's the code

Code: array(
'tag' => 'code',<

How to secure my login data to my database?
Hi there,

It may be a stupid question but I don't know how to secure my login data to my data

Multiple includes losing variables
Hey all,

just starting out w php and ran into a problem pretty quickly. I'm
including seve

SAP BCS. BPS
Hi all,

I am seeking reading note on the following in BW

BCS, BPS
ADVANCE

Check Date/Time in PHP
What I need the code to check is that $reQuest is 24 hours in the past then return a time based on h

Help adding strtolower( to my in_array
strtolower i need to add it to this to work, iuno how.

Code: $moderators = array('Admin', 'ba