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
Are sessions secure at all?..
I haven't really gotten into yet, but I was just thinking of something weird..
Lets say you h
Getting PHP to ammended the selected in option field
Hey Guys
thanks for everyones help so far. This site and its users are oozing awesomness.
How to pass parameter to tag query?
Hi,
I want to get the value of a tag at a specific time (like 10/27/09 15:29:59), I need to giv
progress bar...need expert opinion of experienced webmaster
Hey guys, quick question:
I want to display a progress bar when I upload files, but I am not
Drop Down and text box issue
Is it possible to set a drop down list and text boxes to a certain width?
here is my code
single page with referrer to show correct page
I have a simple website with a couple of different pages. I would like to be able to in a div tag w
Placing and array within an array then sorting it!
I have a page that runs two large mysql queries and saves the results into arrays, in php I then per
Significance of BPM
Hi Experts,
I am a novice in BPM , I just want to know how BPM as permenant department is
SMTP server...
I recently found a tutorial online on SMTP authentification for sending emails from webpages, here i
parse error
On my local machine I keep getting parse error for my footer. When I put it online, it doesn't show