Hola amigos tengo un buscador y necesito buscar datos en varias tablas y me gustaría saber como puedo unir los selects o las consultas de cada tabla que aparecen abajo como:
Código PHP:
Ver original"SELECT *,
MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE) AS coincidencias
FROM cursophp
WHERE MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE)
ORDER BY coincidencias DESC";
"SELECT *,
MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE) AS coincidencias
FROM novedades
WHERE MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE)
ORDER BY coincidencias DESC";
como las uno?
aqui codigo:
Código PHP:
Ver original// Abrimos la conexión al servidor MySQL
// Instanciamos, indicando el recurso de conexión
$paging = new PHPPaging($link);
// varificamos que el formulario halla sido enviado
if(isset($_GET['Submit']) && $_GET['Submit'] == 'Buscar'){
// hacemos la consulta de busqueda
$q = "SELECT *,
MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE) AS coincidencias
FROM cursophp
WHERE MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE)
ORDER BY coincidencias DESC";
"SELECT *,
MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE) AS coincidencias
FROM spnewss
WHERE MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE)
ORDER BY coincidencias DESC";
"SELECT *,
MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE) AS coincidencias
FROM novedades
WHERE MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE)
ORDER BY coincidencias DESC";
"SELECT *,
MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE) AS coincidencias
FROM diseno
WHERE MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE)
ORDER BY coincidencias DESC";
"SELECT *,
MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE) AS coincidencias
FROM programas
WHERE MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE)
ORDER BY coincidencias DESC";
"SELECT *,
MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE) AS coincidencias
FROM guias
WHERE MATCH (TITULO)
AGAINST ('$frase' IN BOOLEAN MODE)
ORDER BY coincidencias DESC";
// Y se usa la función agregarConsulta() (Ver documentación)
$paging->agregarConsulta($q);
$paging->ejecutar();
echo stripslashes("<p><font size='2'>Su búsqueda arrojó <strong>$totalRows</strong> resultados para <strong>$frase</font></strong></p>"); // mostramos los resultados
while($datos = $paging->fetchResultado()){ ...
echo $datos['TITULO'];