Forum

Cod: Selectaţi tot

<?php
ERROR_REPORTING(E_ALL | E_STRICT);
if (!session_is_registered('email')){
header("location: ../../login.php");
}

include("../../config.php");

mysql_connect("$db_host", "$db_user", "$db_pass") or die(mysql_error());
mysql_select_db("$db_name") or die(mysql_error());

if(!isset($_GET['nr'])){ 
    $nr_friend = "10";
} else { 
    $nr_friend = $_GET['nr'];
} 

if(!isset($_GET['by'])){ 
    $by = "ASC";
} else { 
    $by = $_GET['by'];
} 
 
$select = mysql_query("SELECT * FROM friends WHERE friend_with = '".$_SESSION["email"]."' AND accept = '1'ORDER BY '$by' 

LIMIT '$nr_friend' ");
$rows = mysql_num_rows($select);

echo "<center>";
echo '<h2> My Friends (<font color="red"> '.$rows.' </font>)</h2>';
echo "</center>";

while ($afis = mysql_fetch_assoc($select)){

$select2 = mysql_query("SELECT * FROM users WHERE email = '".$afis["invite_by"]."' ORDER BY '$by' LIMIT '$nr_friend'");

while ($afis2 = mysql_fetch_assoc($select2)){

if ($rows == 0){
echo "You don't have any friend";
}
else{

echo '<table>
<tr>

<td><font size="1pt"><a href="../profile.php?uid='.$afis2['id'].'"><img src="../../'.$afis2['avatar'].'" width = "100" height 

= "100" /></a></font></td><td align="left"><font size="5">'.$afis2['first_name'].' '.$afis2['last_name'].'<br>'.$afis2

['age'].' years hold <br> '.$afis2['country'].' <br> Bio: '.$afis2['description'].'</font></td>
</tr><tr>
<td><font size="1pt"></font></td><td align="right"></td>
</tr><tr>
<td align="center" colspan="2">
<br>
</tr>
</table>';
echo "<br />";
echo "<br />";

}
}
}
?>

Cod: Selectaţi tot

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/hosting/gamestime/4friends.hi2.ro/account/friends/friends.php on line 116

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/hosting/gamestime/4friends.hi2.ro/account/friends/friends.php on line 122

Cod: Selectaţi tot

while ($afis = mysql_fetch_assoc($select)){

Cod: Selectaţi tot

$rows = mysql_num_rows($select);

Cod: Selectaţi tot

$sql = "SELECT `rand` FROM `tabel` WHERE 'conditie'";
$result = mysql_query($sql);
// daca exista eroare, o afiseaza, altfel, prelucreaza datele primite
if (mysql_errno()) echo 'Eroare: '. mysql_error();
else {
  $rows = mysql_num_rows($result);
  // daca sunt randuri returnate, le proceseaza. Altfel, 0 randuri
  if($rows>0) {
    while ($rand = mysql_fetch_assoc($result)) {
      // prelucrare
    }
  else echo '0 randuri returnate';
  }
}
 

Cod: Selectaţi tot

echo $sql;

Cod: Selectaţi tot

SELECT * FROM friends WHERE friend_with = 'klaus.clau.56@gmail.com' AND accept = '1' ORDER BY asc

Cod: Selectaţi tot

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'asc LIMIT 0, 30' at line 1

Cod: Selectaţi tot

SELECT * FROM `friends` WHERE `friend_with`='klaus.clau.56@gmail.com' AND `accept`=1 ORDER BY `friend_with` ASC