"retrieving data through mysql using function and use in the select box?" Code Answer

do like this

function selectdata(){
   $select="select * from table_name";

   $run=mysql_query($select);
   $field_name = '';
   while($fetch=mysql_fetch_array($run)){
       $field_name.="<option value=''>" . $fetch['field_name'] . "</option>";
   }
   return $field_name;
}

and in html

<select name="office_name">
<?php echo selectdata(); ?>
</select>

By Gijo Varghese on May 23 2022

Answers related to “retrieving data through mysql using function and use in the select box?”

The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
How to write a stored procedure using phpmyadmin and how to use it through php?
Auto populate a select box using an array in PHP
Zend Framework - Set 'selected' value in select box dropdown list
How to set up default value in symfony2 select box with data from database
What function to use to hash passwords in MySQL?
Fetching data from Mysql DB to listView using JSON and PHP
I want to insert data into mysql database using PDO of PHP. But the data is not inserted
Exporting data from mysql in the xml using php
PHP & MySQL: How can I use “SET @rank=0;” in $query=
Retrieve data from mysql and display in the form of ascii text table in browser
AngularJS & Laravel 4.2 retrieving data from multip tables and joining them
Use “mysql_fetch_row” to retrieve results from database and insert into array using PHP and mysqli?
Dynamic select box to populate a textfield using AJAX or jQuery and PHP
Update value in mysql table when select box onchange
How do I select something in MYSQL without selecting it twice if its in the row
Using PHP $_POST to remember a option in a select box?
get data from mysql with ajax and json into different textareas
Remembering options in a select box array after submitting through php
How to format data in specific way using html and php
PHP Serialize Function - Adding serialized data to mysql and then fetch and display
Retrieving data through two model relationships
Return a conversation list and the last message of each message using php and mysql database
Set a variable value in one function and use in other functions, when called directly from link in codeigniter
Filter results based on the select box selected value
Using Apostrophe in MySQL ENUM value that will populate HTML combo box for database search
How to repeat the form data according to integer value get from the select box.?
retrieve data from db using function pdo
Get data from MySQL database by specific id in url
MySQL: Select data from a table where the date falls in the current Week and current Month
Error updating MySQL data through PHP
Cannot insert data in the database using option(textarea)
XAMPP and WAMP in the LAMP, what's the best? [closed]
Display Mysql table field values in Select box
insert data to mysql database from multiple select list (html form)
What's faster/better to use: the MySQL or PHP md5 function?
How to determine if a MySQL update query succeeded when the data passed in the query is the same as what is already...
PHP using mcrypt and store the encrypted in MySQL
MySQL data contains special characters like š and ?, but they are displayed as '?' on the web page. Why?
PHP/MySQL: Retrieve a single path in the Adjacency List model
update the value of select box with php mysql jquery ajax
Fetch and insert data into mysql using angularjs
Use of greater than or equals(>=) and lesser than or equals(<=) in SQL SELECT statements and PDO
How to disable dynamic select box options based on data coming from two tables in mysql database
Select box: how to populate years php
Select Distinct month and year from mysql timestamp field and echo them in php
populate a select box with php mysql
How to use HTTP Authentication with PHP and then run the entered data against a database?
Using Match and Against in MySQL and CodeIgniter
How do I get the “ID” number from a mysql record and use it to update that record using php?
Select id from one query and use it in another
PHP MySQL query using UNIONs and locating which table the data came from
PHP mysql query judge and not echo the repeart part
how to use sessions and arrays in a database query to store and display data
MySQL WEEK() : Get all weeks in date range (with/without records)
Forward Back Records in MySQL with the same DATA in the primary
wierd bug when reading from a csv file and importing data into mysql using php
How to upload long blob (image) to mysql database using java and retrieve in php?
HTML - changing color in text area from an option inside of a select box generated from mysql
How to use LIKE for mysql search with JOIN and ORDER BY the count of most rows/votes in the vote table?
Using jQuery to send data from a multipart/form-data through ajax
Saving a <div> to MySQL using JS and PHP - possible?
Select results that are only between today and 2 days in the future
unable to insert data into mysql using php
Retrieving the last insert id from MySql using PHP
Insert data from multiple array form inputs using php and mysql
fetch data from mysql to a list view in android only show the first item from the table how to fix?
Retrieving data from two tables in CodeIgniter
How to submit Jquery Add Rows data to mysql using PHP
Retrieving data from two tables first table text data second table media images. the images fails [closed]
Ajax image upload where image gets datetimestamp added to FILENAME and image title get's inserted through MYSQL...
How to i fetch all the date in to the select data table [closed]
How to put search box in the database table using PHP and Mysql
Reason for Column is invalid in the select list because it is not contained in either an aggregate function or the...
How to have a default option in Angular.js select box
Column “invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause”
SSL and man-in-the-middle misunderstanding
Find and Replace text in the entire table using a MySQL query
Connect to remote MySQL database through SSH using Java
How to select from two tables in MySQL even if not all rows in one table have corespondents in the other?
What is the difference between function and procedure in PL/SQL?
Why is an MD5 hash created by Python different from one created using echo and md5sum in the shell?
How do you remove all the options of a select box and then add one option and select it with jQuery?
How to get multiple select box values using jQuery?
Find distance between two points using latitude and longitude in mysql
GROUP BY behavior when no aggregate functions are present in the SELECT clause
PHP + PDO + MySQL: how do I return integer and numeric columns from MySQL as integers and numerics in PHP?
Using an IF Statement in a MySQL SELECT query
I want to vertical-align text in select box
How to select multiple rows from mysql with one query and use them in php
Where does MySQL store database files on Windows and what are the names of the files?
Rails has_many through form with checkboxes and extra field in the join model
How to insert array of data into mysql using php
Chart.js - Getting data from database using mysql and php
Python: function and variable with the same name
Function for week of the month in mysql
Using scanf and fgets in the same program?
How to set an option from multiple options or array with different values to views as selected in select box using PHP
MySQL query to select results with auto increment as a new column added in the result
Retrieving data with a hierarchical structure in MySQL
jQuery / Programmatically Select an Option in Select Box
Capturing HTTPS traffic in the clear?
How can I use a simple Dropdown list in the search box of GridView::widget, Yii2?
Retrieving Data from SQL Using pyodbc
How to create a grouped select box using simple_form?
What does selecting the largest eigenvalues and eigenvectors in the covariance matrix mean in data analysis?
What's the difference between “using” and “on” in table joins in MySQL?
Getting the value of the selected option tag in a select box
data.table joins - Select all columns in the i argument
Can’t pass data correctly to modal presentation using ForEach and CoreData in SwiftUI
PHP MYSQL dynamic select box
Selecting Non-existent Data With MySQL
Index in the Select projection
PHPMyAdmin alert box - missing value in the form - all usual fields are filled out?
Dynamic chained select box
How do you safely and efficiently get the row id after an insert with mysql using MySQLdb in python?
Why use softmax only in the output layer and not in hidden layers?
CodeIgniter/PHP/MySQL: Retrieving data with JOIN
Using the predict_proba() function of RandomForestClassifier in the safe and right way
How to hint the index to use in a MySQL select query?
What is the fastest way to load an XML file into MySQL using C#?
how to select element in multi select box in selenium webdriver
How do I change nesting function's variable in the nested function
Retrieving Data from JDBC Database into Jtable
How do I set a full date & time sql using java, and not just the date?
MySQL using Sum and Case
Get variable value from code behind and use in aspx page control
Is there any harm in using NPM and Yarn in the same project?
In R: pass column name as argument and use it in function with dplyr::mutate() and lazyeval::interp()
Populating a second select box depending of the first select box option
CSS - Border Radius for the drop down box when using the SELECT tag? Not the SELECT input ittself, the actual drop...
How to insert default data into table using import.sql file in Hibernate, MySQL Application
Using <select> and <option> in AngularJS
Why is MySQL returning the same results while using RAND() in the SELECT statement?
mysql: select, insert, delete and update in one query
Error: Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)
How do i connect mysql database and insert data into it using android code
Using QVTKWidget and QOpenGLWidget in the same UI?
How to set the default value of a select box using JQuery in IE9?
PhoneGap: It's possible to use only the phonegap.js and it's functions only in a Website (doesn't want an App only...
Populate select box from database using jQuery
django wizard, using form and formset in the same step
MySQL CHAR() Function and UTF8 Output?
Column invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
When to sanitize PHP & MySQL code before being stored in the database or when its being displayed?
Insert into database (mysql) using Ajax and PHP
retrieve data from mysql and email it
Removing Required Attribute from Class but MVC3 still won't post the form without a value in the text box
mysql binary comparison doesnt use index
MySQL: how to sort the words in a string using a stored function?
Export simple excel data into MySQL using PHP
Load, save and use of authentication data in Box Android API
Plot multiple box-plots using columns of dataframe in R
Retrieving Data with Jquery, AJAX, and PHP from a MySQL Database
Return collection from packaged function for use in select
Can you use MySQL @ session variables in the C# connector?
Running total over date range - fill in the missing dates
Using EF DbContext with mysql and sql in the same project
MySQL Rank in the Case of Ties
With Laravel Migration, How to change data type of a column and update its existing data to fit the new data type,...
1432 - Can't create federated table. The data source connection string %s is not in the correct format
Mysql: How can I use RTRIM in my LOAD DATA INFILE query?
SQL select from data in query where this data is not already in the database?
ng-selected is not working with ng-model in select box - Angularjs
Which loss function to use in Keras Sequential Model
JQuery select box focus problem in internet explorer
MySQL - Using JOIN and WHERE to determine average hours
How to use if/else condition in a select in mysql
Retrieving Data from MySQL - only logged in user
Is there a way to calculate time differences in MySQL using one select
Adding to a HTML text field by clicking items in a multiple select box
How to insert data into mysql using Java
Using Inner Join to determine the interval between specific records and related events in a table
Cannot retrieve data from MySQL using JSON and put them in a ListView with Fragments
R: Change value of an argument in ellipsis and pass ellipsis to the other function without using list() and eval()
Using Carthage and CocoaPods in the same project
Using Yii1 and Yii2 in the same project
Error using System.Data.Linq.Mapping and auto incrementing the primary key in a sqlite db
insert data into database using servlet and jsp in eclipse
MySQL get mindate and maxdate in one query
Not retrieving schema list from source when migrating from MSSQL to MySQL using Workbench
how to select and deselect all options in a select box
Angular 6 observables - extract data from .subscribe() function and use it elsewhere
Use of the identity function in JavaScript
Case Sensitive in Mysql using select where Query
MySQL - How to select Minimum AND Maximum in one (UNION) Query
Update mysql field using CONCAT and SELECT
Man In the Middle Attacks and SSL
Laravel MySQL how to order results in the same order as in whereIn clause
extern declaration and function definition both in the same file
How to apply a function to a subset of data.table using by and exposing all columns to the function?
My simple MySql query doesn't use index
How to select only fieldname when using show columns query in mysql
Mysql Select rows with same values in one column and different in another
SELECT in mysql using column number instead of name
How can I store the output of a query into a temporary table and use the table in a new query?
How to insert a CSV file data into MYSQL using Python efficiently?
MySQL Select only the redundant rows and leave out the original rows
How to insert array into mysql using PDO and bindParam?
Why is the dropdown box of SELECT tag shown at wrong place?
How to fetch the data from binary log file and insert in our desired table in MySQL?
Execute script based on which option is selected in a select box?
How to update a table using a select group by in a second one and itself as the data source in MySQL?
How to update HTML “select” box dynamically in IE
Ember: How to set controller model for use in select view
Pre Select an option in the select box in a modal depending on other selected value from another page
using value of enum in g:select when enum is attribute of selection object
How to set multiple columns in a data table to values from different columns in the same data table?
Is a friend function template defined in the class available for lookup? clang++ and g++ disagree
Is it possible to use the data.table index-join-assignment idiom to do a left join and assign NAs in the...
How do I access and use an entity using Core Data
How to legend a raster using directly the raster attribute table and displaying the legend only for class displayed...
how to use sum and condition in group using spring data mongodb aggregation
Is it possible to do HTML5 drag and drop in the Android browser?
data type to use in mysql for timezones
Function to check if the db value matches the current Select option
Ruby on Rails: Why a select box does not show the current object value?
Connecting codeigniter to mysql and oracle in the same application
dumping a mysql table to CSV (stdout) and then tunneling the output to another server
Retrieve data from MySQL using Node.JS in JSON format
I want to load image from the database into a picture box using LoadAsync and a MemoryStream
How to get Text and Value in element SELECT by #ID 100% AngularJS
Use data.table within another function in R
Connection Pool Issue with MySQL using Hibernate and Apache DBCP
Can I select full hierarchy of parents when id and parent id are in the same table?
SQL multiple SELECT query with xmlagg function- Data not pulled in the required fashion
Select a module using importlib and use in multiprocessing functions
Multiple select box is not working in rails
How to display JSON data in a select box using jQuery?
Best way to use a Scalar UDF that needs to appear in the Select and Where clauses
MySQL Query Select where id does not exist in the JOIN table
Automatic generation of record type based on MySql database tables, for use in FSharpDAL
Changing the value of Input field when user select option from select box
how to make quote of the day using php and mysql in order by id
How to connect Two Database MySQL and MongoDB in the same project? Is it possible?
Posting Form data to MySQL using nodejs w/ Express
Retrieving MySQL data dynamically and plotting on android using retrofit and MPAndroidChart
Save data into mysql from hive hadoop through sqoop?
How to use the --verbose flag in the MySQL 5.6 command line client?
#1411 - Incorrect datetime value for function str_to_date on INSERT INTO...SELECT
Which DBMS's allow an order by of an attribute, that is not present in the select clause?
select aggregate function and all other columns
How do I Return 0 From a MySQL db When the Term in the Where Clause is Not in the database?
Understanding the use of curly braces and "OJ" in a SQL query
How do I get the selected value from a select box, from inside an Iframe, and display it on the outside?
Show the tooltip in the list box selected value using jQuery
MySQL - Using COUNT and LIMIT functions together
Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY...
how to set a int value passed by parameter to a function and assign it to global so I can use outside of the function?
MySQL producing columns with loop in a select statement

Only authorized users can answer the Search term. Please sign in first, or register a free account.

Browse Other Code Languages