Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $enlace = mysql_connect('localhost:3307', 'root', '');
- if (!$enlace) {
- die('No pudo conectarse: ' . mysql_error());
- }
- mysql_select_db('base_de_datos') or die('No se pudo seleccionar la base de datos');
- $resultado = mysql_query("SELECT * FROM authors, titles, `title author`
- WHERE authors.Au_ID = `title author`.Au_ID
- AND `title author`.ISBN = titles.ISBN
- LIMIT 20
- ");
- if (!$resultado) {
- die('Consulta no válida: ' . mysql_error());
- }
- while ($fila = mysql_fetch_object($resultado)){
- //echo $fila->Author . "<br>";
- echo $fila->Title . "<br>";
- }
- /*
- if ($row = mysql_fetch_array($resultado)){
- echo "<table border = '1'>";
- echo "<tr>";
- echo "<td><b>Autor</b></td>";
- echo "<td><b>Titulo</b></td>";
- echo "</tr>";
- do {
- echo "<tr>";
- echo "<td>".$row["Author"]."</td>";
- echo "<td>".$row["Title"]."</td>";
- echo "</tr>";
- } while ($row = mysql_fetch_array($resultado));
- }
- */
- mysql_free_result($resultado);
- mysql_close($enlace);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement