This is the last thing I'm gonna do, after I can make this work, I can produce to designing which might be a lot easier. Thanks for all your help.I want to list a record from mysql using php by typing a query in the text box. Then the program will list all the records that has that element, for example address.Here is my code: \[code\] mysql_select_db("koro", $con); \\what will I put in the WHERE ADDRESS="? $result = mysql_query("SELECT * FROM students WHERE ADDRESS="); echo "<table border='1'> <tr> <th>Firstname</th> <th>Lastname</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['IDNUMBER'] . "</td>"; echo "<td>" . $row['LNAME'] . "</td>"; echo "<td>" . $row['FNAME'] . "</td>"; echo "<td>" . $row['MNAME'] . "</td>"; echo "<td>" . $row['GRADEYR'] . "</td>"; echo "<td>" . $row['ADDRESS'] . "</td>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?>\[/code\]The listform.html:\[code\] <html> <head> <form action="list.php" method="post"> address:<input type="text" name="grup" value="" /><br/> <input type="submit" name="List" value="" /><br/> </form> </head> </html>\[/code\]\what will I put in the WHERE ADDRESS="?thanks
List records in mysql using php
- Thread starter celdrgcg
- Start date