Networking, Programming and Graphics Tutorials
Home >> Applications >> Database Servers >> MySQL >>

Using MySQL APIs in PHP to make SELECT query from database [1/2]

Type: Code Networking, Programming and Graphics Tutorials
Using MySQL APIs in PHP to make SELECT query from database
Level: Beginner Networking, Programming and Graphics Tutorials 
Using MySQL APIs in PHP to make SELECT query from database
Date: 2007-Apr-02
Using MySQL APIs in PHP to make SELECT query from database
Visited: 1198 times
Using MySQL APIs in PHP to make SELECT query from database
Rating: Using MySQL APIs in PHP to make SELECT query from database
Using MySQL APIs in PHP to make SELECT query from database
Author: Ivory Morhuld

This tutorial will show you how to use MySQL querys to database in your PHP scripts.

mysql_query(query, [link_identifier])


mysql_query() sends a query to the currently active database on the server that's associated with the specified link identifier. If link_identifier isn't specified, the last opened link is assumed. If no link is open, the function tries to establish a link as if mysql_connect() was called with no arguments, and use it.

In next examples we will teach you how to make more querys.

<?php
$quety="select * from table";
$result=mysql_query($query);
?> 
Above example will return you:

ID Name Sex Age
1 John Smith Male 33
2 Barbara Roland Female 28
3 Kate Winston Female 22
4 Peter Trump Male 46
5 Andrea Gilbert Female 37
Networking, Programming and Graphics Tutorials - Using MySQL APIs in PHP to make SELECT query from database [1/2] - Networking, Programming and Graphics Tutorials

Need a specific tutorial? Do not hesitate and submit a request!
Related Tags: mysql php database select query  how to make select query in mysql  php using ajax to select query database  ajax query database select  how to make a php query to a database  how to make database query php  php mysql search Select * database where  select database dropdownlist + mysql  mysql select database script  ajax mysql select from database