sql - PHP: Show table of results from database -
i have simple bit of php should showing table of invites:
// connect database $host = '###'; $username = '###'; $pass = '###'; mysql_connect($host,$username,$pass); mysql_select_db("###"); // select news table $query = "select * creathive_applications"; $result = mysql_query($query); echo "<table>"; echo "<tr>"; while( ($row = mysql_fetch_array($result))) { echo "<td>".$row['firstname']."</td>"; echo "<td>".$row['lastname']."</td>"; echo "<td>".$row['email']."</td>"; echo "<td>".$row['url']."</td>"; } echo "</tr>"; echo "</table>"; // disconnect database mysql_close();
however it's not working? ideas why , how find out. :)
just confirm, <table>
, <tr>
being outputted , table name creathive_applications
h
did query work? you're not checking if $result
false after query call. table name sort of appears have typo in it, possibly should "creative_applications" (no h
)?
Comments
Post a Comment