You can use substr() and strpos() to show only the data to the left of a certain character... so it might look something like:
<?php echo(substr($row_WADAallshows2['location'],0,strpos($row_WADAallshows2['showbegin'],"-")); ?>
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.