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
Multi image upload
I have a gallery to build and want to build a dynamic upload form to allow for $var number of fields
cstdatomic (c++0x std::atomic) / g++ 4.4
Hello,
I'm trying to use cstdatomic (std::atomic in the upcoming c++0x standard) in g++
Calander Basic Spript help
hi, just starting out with PHP and have the following script:
<?php
//This gets t
noob cURL help
I have a pretty basic form that I need to cURL post to a file in my includes folder (includes/login.
PHP Search Issue
Hi, I am using the following code to search and return flights from a database. The user searches by
how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a s
generating all possible random letters
hi'
how can i randomize the letters a,b,c,d,e all possible ways, and i want to print the res
with clause
hi all, i have a big query that usually access the same table more than once. for example, i have s
understanding functions and classes
Code: [Select]
class person {
var $name = "Jimmy Goe";
function get_nam
how make 2 column in table with data tybe long row
hi every one
I want make in my table 2 column with data tybe long raw
how thi
