Ad:

PHP Discussion Thread
Unsolved
Views: 3570

Mar 23rd, 2005

Need help diplaying null values

Expand Post »

I have a form on my site where members fill in info etc... This info goes into my database, I call to my DB to display this info in a table. My problem is that when someone does not fill in one of the spots in the form this goes to the DB as null and wont show up in my table, this makes my whole table get messed up and won't line up with the users information. My question is how can I get the null values to display null or show up blank in the table cell?

Here is the code I have would I put it

Here:
$sql="select id, name, email from update_table order by id";

Or in the actual table:
<table><td><tr>
<a href="profile.php?user=<?echo $row2['id'];?>"><?echo $row2['username'];
</tr></td?</table>

I have been trying to figure this out for weeks. Someone please help me out.

Similar Threads

how to select null values in condition in MySQL
Null values from database causing fatal error in PHP
Need help with NULL values in ColdFusion
datagrid replacing null values in VB.NET
Exception Data is Null. This method or property cannot be called on Null values. in VB.NET

eyelove808

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Mar 2005

Permalink

Mar 23rd, 2005

Re: Need help diplaying null values

PHP Syntax (Toggle Plain Text)
$query ="select id, name, email from update_table order by id"; 
$result = mysql_query($query);
if ($result == 0)
{
   echo "there was an error accessing the database!");
}
else
{
   for ($i=0; $i<mysql_num_rows($result); $i++)
   {
      $row = mysql_fetch_row($result);
      echo "<table><td><tr>\n"; 
      echo "<a href=\"profile.php?user=".$row[0]."\">".$row[1]."</a>
      echo "anything else needed .... yadda yadda yadda ";
   }
}
 
$query ="select id, name, email from update_table order by id"; 
$result = mysql_query($query);
if ($result == 0)
{
   echo "there was an error accessing the database!");
}
else
{
   for ($i=0; $i<mysql_num_rows($result); $i++)
   {
      $row = mysql_fetch_row($result);
      echo "<table><td><tr>\n"; 
      echo "<a href=\"profile.php?user=".$row[0]."\">".$row[1]."</a>
      echo "anything else needed .... yadda yadda yadda ";
   }
}

paradox814

Reputation Points: 13

Solved Threads: 4

Posting Whiz

Offline

351 posts
since Oct 2004

Permalink

Mar 23rd, 2005

Re: Need help diplaying null values

I tried that and it does not work. This is where I put it:

$result1=@mysql_query($sql,$con) or die("woops! not successful 1<br> $sql");
if ($result == 0)
{
echo "there was an error accessing the database!");
}

eyelove808

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Mar 2005

Permalink

Mar 24th, 2005

Re: Need help diplaying null values

Easiest thing to do is to alter your table to have a default value of "blank" rather than NULL. Then you don't have the problem.

However, I don't see that you would have a problem unless you are using if's on the results. If your while loop is something like this:

<table><?
while ($array = mysql_fetch_array($qry)) { ?>
<tr>
<td><? echo $array[id];?></td>
<td><? echo $array[name];?></td>
<td><? echo $array[hooha];?></td>
</tr><?
} >
</table>

A null value won't mung up the format in the above. How are you killing your table?

barnamos

Reputation Points: 15

Solved Threads: 0

Junior Poster in Training

Offline

50 posts
since Mar 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Am I looking for PHP?

Next Thread in PHP Forum Timeline: RSS Feeds Question

DaniWeb Message

Cancel Changes

User Name
Password