[SOLVED] if statement

[Minase]

hmm for some reasons the if does not work well

 

function FriendsBringed() {

global $db;

$query = "SELECT * FROM `" . DBPREFIX . "users` WHERE `ID` = " . $db->qstr ( $_SESSION['user_id'] );
$row = $db->getRow ( $query );

if($row->Race == 1) {
$tkind = "Vampire(s)";
} elseif ($row->Race == 2) {
$tkind = "Werewolve(s)";
}

$finfo = mysql_query("SELECT * FROM `" . DBPREFIX . "users` WHERE `ID` = " . $db->qstr($_SESSION['user_id']));
while($rff = mysql_fetch_array($finfo)){
$ssl = $rff['Username'];
$selfriend1 = mysql_query("SELECT Username FROM " . DBPREFIX . "users where Friend='$ssl'") or die(mysql_error());
$selfriend2 = mysql_query("SELECT ID FROM " . DBPREFIX . "users where Friend='$ssl'") or die(mysql_error());
$ssc1 = mysql_query("SELECT Capture FROM " . DBPREFIX . "users WHERE Friend='$ssl'") or die(mysql_error());
$selfriend = mysql_num_rows($selfriend1);
echo $selfriend,' ',$tkind,' into being</td></tr>	';
while($ssname = mysql_fetch_array($selfriend1)) {
	$ssid = mysql_fetch_array($selfriend2);
	$ssc = mysql_fetch_array($ssc1);
	if ($selfriend == 0) {
		echo '</td></tr><tr><td colspan="2" class="tdn" align="center">none</td></tr>';
	} elseif ($selfriend > 0) {
		echo '</td></tr><tr><td class="tdn">- <a href="player.php?p=',$ssid[0],'" target="_top" class="headlines">',$ssname[0],'</a></td><td class="tdn">',number_format($ssc[0],0,",","."),'</td></tr>';
	} 

}
}

}

 

 

thats my whole function,but the if ($selfriend == 0) { blbalbla } doesnt work right

if records are higher than 0 the last 1 is working,but if records are 0 then the first echo will not work...

[conker87]

Try

if ($selfriend < 1) {

[Minase]

tryed that already still doesnt work  ???

[kenrbnsn]

When $selfriend is zero the while loop isn't executed, so the "if" statement never succeeds.

 

Ken

[conker87]

Try:

function FriendsBringed() {

global $db;

$query = "SELECT * FROM `" . DBPREFIX . "users` WHERE `ID` = " . $db->qstr ( $_SESSION['user_id'] );
$row = $db->getRow ( $query );

if($row->Race == 1) {
$tkind = "Vampire(s)";
} elseif ($row->Race == 2) {
$tkind = "Werewolve(s)";
}

$finfo = mysql_query("SELECT * FROM `" . DBPREFIX . "users` WHERE `ID` = " . $db->qstr($_SESSION['user_id']));
$selfriend1 = mysql_query("SELECT Username FROM " . DBPREFIX . "users where Friend='$ssl'") or die(mysql_error());
$selfriend = mysql_num_rows($selfriend1);
if ($selfriend == 0) {
echo '</td></tr><tr><td colspan="2" class="tdn" align="center">none</td></tr>';
} elseif ($selfriend > 0) {
while($rff = mysql_fetch_array($finfo)) {
	$ssl = $rff['Username'];
	$selfriend2 = mysql_query("SELECT ID FROM " . DBPREFIX . "users where Friend='$ssl'") or die(mysql_error());
	$ssc1 = mysql_query("SELECT Capture FROM " . DBPREFIX . "users WHERE Friend='$ssl'") or die(mysql_error());

	echo $selfriend,' ',$tkind,' into being</td></tr>	';
	while($ssname = mysql_fetch_array($selfriend1)) {
		$ssid = mysql_fetch_array($selfriend2);
		$ssc = mysql_fetch_array($ssc1);
		echo '</td></tr><tr><td class="tdn">- <a href="player.php?p=',$ssid[0],'" target="_top" class="headlines">',$ssname[0],'</a></td><td class="tdn">',number_format($ssc[0],0,",","."),'</td></tr>';
	} 

}
}

}

[Minase]

aha thank you kenrbnsn i did solve the problem ,put the fi statement with 0 above the while didnt know that ,good to know 

@conker87 your code is not complete and not working .

thanks for help guys