Skip to main content
Participant
October 22, 2006
Question

PHP MySQL NULL Values ??

  • October 22, 2006
  • 1 reply
  • 196 views
Hi,
I am trying to implement a CMS in Dreamweaver MX 2004 using PHP MySQL. My Product table contains fields that are not relavent to all products and at the moment i have given these the value NULL. Is there anyway for dreamweaver not to display the NULL fields or is my problem with the database.
Thanks for any help,
Ian
This topic has been closed for replies.

1 reply

Inspiring
October 22, 2006
On Sun, 22 Oct 2006 16:53:07 +0000 (UTC), "irl_123"
<webforumsuser@macromedia.com> wrote:

>Hi,
> I am trying to implement a CMS in Dreamweaver MX 2004 using PHP MySQL. My
>Product table contains fields that are not relavent to all products and at the
>moment i have given these the value NULL. Is there anyway for dreamweaver not
>to display the NULL fields or is my problem with the database.
> Thanks for any help,
> Ian

Something like this:

if (!is_null(your recordset field here)) {
//show the recordset field
}
--
Steve
steve at flyingtigerwebdesign dot com