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.
"exact phrase" include -exclude
will give you more specific results
will give you more specific results
How to make SQL SELECT query [1/2]
|
<?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 |
|
- How to make SQL SELECT query [1/2] - | |
RECOMMENDED TUTORIALS
Need a specific tutorial? Do not hesitate and submit a request!