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

Progress bar for webpage
Hi,
I want to implement a progress/waiting bar on my webpage - exactly the same thing that the Mi

Date Question
I'm using the TIMESTAMP() function within mysql to set the date/time for certain events. However, ho

OOP help
okay so i have a class im making it has everything setup i just need to randomize the 2 variables an

creating a 1 to 100 in a table
hi guys I am a newb in php need some help.

I have a table with 1 column and 100 rows and in

Header redirect
Hello ive got a problem ive got form with its action set to itself.
Code: <form id="f

Connection Timeout
I'm using xmii 12.0

I'm calling a transaction as a web service from a windows application

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks

Php WordPress help
I am writing the following code for making a plugin

<?php
header("Content-Type

highlighting search terms
well, I started this in the regular PHP section, but it no longer fits there. Suffice it to say, I'm

pass form variables straight to email, no database required?
hello all,

im working on this form...

http://www.adobedayevents.com/project_request/pr