how do i check 2 fields

[richarro1234]

hey there,

 

im trying to cut down on the size of my database by checking for a users id in 2 collums of a database.

 

here is the code i have but for some reason it doesnt work?

 

<?php
$query12=" SELECT * FROM friends WHERE myid='$urid' and friendsid='$urid' LIMIT 5"; 
$result=mysql_query($query12) or die ('Error: '.mysql_error ());
$num=mysql_numrows($result) or die ('Error: '.mysql_error ());

$i=0;
while ($i < $num) {

$myid=mysql_result($result,$i,"myid");
$friendsid=mysql_result($result,$i,"friendsid");

$query10 = mysql_query("SELECT * from users WHERE id = $friendsid " );
while ($fr = mysql_fetch_array($query10)) {

$friendspic = $fr['picture'];
$friendsname = $fr['username'];
}
?>

 

that just comes back as "Error:" and doesnt show a message or anything.

 

Can someone please tell me how i can get this to work.

 

Thanks

Rich

[DeanWhitehouse]

get rid of the die on the mysql_num_rows

 

also try echoing $query12 to check if its correct, also try chaning the and to AND

[richarro1234]

it just shows up as "SELECT * FROM friends WHERE myid='1' AND friendsid='1' LIMIT 5 "

 

print_r($query12=" SELECT * FROM friends WHERE myid='$urid' AND friendsid='$urid' LIMIT 5"); 
$result=mysql_query($query12) or die ('Error: '.mysql_error ());
$num=mysql_numrows($result);

[DeanWhitehouse]

Hmm, and still just printing "Error: "

?

[richarro1234]

no, it doesnt show an error anymore it just shows up

SELECT * FROM friends WHERE myid='1' AND friendsid='1' LIMIT 5

 

but when i remove the print_r() it doesnt show anything (and its onviously meant to show the firends).