starting index in array

mduran

Hi,

I have a script where I print some texts collected by users and logged into a MySQL table, the user information is just a user_number code (1,2,3...) that references another table, with their email addresses. So what I do is get user_number and user_email from the second table and array it:

<?
$users = mysql_query("select user_number,user_email from auth_user");
while ($column = mysql_fetch_array($users)) $user[] = $column['user_email'];

Later on, i try to print the email address using the array with the user_number as index:

$collector is the variable where I stored the user_number code from the first table. The "-1" is obviously there because the first element of $user is indexed as 0.

for some bizarre reason I get it right for some entries, but for some others it displays the email address corresponding to the PREVIOUS user in sorted order. Can anye explain me this ?

Is there some way to use mysql_fetch_array starting by index [1] ?

Is there some more efficient way to make all this ?

I guess it all comes down to handling foreign keys in MySQL via PHP... could anyone help me ?

infinite thanks.
Miguel

trexx

here's a more common way to loop through a result set:

$rs = mysql_query("select user_number,user_email from auth_user"); 
while( $row = mysql_fetch_array($rs) )
{
	echo $row['user_email']."<br>\n";
}

mduran

Thanks for your reply, trexx.

...but this is not exactly what I want to do:

I want to be able to get the data of both columns (user_number, user_email) into one array that starts with index [user_number] (so, usually 1).
I want to be able to punctually access / print an email address of this array (so not print all of them) whose element number is the id from another table, which I previously stored in a variable.

I don't even know whether I should use mysql_fetch_array or any other command for this (perhaps mysql_fetch_object ?)

thanks,
miguel

trexx

you already have both columns in the array =) look at this:

$rs = mysql_query("select user_number,user_email from auth_user"); 
while( $row = mysql_fetch_array($rs) )
{
    echo $row['user_number']." ".$row['user_email']."<br>\n";
}

you could access certain elements of the result set with that:
http://www.php.net/manual/de/function.mysql-data-seek.php

but if you only want to display a certain user it would be properly done by a sql-query.

SELECT * FROM auth_user WHERE user_number=$userNumber

use mysql_fetch_array if you want both, associative and numeric indexes. mysql_fetch_assoc is associative only, mysql_fetch_row, numeric only.