Rows,
Posted: Tue Jun 24, 2003 6:11 am
Hey,
I've been having some problems with a .php script, my first one ever
. What I wan't to have is a script which displays the infomation from a sql database. I am able to do this, but I want to display one row at a time. At the moment it just lists the data.
Anyway here is the code so far.
Any help would be appreciated
-Rory
I've been having some problems with a .php script, my first one ever
Code: Select all
<?
//MySQL Variables. $host = "localhost";
$login_name = "*****";
$password = "******";
MySQL_connect("$host","$login_name","$password");
MySQL_select_db("knockou_knockout") or die("Could not select database");
$query = "SELECT * FROM subscribe";
$result = MySQL_query($query);
While($rows = MySQL_fetch_array($result) ) {
$Clan = $rowsї'Clan'];
$Amount = $rowsї'Amount'];
$Accepted=$rowsї'Accepted'];
echo("$Clan, $Amount, $Accepted ");
}
MySQL_close()
?>-Rory