[Mapserver-users] How to Build Point Shapefile from MySQL with PHP_Mapscript?

[BONNER S KARGER]

Since I'm not getting anywhere with the MySQL JOIN, how about building a
shapefile/dbf from a MySQL table using PHP_Mapscript? I'm pretty sure this
is do-able, but I can't find a good concrete example. 

I want to get
point data from my MySQL table, create a shapefile, then have Mapserver
display it. The layer must also be query-able, retrieving attribute data
from either the MySQL table, or from the dbf of the newly-created
shapefile.

Right now, I am stuck using MySQL...admin does not want to
implement another DBMS (one that is spatially enabled). I am new to
php_mapscript. I am using Mapserver 4.2.0, PHP 4.3.2, MySQL 3.48

Thanks, 
Bonner