answersLogoWhite

0


Best Answer

Here is a simple method for connecting to your MySql database and outputting some data. <?php #Connect to MySQL database

$db=mysql_connect("localhost","YourDatabaseUserName","YourDatabasePassword");

mysql_select_db("YourDatabaseName",$db) or die ("cant change"); #Select data from database table called customers.

$result = mysql_query("select * from customers Order By LastName, FirstName",$db); while ($row = mysql_fetch_array($result))

{

$FirstName = $row["FirstName"];

$LastName = $row["LastName"]; echo "$LastName, $FirstName"; ?><br><? } ?>

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you get data from database when you pick up item from database list?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the item id for a diamond pick in minecraft?

The item ID for a diamond pick in Minecraft is 278. I have linked you below in the related links of a full list of all the ID's in Minecraft.


Which fact regarding radiation symptons is correct?

If you want me to pick the correct item from a list of choices for you, you'll have to let me see the list.


How do you unlock spirit bomb on dragon ball z raging blast?

go to the item list in ultimate customization and pick everyone's spirit.


How do you construct a graph using landmarks?

Graphs are more to present data. For example, if you wanted to organize and list mountains by their heights. You would need to mentally organize your data, or put each item on an index card so you can move them around to organize the data. Then, pick the type of graph you need to use to best represent the data you have.If you mean construct an image or a depiction, it would be like any other drawing, with or without labels.


Which shows the correct expanded form of 2.109?

You're looking at a list, and you can't decide which item on it is the correct one. But you expect me to pick the correct one without even seeing the list. That doesn't compute.


How do you make a list in alphabetical order on neo office?

If you want to sort a spreadsheet, choose the column/line or just a part of it, then pick Data, choose Sort and pick either ascending or descending.


What is Autofilter in Microsoft Excel?

The Autofilter function looks at all the contents in a column and allows you to select only those entries you want to see. It provides a drop down list containing one copy of each of the different values. You can then select which ones you want to see by clicking on the values in the drop down list.


How do you decide when to use Excel or Access database program?

You would use Access when you want to create a database. A database is a file full of organised data. It is a structured set of records comprising a large amount of data or information, which is usually related. It can be a Manual Paper Work collection or Electronic Computer Data. A database is a collection of records organized so that data can be easily retrieved. When you want to deal with lists of data and be able to organise it and retrieve information, that is when you would use Microsoft Access or another database application.Excel is for creating spreadsheets. Spreadsheets are used for numerical analysis and manipulation. When you have a lot of numbers and you want to do calculations on them, then it is best to use a spreadsheet. It also allows you to do things like create charts and to try different combinations of numbers to see what the effects are of having different values, like how much a company can make if they were to increase the amount of their products that they manufacture and sell.There are things that both a spreadsheet and a database can do. You can use a spreadsheet to do some databasing operations and you can use a database to do some spreadsheet operations, but you would pick the one that is most suited to the task you want to do. If you are mostly dealing with numbers and doing lots of calculations, it is usually best to use a spreadsheet. If you are dealing with lists of data, like a list of people's names and addresses, then it is best to use a database.


What is the purpose of look up column in MS Access?

