include "db.php";
$query = "SELECT * FROM Reasons";
$result = mysql_query($query);
if(mysql_num_rows($result)) {
while($row = mysql_fetch_assoc($result)){
echo " name='{$row['desc']}' onclick='disable()'>".$row['desc']."
";
}
echo "Other";
}
?>
$reason = $_GET['reason'];
echo $reason;
?>
Related Articles
Export to Excel Using PHP and Mysql
Below simple program will export mysql data values to excel sheet without using any PHP libraries. Export to Excel Using PHP and Mysql Note: IF you get errors or in excel all the data is in one column, then instead t tab space use, comma ‘,’.
Best way to loop through a PHP mysql Resultset
If you want to loop throuh the mysql result set twice then use below way. $result = mysql_query(“SELECT * FROM my_table”);while($row = mysql_fetch_assoc($result)) {// inside the loop} The problem is, if you want to loop through the same result set again, you will get an error because the internal pointer is currently at the end […]
Search and Retrieve Data from MySQL DB Using PHP
Below is the Simple PHP and MYSQL Search Program. Use below database queries: CREATE TABLE IF NOT EXISTS user (id int(10) NOT NULL AUTO_INCREMENT,Name varchar(20) NOT NULL,PRIMARY KEY (id)); INSERT INTO user (id, Name) VALUES (‘1’, ‘vicky’), (‘2’, ‘vivek’); Below is the sample program:
