hi guys, thought I'd try this. Trying to display records in database. Below is my code: Help? ------------------------------------------------------- <!DOCTYPE html><html> <head></HEAD><body><center><b> <b><center>lookup Link List</center></b><br>
<?php error_reporting(E_ALL ^ E_NOTICE); // error_reporting(0); <?php include('lookupdb-connect.php'); $query = "SELECT * FROM `lookuptbl` WHERE `target` = `$target` ORDER by target Asc"; $result = $mysqli->query($query) or die($mysqli->error.__LINE__); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { echo '<table style="border:1px solid red;">', '<tr align="center" > <td>', $row['target'], '</td> <td>', $row['purpose'], '</td> <td>', $row['user'], '</td> <td>', $row['password'], '</td> <td>', $row['email'], '</td> <td>', $row['sec?'], '</td> <td>', $row['secAns'], '</td> <td>', $row['visits'], '</td> <td>', $row['lastdate'], '</td> <td>', $row['lasttime'], '</td> <td>', $row['saved?'], '</td> </tr> </table>'; ?> </body></html> ----------------------------------------------- this is displayed:
lookup Link List
query($query) or die($mysqli->error.__LINE__); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { echo '', ' ', $row['target'], ' ', $row['purpose'], ' ', $row['user'], ' ', $row['password'], ' ', $row['email'], ' ', $row['sec?'], ' ', $row['secAns'], ' ', $row['visits'], ' ', $row['lastdate'], ' ', $row['lasttime'], ' ', $row['saved?'], ' '; ?>
|