Loop problem

[phpdeano]

I have the following code which should work as follows.

I have a table called "access" which holds login details for every user. Each user is assigned to a customer reference, therefore there can be several lines in the table that have the same customer reference as they are different users who access the same account.

I need to be able to produce a list of active accounts based upon the first two letters of the customer reference. The purpose of this is to allow the individuals who sell the accounts to see how their customers are performing.

Each account is based upon 2 letters followed by 4 numbers, ie:
xx8888

The script works so far as it tels me how many unique rows there are but it prints out the same reference each time.

$channelref = substr($custref, 0, 2);
echo "Channel ref - ",$channelref,"<br>";
 $sql = "Select DISTINCT access.custref from access where custref like '%$channelref%' group by custref";
 // run SQL against the DB
 $result = mysql_query($sql)
 or die("Search failed");
 $number = MYSQL_NUMROWS($result);
echo "Number of rows - ",$number,"<br>";
for($i=0;$i<$number;$i++) {
echo "References are - ",$myrow['custref'],"<br>";
}

For example the table has 5 entries:

tr0000
tr0000
tr0000
tr0001
tr0002

However the results printed show

tr0000
tr0000
tr0000

Any help greatly appreciated.

[tekky]

try

while($row = mysql_fetch_assoc($result))
{
    //do this code here with the returned rows;
}

btw: its mysql_num_rows($result) not MYSQL_NUMROWS() 😉

[phpdeano]

Thanks, but ......

I have tried both options and still the same result.

I suspect the problem relates to my SQL query, but I have looked through the manual and cannot work out where the problem is.

The results I get with the script is:

Channel ref - se
Number of rows - 2
References are - se0000
References are - se0000

Therefore it correctly detects there are only two "se" records (se0000 and se0001) but then returns se0000 twice.

I am very confused.

[phpdeano]

Please ignore the last post as I was being a little dumb and not thinking things through.

The suggestion solved the problem, just need to solve the next "fifty" problems.🙁

Thanks for your help

[tekky]

increment a number by 1 each time you call t he query then use

LIMIT $count*50, 50

this will give you the next 50 starting AT the first record number of $count*50