Posted By

DesignByWilliam on 08/12/10

Tagged

mysql
php

Versions (?)

Last Edited at 08/12/10 04:32am

Statistics

Viewed 806 times

Favorited by 0 user(s)

Related snippets

PHP MYSQL CONNECT

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

<?php
$user="";
$password="";
$database="";
mysql_connect(localhost,$user,$password);
 
@mysql_select_db($database) or die( "Unable to select database");
 
$query="SELECT * FROM law_projects";
$result=mysql_query($query);
 
$num=mysql_numrows($result);
 
mysql_close();
 
 
echo "<b><center>Database Output</center></b><br><br>";
 
$i=0;
while ($i < $num) {
 
$city=mysql_result($result,$i,"city");
 
echo "<b>$city</b><br>";
 
$i++;
}
 
?>