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: 1077 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 to make 1 query for 2 database  mysql php database select query  mysql how to make a select query php  how to make select query in mysql  database query php WHERE SELECt fROM  mysql select database script  no database select mysql en script de php  php mysql search Select * database where  select database dropdownlist + mysql  ajax mysql select from database  query a mysql database with php  Query Remote MySQL Database using PHP  updating a mysql database using a query in php  php script to query mysql database  update query in mysql database php  ajax query mysql database php  how to update mysql database using query  PHP make the query - select  make 2 select in one query in php  how to make a select query in php