单个$result1 = mysql_query("select * from jtrb1 where name='上衣' and price < 300");
$row1 = mysql_fetch_array($result1);$result2 = mysql_query("select * from jtrb2 where name='上衣' and price < 300");
$row2 = mysql_fetch_array($result1);$result3 = mysql_query("select * from jtrb3 where name='上衣' and price < 300");
$row3 = mysql_fetch_array($result3);组合select * from jtrb1,jtrb2,jtrb3
where jtrb1.name='上衣' and jtrb1.price < 300
and jtrb2.name='上衣' and jtrb2.price < 300
and jtrb3.name='上衣' and jtrb3.price < 300
$row1 = mysql_fetch_array($result1);$result2 = mysql_query("select * from jtrb2 where name='上衣' and price < 300");
$row2 = mysql_fetch_array($result1);$result3 = mysql_query("select * from jtrb3 where name='上衣' and price < 300");
$row3 = mysql_fetch_array($result3);组合select * from jtrb1,jtrb2,jtrb3
where jtrb1.name='上衣' and jtrb1.price < 300
and jtrb2.name='上衣' and jtrb2.price < 300
and jtrb3.name='上衣' and jtrb3.price < 300
还有
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
$query="SELECT * FROM jtrb1,jtrb2,jtrb3 WHERE jtrb1.name='上衣' and jtrb2.name='上衣' and jtrb3.name='上衣'";
$result= mysql_query($query,$con)or die(mysql_error());
$row= mysql_fetch_array($result);
while($row)
{
echo $row['jtrb1.Name']."<br>";
//下面省略
}
mysql_close();
?>
我这样子写输出空白。请大神指点。
还有
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
$query="SELECT * FROM jtrb1,jtrb2,jtrb3 WHERE jtrb1.name='上衣' and jtrb2.name='上衣' and jtrb3.name='上衣'";
$result= mysql_query($query,$con)or die(mysql_error());
$row= mysql_fetch_array($result);
while($row)
{
echo $row['jtrb1.Name']."<br>";
//下面省略
}
mysql_close();
?>
我这样子写输出空白。请大神指点。
把数组打印出来。。用foreach试一试。
select * from (
select * from jtrb1 where jtrb1.name='上衣' and jtrb1.price < 300
union all
select * from jtrb2 where jtrb2.name='上衣' and jtrb2.price < 300
union all
select * from jtrb3 where jtrb3.name='上衣' and jtrb3.price < 300
) as t
union all 是最能满足你需求而且一条sql搞定的
还有
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
$query="SELECT * FROM jtrb1,jtrb2,jtrb3 WHERE jtrb1.name='上衣' and jtrb2.name='上衣' and jtrb3.name='上衣'";
$result= mysql_query($query,$con)or die(mysql_error());
$row= mysql_fetch_array($result);
while($row)
{
echo $row['jtrb1.Name']."<br>";
//下面省略
}
mysql_close();
?>
我这样子写输出空白。请大神指点。
把数组打印出来。。用foreach试一试。
foreach 也是空白。SQL在phpmyadmin里可以输出内容,求解!
mysql_query("set character set 'utf8'");//读库
mysql_query("set names 'utf8'");//写库