₦airaland Forum

im trying to select the amount column in the database table but i notice that it is skipping a row in the table, this is my code; Thanks.
$Amount_results = mysql_query("select `Amount` from transaction" or die("Can not select amount :" . mysql_error());
$result_list = array();
while($row = mysql_fetch_array($Amount_results))
{
$result_list[] = $row['Amount'];

}
foreach ($result_list as $amount) {
echo $amount ."<br />";
}

you seem to be making this more difficult than it should

here is what usually do

i have a file database.php which i include using require_once

$hostname_conn = "localhost";
$database_conn = "mydb"; 
$username_conn = "dbuser";
$password_conn = "dbpass";
$conn = mysql_connect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(),E_USER_ERROR);

function query($q){
	global $database_conn;
	global $conn;
	mysql_select_db($database_conn, $conn);
  	$result = mysql_query($q, $conn) or die(mysql_error());
	return $result;  
}

then in all your codes, you will be able to code less

for the above, we just have something like this

require_once( "functions/database.php" ); #include the header file

$r_amount=query("select `Amount` from transaction"; #the query, now nice and neat

while($row_amount=mysql_fetch_assoc($r_amount){ 
echo $row_amount['Amount']."<br />";
}

i always like fetching the resource as an associative array, you are able to use the name to call it instead of the index which can change when you modify your database structure.

@ webdezzi, thanks...