A lookup can be used to either look up data from field in another table or from a pre-defined list. So for example, you could have a list of different marital status settings for people to pick from, or you could want something from a list of departments that are held in another table. Having them in lookups gives the user more control and reduces the chance of them making errors, such as spelling when entering data. If there is only a set amount of values, then it is easier to set up a lookup list. You could not do it for something like dates of birth because there are so many of them, but you could do it for something like the departments in a company as there is a specific set of them in a company that you could be doing the database for.A lookup can be used to either look up data from field in another table or from a pre-defined list. So for example, you could have a list of different marital status settings for people to pick from, or you could want something from a list of departments that are held in another table. Having them in lookups gives the user more control and reduces the chance of them making errors, such as spelling when entering data. If there is only a set amount of values, then it is easier to set up a lookup list. You could not do it for something like dates of birth because there are so many of them, but you could do it for something like the departments in a company as there is a specific set of them in a company that you could be doing the database for.A lookup can be used to either look up data from field in another table or from a pre-defined list. So for example, you could have a list of different marital status settings for people to pick from, or you could want something from a list of departments that are held in another table. Having them in lookups gives the user more control and reduces the chance of them making errors, such as spelling when entering data. If there is only a set amount of values, then it is easier to set up a lookup list. You could not do it for something like dates of birth because there are so many of them, but you could do it for something like the departments in a company as there is a specific set of them in a company that you could be doing the database for.A lookup can be used to either look up data from field in another table or from a pre-defined list. So for example, you could have a list of different marital status settings for people to pick from, or you could want something from a list of departments that are held in another table. Having them in lookups gives the user more control and reduces the chance of them making errors, such as spelling when entering data. If there is only a set amount of values, then it is easier to set up a lookup list. You could not do it for something like dates of birth because there are so many of them, but you could do it for something like the departments in a company as there is a specific set of them in a company that you could be doing the database for.A lookup can be used to either look up data from field in another table or from a pre-defined list. So for example, you could have a list of different marital status settings for people to pick from, or you could want something from a list of departments that are held in another table. Having them in lookups gives the user more control and reduces the chance of them making errors, such as spelling when entering data. If there is only a set amount of values, then it is easier to set up a lookup list. You could not do it for something like dates of birth because there are so many of them, but you could do it for something like the departments in a company as there is a specific set of them in a company that you could be doing the database for.A lookup can be used to either look up data from field in another table or from a pre-defined list. So for example, you could have a list of different marital status settings for people to pick from, or you could want something from a list of departments that are held in another table. Having them in lookups gives the user more control and reduces the chance of them making errors, such as spelling when entering data. If there is only a set amount of values, then it is easier to set up a lookup list. You could not do it for something like dates of birth because there are so many of them, but you could do it for something like the departments in a company as there is a specific set of them in a company that you could be doing the database for.A lookup can be used to either look up data from field in another table or from a pre-defined list. So for example, you could have a list of different marital status settings for people to pick from, or you could want something from a list of departments that are held in another table. Having them in lookups gives the user more control and reduces the chance of them making errors, such as spelling when entering data. If there is only a set amount of values, then it is easier to set up a lookup list. You could not do it for something like dates of birth because there are so many of them, but you could do it for something like the departments in a company as there is a specific set of them in a company that you could be doing the database for.A lookup can be used to either look up data from field in another table or from a pre-defined list. So for example, you could have a list of different marital status settings for people to pick from, or you could want something from a list of departments that are held in another table. Having them in lookups gives the user more control and reduces the chance of them making errors, such as spelling when entering data. If there is only a set amount of values, then it is easier to set up a lookup list. You could not do it for something like dates of birth because there are so many of them, but you could do it for something like the departments in a company as there is a specific set of them in a company that you could be doing the database for.A lookup can be used to either look up data from field in another table or from a pre-defined list. So for example, you could have a list of different marital status settings for people to pick from, or you could want something from a list of departments that are held in another table. Having them in lookups gives the user more control and reduces the chance of them making errors, such as spelling when entering data. If there is only a set amount of values, then it is easier to set up a lookup list. You could not do it for something like dates of birth because there are so many of them, but you could do it for something like the departments in a company as there is a specific set of them in a company that you could be doing the database for.A lookup can be used to either look up data from field in another table or from a pre-defined list. So for example, you could have a list of different marital status settings for people to pick from, or you could want something from a list of departments that are held in another table. Having them in lookups gives the user more control and reduces the chance of them making errors, such as spelling when entering data. If there is only a set amount of values, then it is easier to set up a lookup list. You could not do it for something like dates of birth because there are so many of them, but you could do it for something like the departments in a company as there is a specific set of them in a company that you could be doing the database for.A lookup can be used to either look up data from field in another table or from a pre-defined list. So for example, you could have a list of different marital status settings for people to pick from, or you could want something from a list of departments that are held in another table. Having them in lookups gives the user more control and reduces the chance of them making errors, such as spelling when entering data. If there is only a set amount of values, then it is easier to set up a lookup list. You could not do it for something like dates of birth because there are so many of them, but you could do it for something like the departments in a company as there is a specific set of them in a company that you could be doing the database for.


Which of these numbers will divide into both 68 and 80 with no remainder?

The common factors of 68 and 80 are 1, 2, and 4 . Next time you ask me to pick the correct item from a list of multiple choices for you, I'm going to expect you to show me the list.


How long do you have to press a in order to pick up a item from the ground in Pokemon pearl?

It's not long at all, it's an automatic pick up if there's an item on the ground.


What uses radio waves to tansmit data signals over short distances and does not need a direct line of sight?

When you ask somebody to pick out the correct answer for you from a list, it would be just plain common courtesy to let him see the list.