这个mysql语法有什么问题?我把它复制到phpmyadmin,它运行得很完美。当我试图从php获取数组时,它返回了一个"bool(false)"错误。
(
SELECT
id,
cim,
'news' as kat
FROM
mbsz_news
WHERE
cim LIKE '%anystring%'
OR lead LIKE '%anystring%'
OR content LIKE '%anystring%'
)
UNION
(
SELECT
id,
p_name,
'plaza' as kat
FROM
mbsz_plazas
WHERE
p_name LIKE '%anystring%'
OR uzemelteto LIKE '%anystring%'
)
UNION
(
SELECT
id,
cim,
'book' as kat
FROM
mbsz_konyvtar
WHERE
cim LIKE '%anystring%'
OR kszam LIKE '%anystring%'
OR kiado LIKE '%anystring%'
)
PHP代码:
$res = mysql_query($sql);
while($row = mysql_fetch_array($res))
{
echo $row['type'];
}
$res
给出错误布尔(false)谢谢你的帮助。
您必须声明sql变量。例如
$sql = (
(SELECT
id,
cim,
'news' as kat
FROM
mbsz_news
WHERE
cim LIKE '%anystring%'
OR lead LIKE '%anystring%'
OR content LIKE '%anystring%'
)
UNION
(
SELECT
id,
p_name,
'plaza' as kat
FROM
mbsz_plazas
WHERE
p_name LIKE '%anystring%'
OR uzemelteto LIKE '%anystring%'
)
UNION
(
SELECT
id,
cim,
'book' as kat
FROM
mbsz_konyvtar
WHERE
cim LIKE '%anystring%'
OR kszam LIKE '%anystring%'
OR kiado LIKE '%anystring%'
)
)
当调用变量时,php应该工作吗?
$res = mysql_query($sql);
while($row = mysql_fetch_array($res))
{
echo $row['type'];
}