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
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:
PHP Magic Constants __LINE__ __FILE__ __DIR__ __CLASS__ __TRAIT__ __METHOD__ __NAMESPACE__
Below are the list of PHP predefined Magic Constants PHP Magic Constants Name Description __LINE__ The current line number of the file. __FILE__ The full path and filename of the file with symlinks resolved. If used inside an include, the name of the included file is returned. __DIR__ The directory of the file. If used […]
How to Check the Last Day in Month
Check the Last Day in Month $startDate = “20150624”;$endDate = “20150722”;$startDate = strtotime($startDate);$endDate = strtotime($endDate);$dayLength = 60 * 60 * 24;$checkDateRange = ($endDate – $startDate) / $dayLength;$datesStartMonth = date(‘t’, $startDate);if ($checkDateRange > $datesStartMonth) {echo $error = “Date range should be with in one month”;}
