PHP Help [Archive] - HabboxForum

Lysine

11-09-2006, 10:39 PM

I keep getting this error ; Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 10 in /home/hablaugh/public_html/djpanel/Panel/appstatus.php on line 83

And this is the code ;
<? session_start();

include 'dbConfig.php';

$ip = $_SERVER['REMOTE_ADDR']; //get the ip of the current user

if(!isset($_SESSION['session_username']) || empty($_SESSION['session_username']) || $ip!= $_SESSION['session_ip']) {

//if the username is not set or the session username is empty or the ip does not match the session ip log them out

session_unset(); //clears firefox

session_destroy(); //clears IE

die("Hmm I Wonder Why You Have Ended Up Here :S"); }

include("online.php");

?>

<?

if (isset($_POST['changeStatus'])) {

$getchangeStatus = $_POST['changeStatus'];

mysql_connect($host,$user,$pass) or die("Error: Cannot connect to database.");

mysql_select_db($db) or die("Error: Cannot select database.");

mysql_query("UPDATE application SET Status='$getchangeStatus'");

mysql_close();

echo "<meta http-equiv=\"Refresh\" content=\"0; URL=appstatus.php\">";

}

mysql_connect($host,$user,$pass) or die("Error: Cannot connect to database.");

mysql_select_db($db) or die("Error: Cannot select database.");

$getStatussql = mysql_query("SELECT Status FROM application") or die("Error: Cannot execute query.");

$getStatus = mysql_result($getStatussql, "Status");

mysql_close();

?>

<? if($session_level == "1") { ?>

<?

if($session_username == 'Lysine' OR $session_username == 'Lysine'){

echo "

<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>

<html xmlns='http://www.w3.org/1999/xhtml'>

<head>

<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1' />

<title>Radio Application Status</title>

<link type='text/css' rel='stylesheet' href='request.css' />

</head>

<body>

<table width='500' border='0' align='center' cellpadding='0' cellspacing='0'>

<tr>

<td height='12' valign='top'><div align='center'>

<form name='changedjsays' method='post' action='appstatus.php'>

Aloha!, The current Job Application Status is: $getStatus

 

Turn the website (Note The First Option Is The Current Status): 

<select name='changeStatus'>

<option>$getStatus</option>

<option>Online</option>

<option>Offline</option>

</select>

<input type='submit' name='Submit' value='Submit' />

</form>

</div></td>

<div align='center'>

<center>

<table border='1' width='473' height='18' style='border-collapse: collapse' bordercolor='#000000'>

<tr>

<td height='18' width='473'>

Some useful HTML tips to

use!</td>

</tr>

<tr>

<td height='18' width='473'>

  Bold Text </td>

</tr>

<tr>

<td height='18' width='473'>

  

 

Break line

(New line)</td>

</tr>

<tr>

<td height='18' width='473'>

  Underlined

text </td>

</tr>

<tr>

<td height='18' width='473'>

 Italic Text 

</td>

</tr>

<tr>

<td height='18' width='473'>

Horizontal line: 

<hr><hr width='20'></td>

</tr>

<tr>

<td height='18' width='473'>

 Cheese 

 - Also Italics</td>

</tr>

<tr>

<td height='18' width='473'>

  Makes the font like this! </td>

</tr>

<tr>

<td height='55' width='473'>



 Makes the font this

size 

 

~ Note: The font size tag can be used with the

font face tag EG: 

 

Also, you MUST use the American spelling of

color for the font tags</td>

</tr>

<tr>

<td height='17' width='473'>

  Bold Text </td>

</tr>

<tr>

<td height='18' width='473'>



</td>

</tr>

</table>

</div>

</tr>

</table>

</body>

</html>";

}else{

die ("Only certain admins can view this page");

}

?>

<?

}else{

die ("Only Admins Can View This Page");

}

?>

Dentafrice1

11-09-2006, 10:42 PM

Is there a row in that table?

Lysine

11-09-2006, 10:48 PM

Is there a row in that table?

I dunno. You made the DJ Panel.

Lysine

11-09-2006, 10:50 PM

Sorry for double post.

Dentafrice1

11-09-2006, 10:51 PM

That might be why. Go into PHPMyAdmin and insert a blank row with the ID of 1 then go back to that page

Caribic

12-09-2006, 01:20 AM

I need a Domain and Host for my mate Im paying for him like :@ Lol Im looking for buy one for

5 HC's - domain and host anybody intrested in selling me one?

Motion

12-09-2006, 06:26 AM

Caribic you posted a reply, i think you were meant to make a topic ;)