another question...

[kaos057]

ok, I know that to list how many rows there are to use:

echo mysql_num_rows($result);

but is there a way to only list the rows that have data in a certain field?

i am using:

$result = mysql_query("SELECT fieldname FROM dbname",$db);

for the query which is how to only get data from that field right? But back to my original question, how do I list ONLY the rows with data in that field?

[drew010]

$result = mysql_query("SELECT fieldname FROM dbname",$db);

while($query_data = mysql_fetch_object($result) {
$fieldname_data = $query_data->fieldname;
  if(!empty($fieldname_data)) {
  echo "This row does contain the data $fieldname_data<br>";
  }
}

that will check all the fields returned and if they are empty it wont display them.

[kaos057]

nm i figured it out as soon as i hit post lol.

$result = mysql_query("SELECT fieldname FROM dbname WHERE fieldname='data'",$db);

was my solution

:rolleyes: