Hi I am looking to show a row from a table in a data base on a static page website I have a script (below) that shows the whole table but i only want to show one row from the table I would like to call the row by the field userID so in other words call database, table and row userID 1 any ideas <html><head><title>MySQL Table Viewer</title></head><body> <?php $db_host = 'localhost'; $db_user = 'root'; $db_pwd = 'lptm42b'; $database = 'sphinx'; $table = 'spheres'; if (!mysql_connect($db_host, $db_user, $db_pwd)) die("Can't connect to database"); if (!mysql_select_db($database)) die("Can't select database"); // sending query $result = mysql_query("SELECT * FROM {$table}"); if (!$result) { die("Query to show fields from table failed"); } $fields_num = mysql_num_fields($result); echo "<h1>Table: {$table}</h1>"; echo "<table border='1'><tr>"; // printing table headers for($i=0; $i<$fields_num; $i++) { $field = mysql_fetch_field($result); echo "<td>{$field->name}</td>"; } echo "</tr>\n"; // printing table rows while($row = mysql_fetch_row($result)) { echo "<tr>"; // $row is array... foreach( .. ) puts every element // of $row to $cell variable foreach($row as $cell) echo "<td>$cell</td>"; echo "</tr>\n"; } mysql_free_result($result); ?> </body></html> PHP: Thanks
Just change your $result variable: $result = mysql_query("SELECT * FROM {$table} WHERE userID = '1'"); Code (markup):