populating a table (html) based on a table (mysql)

[Anon]

I am trying to create a table (html) which is generated based on a mysql table.

I want the rows of the html table to be based on NON null values in the mysql table. If there are null rows in the mysql table I do not want a row added to the html table for that row in the database.

I am not sure how clear this is but if you can help plesae let me know.

-Michael

[Anon]

Another problem I am having here is: this table is going to be populated using 2 maybe 3 sql statements.

IE: row1 is gathered from one table while row2 and row3 are gathered from another table.

Completely Lost atm,

Michael

[Anon]

Why won't sql join stmts work?

-pancho

[Anon]

This would probably work however I am rather new to php and sql so the syntax escapes me.

[zalath]

You could formulate the query so, that it only accepts rows where a certain field has a value (like if you are doing this in a user table, you could choose usernme, something that should always be there)
for example SELECT * FROM usertable WHERE NOT (username IS NULL)
This would return only the rows where username wasn't blank.

-L-