mr muddle i'm in trouble with arrays

emmahodd2

If i never see another array in my life, I would be happy. I am getting in a pickle with this: -

$countresult = mysql_query("SELECT SupplierID FROM suppliers WHERE Type = 'Paper' ORDER BY SupplierID");
$count = mysql_num_rows($countresult);  

echo $count;  

echo "spam";  

echo $countresult[0];  

echo "spam2";   

$supplier = DBquery("Select * FROM papertype WHERE SupplierID = '$countresult[0]'", $db);

right the count bit works fine, and tells me there are 5 records which there are. The problem is my $countresult[0]. What I am trying to do is select rows from the table papertype where the SupplierID equals the supplierID from the first row in $countresult.

Other notes: the supplierID is not sequential, I might not always want the 1st row, but the SupplierID from nth row.

Any help, would be appreciated.

Emma

OhLordy

Right, yo need to do a little more reading up on the MySQL API here but the problem you are having here is that you are not actually fetching the results at any point. mysql_query() performs the query on the MySQL server but does not actually fetch the results.

<?
$countresult = mysql_query("SELECT SupplierID FROM suppliers WHERE Type = 'Paper' ORDER BY SupplierID");
$count = mysql_num_rows($countresult);
echo("There are ".$count." results that match");
$first_row=mysql_fetch_array($countresult);
echo($first_row['SupplierID']);
$supplier=mysql_query("SELECT * FROM papertype WHERE SupplierID='".$first_row['SupplierID']."'");
?>

HTH
Rob

emmahodd2

Cheers for that. I did have a line like that commented! Was getting so confused.

I am still not sure though how to access the nth row, as I know its easy to get to the first one, but how would i go about accessing say th 4th one?

Bella Ciao
Emma

OhLordy

This is where I find arrays VERY usefull.

<?
$sql="select * from table";
$res=mysql_query($sql,$conn) or die(mysql_error());
while($row=mysql_fetch_array($res))
  $results[]=$row;
?>

This pulls all the results of the query into an array. then you can access the nth result with $results[$n]['row_name']; If you just want to display the results or something like that you may not need to put all the results into an array.
HTH
Rob