I have a select statement that filter record with where clause like this

<?php
$dlines = mysql_query("SELECT NAME,USER_ID,REF_ID from members WHERE REF_ID='$m_uid'" or die(mysql_error());

//the $m_uid is the user id


while($m_row2=mysql_fetch_array($dlines,MYSQL_ASSOC)){
echo "<tr>";
//echo "<td><a href='admin_edit.php?name={$row['NAME']}'>{$row['NAME']}</a></td>";
echo "<td>{$m_row2['NAME']}</td>";
echo "<td>{$m_row2['USER_ID']}</td>";
echo "<td>{$m_row2['REF_ID']}</td>";
$duid =array($m_row2['USER_ID']);
// echo "<td><a href='delete.php?dlet={$row['USER_ID']}'><img src=", /img/jpg/dlete.jpg" width="30" height="30"/></a></td>";
echo "</tr>";
}

this script is working on my system but is not working online WHY?

each other way can i display downlines

What is the error it displays while you are online? That is the starting point to your debugging. Is it database version related or your syntax or PHP version? Deal with this first then we proceed from there.

No error message,
the mysql_num_rows() keep returning 0 (null) while there is record in the database.

other part of the page using the same database and table are working, so i dought if there is any problem with the database

the new user and the refferal are on the same table.
if there is another way i can display downlines, i.e the new user under the refferral i will also appreciate it

pagolina:

<?php
$dlines = mysql_query("SELECT NAME,USER_ID,REF_ID from members WHERE REF_ID='$m_uid'" or die(mysql_error());

//the $m_uid is the user id

did u initialize that variable($m_uid) at all, i mean did u assign a value to it cos i cant see that in ur code.

i have had similar problems in the past. One thing i usually do in this scenario is to echo out the MySQL query and enter it into
an online phpmyadmin and see what happens.

$sql = "SELECT NAME,USER_ID,REF_ID from members WHERE REF_ID='$m_uid'";
echo $sql;