m3rajk — Sat, 06 Sep 2003 22:10:16 +0000

i use * because i use each part of the feild. it works perfectly now. thanks.

Mark Hensler — Sat, 06 Sep 2003 16:59:57 +0000

<?php
$friendfind = mysql_query(\"SELECT * FROM friends WHERE uid='$uin'\", $db); # get friends
if(mysql_num_rows($friendfind)==0) {
    $ferr='<h1>No Desires/Lusts Found</h1>'; # error on getting friends
}
else { # get the desires
    $ppl=mysql_num_rows($friendfind); # how many friends?
    $debug.=\"ppl : $ppl\";
    for ($i=0;$i<$ppl;$i++) { # for each friend
        $debug .= '<br />fetching desire';
        $desired[] = mysql_fetch_array($friendfind); # get the info
    }
    foreach($desired as $friend) { # for each friend
        $debug .= 'making desired'; // debug line
        /* break up the info */
        $fuid=$friend['fuid']; // friend's user id
        $frnd=$friend['fun']; // friend's username
        $cof=$friend['cof'];  // user's comment on friend
        $desires.=\"<tr><td><input type=\\"checkbox\\" name=\\"delf[]\\"\"
            .\"value=\\"$fuid\\"></td><td><a href=\\"profile.php?un=$frnd\\"\"
            .\"onClick=\\"alert('Your Comment on $frnd: $cof');\\"\"
            .\"target=\\"$frnd\\">$frnd</a></td></tr>\n\"; # make the display
    }
}
?>

Your sucking the entire recordset into memory. Not advised unless you need this data for later.

<?php
$friendfind = mysql_query(\"SELECT * FROM friends WHERE uid='$uin'\", $db); # get friends
if(mysql_num_rows($friendfind)==0) {
    $ferr='<h1>No Desires/Lusts Found</h1>'; # error on getting friends
}
else { # get the desires
    $ppl=mysql_num_rows($friendfind); # how many friends?
    $debug.=\"ppl : $ppl\";
    while ($friend=mysql_fetch_array($friendfind)) {
        $debug .= 'making desired'; // debug line
        /* break up the info */
        $fuid=$friend['fuid']; // friend's user id
        $frnd=$friend['fun']; // friend's username
        $cof=$friend['cof'];  // user's comment on friend
        $desires.=\"<tr><td><input type=\\"checkbox\\" name=\\"delf[]\\"\"
            .\"value=\\"$fuid\\"></td><td><a href=\\"profile.php?un=$frnd\\"\"
            .\"onClick=\\"alert('Your Comment on $frnd: $cof');\\"\"
            .\"target=\\"$frnd\\">$frnd</a></td></tr>\n\"; # make the display
    }
}
?>

m3rajk — Sat, 06 Sep 2003 16:20:01 +0000

<?php
$friendfind=mysql_query(\"SELECT * FROM friends WHERE uid='$uin'\", $db); # get friends
if(mysql_num_rows($friendfind)==0){
  $ferr='<h1>No Desires/Lusts Found</h1>'; # error on getting friends
}else{ # get the desires
  $ppl=mysql_num_rows($friendfind); # how many friends?
  $debug.=\"ppl : $ppl\";
  for($i=0;$i<$ppl;$i++){ # for each friend
  $debug.='<br />fetching desire';
  $desired=mysql_fetch_array($friendfind); # get the info
  }
  /* previously posted code */
}
?>

that's is, with where the other code is

Mark Hensler — Sat, 06 Sep 2003 02:53:47 +0000

From the 2nd quote, I can tell that your foreach() looping through a single record within a recordset. How can I tell? mysql_fetch_array() returns an array with both numeric and associative keys. That's why everything is repeating itself twice.

Copy & Paste the code that populates $desired. $desired can't be an array of associative arrays. It's simply the first record of the recordset.