Or Die

[Haktar]

Hi, i have this on my website but i must have it wrong, what i need is $usercommander to equal what is in the field unless the field is empty then it should equal None.

$usercommander=mysql_result(mysql_query("SELECT username FROM users WHERE id='$r[commander]'"), 0) or die("None"); 

but i get this error

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 5 in /home/*****/public_html/profile.php on line 100
None

[drew010]

well, if there are no results, it will not be able to jump to row 0, since there is no row 0, which is what is happening.

the following will work

$res = mysql_query('your query');
if (mysql_num_rows($res) == 0) {
  die('none');
}

[devinemke]

$usercommander = 'none';
$result = mysql_query("SELECT username FROM users WHERE id = '" . $r['commander'] . "'") or exit(mysql_error());
if (mysql_num_rows($result))
{
	$value = mysql_result($result, 0);
	if ($value) {$usercommander = $value;}
}

[Haktar]

ahh, 😃 thanks very much guys