warning with code

slimjim

My error :
Resource id #5
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site7/fst/var/www/html/clients/Downline.php on line 20
Line 20 is this :

//Line 20 is this
while ($mem_dat = mysql_fetch_row($tmp))
//
//and this is what temp is
$tmp = q("select * from members where user_id='$row1[1]'");

$ref_lv_1 = q("select * from referrals where referrer='$user[id]'");
$lv_1_num = mysql_affected_rows();
echo $lv_1_num." User(s) in your Downline...<br><br>";

echo $ref_lv_1;

echo "<table border='1' cellspacing='1' style='border-width: 2' bordercolor='#FFFFFF' width='462' id='AutoNumber1'>";

while ($row1 = mysql_fetch_row($ref_lv_1))
{
$tmp = q("select * from members where user_id='$row1[1]'");
while ($mem_dat = mysql_fetch_row($tmp))
	{
	echo "<tr>
	<td width='230'><font face='Tahoma' size ='2' bgcolor='#F5F5FA'>".$mem_dat[3]." ".$mem_dat[4]."</font></td>
	<td width='230'><font face='Tahoma' size ='2' bgcolor='#F5F5FA'>".$mem_dat[5]."</font></td>
	</tr>";
	};
};

Mordecai

Does the function q return the query data, or does it simply query? If it does not return the data, then $tmp will be boolean as to whether or not it was successful.

Try something like this:

function q($query) {
  $querytmp = mysql_query($query);
  return $querytmp;
}

slimjim

Ok I am going to try that once and see what happens..I will post in a few minutes.

slimjim

Nope didnt work
Problem is that mysql is not returning data like it is supposed to

Mordecai

If you replace the q() with mysql_query(), will it work?

Sorry I can't really test or finish this conversation right now, I've got to go to sleep. If no one's answered or you haven't found out by tomorrow, it'll be my first priority.

stolzyboy

i don't think you are using the q() correctly, use should use regular query/result/grabresult standards for something simple like this

slimjim

What I dont get is how a query can work 1 place and not another.

Not making sense to me at all.

The whole warning not making sense to me

stolzyboy

where are you executing mysql_query(), all i see when you do a query is q()

slimjim

i switched it all to mysql_query and i got the same results

slimjim

it wont start the loop through the rows of results.. not making sense to me.

slimjim

OK found the problem....Dumb dumb

no "user_id" in members...just "id" in the table......

Stupid

Thanks for all who helped.

No still havnt figured out the poll problem