Layouts
Div «
Frames «
Tables «
New additions «
Sort by Series «
How to Use «

Signs
Enter «
Hiatus «
Moved «
Welcome «

Downloads
Bookmarks «
MSN Display Pictures «
Templates «
Transparent PNGs «

Tutorials
Articles «
Cute News «
Misc. «
PHP and MySql «
Photoshop «
Tables «

Affiliates

Beloved-Melody «
Bouncing-Kitten Designs «
Final Summoning «
Lunar Bliss Graphics «
Starry Night «
Affiliation «

 The basic connection strings to display a table are as follows:

<?php $hostname="localhost";
$user="xxx";
$pass="xxx";
$dbase="xxx";
$connection = mysql_connect("$hostname" , "$user" , "$pass");
$db = mysql_select_db($dbase , $connection);

$q = "select * from `dbasename` where type='norm' order by id asc ";
$result= mysql_query($q, $connection) or die
("Could not execute query : $q." . mysql_error());

Explanations:
$hostname="localhost"; this is the name of the host, and is called localhost most of the time.
$user The username we made in the first tutorial.
$pass The password we made in the first tutorial.
dbase Name of the database.
$q = "select * from `dbasename` where type='norm' order by id asc "; dbasename is the name of your database where type=norm is whatever you want SQL to sort by. For instance, if I wanted to display Inuyasha PNGs, I would type in something like series=Inuyasha and it would only display Inuyasha PNGs! Continuing with our code, this will display your data in a template:

while ($row=mysql_fetch_array($result))
{
$id=$row["id"];
$anime=$row["anime"];
$type=$row["type"];
echo"ID: $id<br>
Anime: $anime<br>";
}
?>

Note that you cannot have "stuff within two quotes like this" without adding it like \"stuff within quotes\" within your echo.

The above code will generate:
ID: 1
Anime: Inuyasha

ID: 2
Anime: Shaman King etc.

The type is hidden and we do not have to display it, but in your coding you should have it if you wanted to sort specific things.

Le gasp! You are now done making your first database and displaying the information within its tables! Have fun with MySQL!

Graphics
Terms of Use «
Avatars «
Backgrounds «
Blinkies «
Buttons «
Forum Banners «
Wallpapers «
Submit! «

Website
Main «
Set as homepage «
Add to favorites «
Apply for Staff «
Contact Us «
Credits «
Link Us «
Staff «

Vote for us!
Honey Vanity «

Sponsors
Beloved-Melody «
Kyuusho «

Status
eXTReMe Tracker
Extreme Tracker «
fragile beings «

38.103.63.17 «