A tale of two views, or another MySQL parsing conundrum...

[mike.jones]

[shannah]

The parser is having trouble with the union statement.

What do you mean by a custom header?

-Steve

[mike.jones]

[shannah]

OK.. I guess I'm not sure what you mean by "MySQL View" then. Can you describe exactly what you want to appear in that header?

[mike.jones]

[shannah]

[mike.jones]

I appreciate the direction - I'll see if I can get it to work.

Thank you very much.

Mike

[mike.jones]

[shannah]

Check out the PHP docs for mysql_query() After doing the query you have to loop through the results and print them.
http://php.net/manual/en/function.mysql-query.php

[mike.jones]

Excellent.

I decided to simply have a result page (using PHP) all by itself to display on the projector for the event, and use xataface interface just for data entry at the event. Seems to be working out.

http://www.swmobridgecontest.org/contestresults.php

Thanks again for a most excellent system.

Mike

[shannah]

Looks good. Whatever code you used for your result page, you could have used inside any block in Xataface if you wanted to include it inside the Xataface interface