DaniWeb Forum Index > Web Development > PHP

not showing empty values coming from database

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: May 2008

Posts: 74

Reputation: servis is an unknown quantity at this point

Solved Threads: 0

servis

Offline

Junior Poster in Training

not showing empty values coming from database

Jun 16th, 2009

i am getting the list of values from databas table, some values are null, i want to show the values, which are not null. example is as follow,

Help with Code Tags

(Toggle Plain Text)

//sql query 
while ($row =mysql_query($result))
{
$carBrand     =$row['brandName'];
$carMod        = $row['model'];
$carModYear =$row['modYear'];
$regCity        =$row['regCity'];
$demand      =$row['demand'];
//some of them are null, i want to print here only those are not null
}

actully i have no idea how to do it...
please help..

•

Join Date: Jun 2009

Posts: 68

Reputation: djjjozsi is an unknown quantity at this point

Solved Threads: 10

djjjozsi

Offline

Junior Poster in Training

Re: not showing empty values coming from database

Jun 16th, 2009

build tables, and

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
print "<tr>";
echo "<td>". ( empty($row["brandName"]) ? "-" : (htmlspecialchars($row["brandName"])) )."</td>";
echo "<td>". ( empty($row["model"]) ? "-" : (htmlspecialchars($row["model"])) )."</td>";
echo "<td>". ( empty($row["modYear"]) ? "-" : (htmlspecialchars($row["modYear"])) )."</td>";
echo "<td>". ( empty($row["regCity"]) ? "-" : (htmlspecialchars($row["regCity"])) )."</td>";
echo "<td>". ( empty($row["demand"]) ? "-" : (htmlspecialchars($row["demand"])) )."</td>"; 
print "</tr>";
print "<tr>";
echo "<td>". ( empty($row["brandName"]) ? "-" : (htmlspecialchars($row["brandName"])) )."</td>";
echo "<td>". ( empty($row["model"]) ? "-" : (htmlspecialchars($row["model"])) )."</td>";
echo "<td>". ( empty($row["modYear"]) ? "-" : (htmlspecialchars($row["modYear"])) )."</td>";
echo "<td>". ( empty($row["regCity"]) ? "-" : (htmlspecialchars($row["regCity"])) )."</td>";
echo "<td>". ( empty($row["demand"]) ? "-" : (htmlspecialchars($row["demand"])) )."</td>"; 
print "</tr>";

Last edited by djjjozsi; Jun 16th, 2009 at 7:55 am.

•

Join Date: Oct 2007

Posts: 78

Reputation: navi17 is an unknown quantity at this point

Solved Threads: 5

navi17

Offline

Junior Poster in Training

Re: not showing empty values coming from database

Jun 16th, 2009

here is the simple solution:

Help with Code Tags

(Toggle Plain Text)

while ($row =mysql_query($result))
{
if(!empty($row['brandName'])
{
$carBrand     =$row['brandName'];
}
if(!empty($row['model'])
{
$carMod        = $row['model'];
}
---
---
---
}

this is just a example. modified your code according to your needs.

Defeat the defeat before defeat defeats you.

•

Join Date: Jun 2009

Posts: 68

Reputation: djjjozsi is an unknown quantity at this point

Solved Threads: 10

djjjozsi

Offline

Junior Poster in Training

Re: not showing empty values coming from database

Jun 16th, 2009

while ($row =mysql_query($result)) ????????

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
	include("conn_bd.php");
    $sql="select * from table";
 
    $result_res=mysql_query($sql) or die(mysql_error());
    print "<table border=\"1\">";
    if(mysql_num_rows($result_res)>0)
    {
        while($rows_res=mysql_fetch_assoc($result_res))
        {
            /* here comes the printed values*/
print "<tr>";
echo "<td>". ( empty($rows_res["brandName"]) ? "&nbsp;" : $rows_res["brandName"] )."</td>";
echo "<td>". ( empty($rows_res["model"]) ? "&nbsp;" : $rows_res["model"] )."</td>";
echo "<td>". ( empty($rows_res["modYear"]) ? "&nbsp;" : $rows_res["modYear"] )."</td>";
echo "<td>". ( empty($rows_res["regCity"]) ? "&nbsp;" : $rows_res["regCity"] )."</td>";
echo "<td>". ( empty($rows_res["demand"]) ? "&nbsp;" : $rows_res["demand"] )."</td>";
print "</tr>";
        }
        print "</table>";
    }
    else
    echo "No result in res table ...";
 
?>
<?php
	include("conn_bd.php");
    $sql="select * from table";

    $result_res=mysql_query($sql) or die(mysql_error());
    print "<table border=\"1\">";
    if(mysql_num_rows($result_res)>0)
    {
        while($rows_res=mysql_fetch_assoc($result_res))
        {
            /* here comes the printed values*/
print "<tr>";
echo "<td>". ( empty($rows_res["brandName"]) ? "&nbsp;" : $rows_res["brandName"] )."</td>";
echo "<td>". ( empty($rows_res["model"]) ? "&nbsp;" : $rows_res["model"] )."</td>";
echo "<td>". ( empty($rows_res["modYear"]) ? "&nbsp;" : $rows_res["modYear"] )."</td>";
echo "<td>". ( empty($rows_res["regCity"]) ? "&nbsp;" : $rows_res["regCity"] )."</td>";
echo "<td>". ( empty($rows_res["demand"]) ? "&nbsp;" : $rows_res["demand"] )."</td>";
print "</tr>";
        }
        print "</table>";
    }
    else
    echo "No result in res table ...";

?>