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
PHP using IF to display error
i have a MySQL query and i want to display 1 thing only if the number of affected rows is >=1
IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying
Please help with code for SMTP authenticated PHP email form
Hello, I'm creating a PHP email form, and for this particular server, I have to use SMTP Authenticat
try catch error
I have been trying try catch but, I can't get it to work. The code opens a non existing file called
PL/SQL: ORA-00947: not enough values error message
Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing
MySQL query problem
When I try to run the following piece of code, I get this error:
QuoteWarning: mysql_query(): sup
ORA-00932: inconsistent datatypes: expected - got CLOB
SO : windows xp
database : XE
there is a table (transito) with two fields of clob
Last character removed
I have created a string from an array. I have inserted commas from my form values. I am trying to re
Pls help with PHP
Pls can anyone direct me on how to create a user account for a customer. For example i want know if
Help With Showing Users On the Index Page
Ive got this code which works just how i want it to.
Code: <?
$timenow=time();