You can add to your query:

where trim(vendname) <> ''

On Mar 26, 10:08 pm, jc...@lycos.com wrote:
> I have a table with a column named 'vendname'. This column isn't
> completely populated so as I query the column within the table to
> populate a pull down on a query page, there are many white spaces. My
> intent is to eventually have all of those empty table cells populated
> but until then, would really like to eliminate the white spaces and
> hoped I might get some ideas here. As it currently stands, I have
> approximately 50 rows with 15 'vendname' rows populated and a whole
> bunch of white space that shows up on the pull down query.
>
> My code is:
>
> <?php
> $hostName = "localhost";
> $userName = "####";
> $password = "########";
> $dbName = "approvals";
> $table = "approvals_tbl";
>
> mysql_connect($hostName, $userName, $password) or die("Unable to
> connect to host $hostName");
>
> mysql_select_db($dbName) or die("Unable to select database $dbName");
>
> $query = "SELECT DISTINCT vendname
> FROM $table";
> $result = mysql_query($query);
>
> $number = mysql_numrows($result);
>
> for ($i=0; $i<$number; $i++) {
> $vendname = mysql_result($result,$i,"vendname");
> print "<option value=\"$vendname\">$vendname</option>";
>
> }
>
> mysql_close();
> ?>
>
> any is greatly appreciated.
>
> John