|
|
| Display Records [+] Favor-It | |
| |
 |
| | Sort By:
|
So far we have seen a couple different uses of PHP's mysql_query function. This is to be expected as nearly all MySQL in PHP is done through the MySQL Query function. We have created a new table and inserted data into that table. Author: Tizag Code: PHP 4.0 |
There isn't any Fetch Array function in MySQL. mysql_fetch_array is actually a PHP function that is used in PHP scripts when interacting with a MySQL database. If you have been jumping around our MySQL Tutorial. Author: Tizag Code: PHP 4.0 |
In a previous lesson we did a SELECT query to get all the data from our "example" table. If we wanted to select only certain entries of our table, then we would use the WHERE keyword. Author: Tizag Code: PHP 4.0 |
| | |
It would be nice to be able to make MySQL results easier to read and understand. A common way to do this in the real world is to order a big list of items by name or amount. The way to order your result in MySQL is to use the ORDER BY statement. Author: Tizag Code: PHP 4.0 |
Following examples teaches how to query a mySQL database and getting results in pages. Every page displays results maximum 10 results in a single page.
Author: Site Editor Code: PHP 4.0 |
Learn a quick and easy way to display information from a mySQL database. This tutorial goes along with several others that use the same news database such as Add a Row to mySQL, Deleting a Row, and Edit a Row In mySQL. Author: Akash Goel Code: PHP 4.0 |
Random MySQL Rows is a simple tutorial that will explain the used of the rand function in PHP. Great for someone who need things selected randomly, like for a lottery, or a dice game. Author: Daniel Neri Code: PHP 4.0 |
| | |
There are simply to show data records in table rows, just one record by one table row but sometime you need to show data records more than one record in one row. This tutorial show you how can to show your data records in the table with three columns. Author: PHPSimple Code: PHP 4.0 |
Put records from your database in a drop down menu/list box. You can apply it as a navigator list box. Good for saving your webpage areas or you have many links you don't want to show all of them in your pages. Author: PHPSimple Code: PHP 4.0 |
Icon Key >
 - Recently Updated
 - Showcase Listing
|