Código PHP:
<?php
$alphaxx = $_GET['letter'];
$dsn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=artistasenallhen.mdb"; // Tal vez nescesites ajustar el path
$conn = odbc_connect( $dsn, '', '' ); // a lo mejor ODBC no te sirve, en ese caso checa que puedas usar COM y cambiarlo
switch( $alphaxx ) {
case 'a':
$sql = "SELECT * From Tabla1 WHERE artista Like 'a%' order by artista";
break;
case 'b':
$sql = "SELECT * From Tabla1 WHERE artista Like 'b%' order by artista";
break;
case 'p':
$sql = "SELECT * From Tabla1 WHERE artista Like 'p%' order by artista";
break;
case 'all':
$sql = "SELECT * From Tabla1 order by artista";
break;
}
$result = odbc_exec( $conn, $sql );
while( $data = odbc_fetch_array( $result ) ) {
$val1 = $data['id'];
$val2 = $data['artista'];
echo "<%var1 = \" $var1 ."" //" . var2 . " %><br>";
echo "<!--#include file=""www.asp""--><br>";
}
odbc_free_result( $result );
odbc_close( $conn );
?>