I would like to display a drop down list with data retrieved from a table with only one column
this is my form
<html>
<head>
</head>
<body>
<form action="insert_customer_complaint.php" method="post">
Name: <input type="text" name="name"><br>
Complaint: <input type="text" name="comp"><br>
Reason: <select name="reason">
Add <input type="submit">
</form>
</body>
</html>
this the php file i use to insert data
<?php
// Create connection
$con=mysqli_connect("localhost","ccc","ccc","ccc");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql="INSERT INTO reason (reason_name)
VALUES
('$_POST[reason_name]')";
if (!mysqli_query($con,$sql))
{
die('Error: ' . mysqli_error($con));
}
echo "1 record added";
mysqli_close($con);
?>
Inserting part works very well I need to get data for the drop down list from a table with one column using the same php file
table name = reason, column name = reason_name
please help me out
I have manged to insert data and every thing works well. now i want to generate report in a table from where the the column name should be retrieved from from the data in a particular row here's what i need
please see click for image
http://testserverforprojects.tk/CC/tables.JPG
table should be dynamic because it should have a latest year at the end for instance this year only will have data upto 2013 so 2013 will be the last column.. so in 2015, 2014 will be the last column
