I've got a Products page on my client's PHP site which I want to make a hub for various link building efforts. Would also like it to show up as a clean looking URL such as www.laviolarestaurant.com/products.htm, instead of what it looks like now:
http://www.laviolarestaurant.com/php...&compcode=gene

Is there a way I can do this, with a redirect or some other measure which doesn't require rocket science? Can it be done without a major SEO sacrifice?

Thanks
PB

This can be done using htaccess rewrite module:

RewriteEngine On
# This rule will convert: http://www.laviolarestaurant.com/product-59.html
# To: http://www.laviolarestaurant.com/php...&compcode=gene
RewriteRule ^product-([0-9]+).html$ php/mainSubPage\.php?linkid=$1&compcode=gene&%{QUERY_STRING} [L]

Can it be done without a major SEO sacrifice?

Any time URLs are redirected there will be SE disruption.

301 redirected & rewritten URLs take around 3 months to restabilise