Array Function

[bajer]

Information stored in MySQL;
A B C D E F

I just want to use A C E F fields from DATABASE / row

this would be easy if I would display information one after another like in tables, etc

but I need to use information all over the place, so I probably need to somehow store it in array, except i'm NEWBIE 🙂

one place I would put : $A[4]
another place : $C[4]
and so on...
but keep in mind that I want to display last 6 rows from database; that's why we would have $A[0], $A[1], $A[2], etc

I hope I explained this well enough...
Thanks for your help...

[laserlight]

look up [man]mysql_fetch_array/man and related functions.

[tomhath]

Here's an example:

<?php
$con = mysql_connect() or die (mysql_error());
mysql_select_db('test', $con) or die (mysql_error());

$query = mysql_query("select ID, Name From test order by ID") or die (mysql_error());

?>

<table border="1"><th>ID</th><th>Name</th>

<?php
while ($row = mysql_fetch_array($query) ) {
    echo '<tr><td>' . $row['ID'] . '</td><td>' . $row['Name'] . '</td></tr>';
    $Name[$row['ID']] = $row['Name'];
}
?>
</table>

<B> A couple of values we stored:<BR>
<PRE>
<?php
print_r($Name);
?>
</PRE>

[bajer]

Got it working.....thank you for your script, it game me IDEAS!

Here is what i managed to do for other people in case they need it.

$querypias = mysql_query("SELECT invoice,date,amount,paid FROM `pginvoice` WHERE addressid='1' ORDER BY `invoice` DESC LIMIT 0, 6 ") or die (mysql_error());

$a = '1';
while ($row = mysql_fetch_array($querypias)) { 
    $invoicepias[$a] = $row['invoice']; 
	$datepias[$a] = $row['date'];
	$amountpias[$a] = $row['amount'];
	$paidpias[$a] = $row['paid'];
	$a = $a + 1;
} 
?> 

<?php 
print_r($invoicepias); 
print_r($datepias); 
print_r($amountpias); 
print_r($paidpias); 

echo "<P>$invoicepias[1] | $datepias[1] | $amountpias[1] | $paidpias[1]";
echo "<P>$invoicepias[2] | $datepias[2] | $amountpias[2] | $paidpias[2]";
echo "<P>$invoicepias[3] | $datepias[3] | $amountpias[3] | $paidpias[3]";
echo "<P>$invoicepias[4] | $datepias[4] | $amountpias[4] | $paidpias[4]";
echo "<P>$invoicepias[5] | $datepias[5] | $amountpias[5] | $paidpias[5]";
echo "<P>$invoicepias[6] | $datepias[6] | $amountpias[6] | $paidpias[6]";

?>