SELECT * FROM table1 LEFT JOIN table2 USING (id); //table1第一个数据库表,table2第二个数据库表, //关连同一个字段id
$strSQL="SELECT * FROM mp3 LEFT JOIN wma USING (songname) where SongName like '%$songname%'";是这样吗?
$strSQL="select * from mp3,wma where SongName like '%". $songname% ."'";
$strSQL="select * from mp3,wma where SongName like '%". $songname ."%'";
to:leeeel(三角比三星差?)执行也出错:(
select mp3.SongName as mp3name, wma.SongName as wmaname form mp3, wma where mp3.SongName like '%$songname%' or wma.SongName like '%$songname%'建议先在sql里调试, 因为在php里出错的原因比较多
也请select语句注意修改为类:select mp3.SongName as mp3name,
wma.SongName as wmaname....
一类, 否则就算sql可以正常执行, 也可能使返回来数组中列名无法确定而出错
可我这样做了程序根本执行不下去了啊
//table1第一个数据库表,table2第二个数据库表,
//关连同一个字段id
wma.SongName as wmaname
form mp3, wma
where mp3.SongName like '%$songname%'
or wma.SongName like '%$songname%'建议先在sql里调试, 因为在php里出错的原因比较多