How do I query a NON empty mysql field?

cosmo7

I want my script to bring up only the results for which the "drawing" field is not empty. I tried using IS NOT NULL but that didn't work... (It brought up all the results in the table)
Anyway... here's my script can someone show me what I'm doing wrong?

<?php 

// Database Connection 
include("dbinfo.inc.php");
$db = mysql_connect("$server", "$username", "$password");
mysql_select_db($database,$db) or die (mysql_error()); 

$sql = mysql_query("SELECT * FROM data1 WHERE drawing IS NOT NULL"); 
?>
<h1>Items with drawing...</h1>
<?
while($row = mysql_fetch_array($sql)){

$num=$row['itemnumber'];
$desc=$row['description'];
$draw=$row['drawing'];
$status=$row['stat'];


echo "<b>Item number:</b><font size=5 color=blue>$num</font><br>
	<b>Description:</b>$desc<br>
	<b>Drawing:</b>$draw<br>
	<b>Email:</b>$status<br>
	<hr size=3 color=red>"; 
}
?>

SpanKie

Give this a try, seems to always work for me.

$sql = mysql_query("SELECT * FROM data1 WHERE drawing <> '' ");

devinemke

Originally posted by cosmo7
I want my script to bring up only the results for which the "drawing" field is not empty.

let's define the word "empty". a blank field and a NULL field are not the same thing ('' != NULL). it sounds to me like your field does not default to NULL so consequently a blank filed is the default. so if you think about it, your query is working exactly as it should: you are asking for each record that IS NOT NULL which of course includes all of the blank fields. you can either change your default to NULL or you can change your query to something like:

SELECT * FROM data1 WHERE drawing != ''

SpanKie

or !=

🙂 😃 😉

cosmo7

Thanks again...
It works now.