ｙｍｆ - プログラム倉庫

<?php
require('calldata.php');
 
$a = $_GET['artist'];
 
$sql="SELECT y,m,w,r,a,t FROM music where a='";
$str="'";
$sql=$sql.$a.$str;
 
$result = mysql_query($sql);
 
$sx=0; 
while ($row = mysql_fetch_assoc($result)) {
$sx=$sx+1;
$a[$sx]=$row['a'];
$r[$sx]=$row['r'];
$y[$sx]=$row['y'];
$m[$sx]=$row['m'];
$w[$sx]=$row['w'];
$t[$sx]=$row['t'];
}
$n=$sx;
for($s=1;$s<$n;$s++){
print($y[$s]);
print(",");
print($m[$s]);
print(",");
print($w[$s]);
print(",");
print($r[$s]);
print(",");
print($a[$s]);
print(",");
print($t[$s]);
print(",");
}
$s=$n;
print($y[$s]);
print(",");
print($m[$s]);
print(",");
print($w[$s]);
print(",");
print($r[$s]);
print(",");
print($a[$s]);
print(",");
print($t[$s]);
 
mysql_close($link);
?>