Problem with php file...

RW43T

Hello, i have a server on a game with a private ranking system, and i am trying to do a website with the stats of my server. I use the software xampp, i created the database... but i get many errors on the index page.

This is the errors that i get:

Notice: Undefined index: q in C:\xampp\htdocs\ranking\index.php on line 2

Warning: include(connect.php) [function.include]: failed to open stream: No such file or directory in C:\xampp\htdocs\ranking\index.php on line 3

Warning: include() [function.include]: Failed opening 'connect.php' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\ranking\index.php on line 3

Notice: Undefined index: ajax in C:\xampp\htdocs\ranking\index.php on line 220
Top Player

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\ranking\index.php on line 356

Notice: Trying to get property of non-object in C:\xampp\htdocs\ranking\index.php on line 360

Notice: Trying to get property of non-object in C:\xampp\htdocs\ranking\index.php on line 360
1.

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\ranking\index.php on line 368

Notice: Trying to get property of non-object in C:\xampp\htdocs\ranking\index.php on line 373

Notice: Trying to get property of non-object in C:\xampp\htdocs\ranking\index.php on line 373
2.

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\ranking\index.php on line 378

Notice: Trying to get property of non-object in C:\xampp\htdocs\ranking\index.php on line 382

Notice: Trying to get property of non-object in C:\xampp\htdocs\ranking\index.php on line 382
3.

Notice: Undefined index: orderby in C:\xampp\htdocs\ranking\index.php on line 398

Notice: Undefined index: srch in C:\xampp\htdocs\ranking\index.php on line 420

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\ranking\index.php on line 424

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\ranking\index.php on line 432

Notice: Undefined index: start in C:\xampp\htdocs\ranking\index.php on line 435

Notice: Undefined index: ajax in C:\xampp\htdocs\ranking\index.php on line 458

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\ranking\index.php on line 488

Notice: Undefined index: ajax in C:\xampp\htdocs\ranking\index.php on line 527

And this is my file index.php:

bradgrafelman

What happened to the code (wrapped in the board's [noparse]

..

[/noparse] bbcode tags, I hope)?

Also... what's your specific question?

RW43T

I got problems when i posted the messages... I repost what i didn't written.

Here is a part of my file index.php:

<?php
$q=mysql_escape_string($_GET["q"]);
include("connect.php");
if($q!=""){
	$result = mysql_query("SELECT Name FROM stats WHERE Name LIKE '%".$q."%' ORDER BY Name ASC LIMIT 5");
	while($row=mysql_fetch_assoc($result)){
		echo($row["Name"]);
		echo("\r\n");
	}
	exit();
}
$starttime = explode(' ', microtime());
$starttime = $starttime[1] + $starttime[0];
function RankByScore($Score,$Week){
	if($Score>16500)
	{
		$Rank=40;
		if($Week>249)
		{
			$Rank=41;
		}
		if($Week>599)
		{
			$Rank=42;
		}
		if($Week>999)
		{
			$Rank=43;
		}
		if($Score>25000 && $Rank<41){
			$Rank=41;
		}
		if($Score>60000 && $Rank<42){
			$Rank=42;
		}
		if($Score>100000 && $Rank<43){
			$Rank=43;
		}
	}else{
		if($Score>999999999999)
		{
			$Rank=43;
		}
		elseif($Score>99999999999)
		{
			$Rank=42;
		}
		elseif($Score>9999999999)
		{
			$Rank=41;
		}
		elseif($Score>16499)
		{
			$Rank=40;
		}
		elseif($Score>15499)
		{
			$Rank=39;
		}
		elseif($Score>14999)
		{
			$Rank=38;
		}
		elseif($Score>14499)
		{
			$Rank=37;
		}
		elseif($Score>13999)
		{
			$Rank=36;
		}
		elseif($Score>13499)
		{
			$Rank=35;
		}
		elseif($Score>12999)
		{
			$Rank=34;
		}
		elseif($Score>12499)
		{
			$Rank=33;
		}
		elseif($Score>11999)
		{
			$Rank=32;
		}
		elseif($Score>11499)
		{
			$Rank=31;
		}
		elseif($Score>10999)
		{
			$Rank=30;
		}
		elseif($Score>10499)
		{
			$Rank=29;
		}
		elseif($Score>9999)
		{
			$Rank=28;
		}
		elseif($Score>9499)
		{
			$Rank=27;
		}
		elseif($Score>8999)
		{
			$Rank=26;
		}
		elseif($Score>8499)
		{
			$Rank=25;
		}
		elseif($Score>7999)
		{
			$Rank=24;
		}

	elseif($Score>7499)
	{
		$Rank=23;
	}
	elseif($Score>6999)
	{
		$Rank=22;
	}
	elseif($Score>6499)
	{
		$Rank=21;
	}
	elseif($Score>5999)
	{
		$Rank=20;
	}
	elseif($Score>5499)
	{
		$Rank=19;
	}
	elseif($Score>4999)
	{
		$Rank=18;
	}
	elseif($Score>4499)
	{
		$Rank=17;
	}
	elseif($Score>3999)
	{
		$Rank=16;
	}
	elseif($Score>3499)
	{
		$Rank=15;
	}
	elseif($Score>2999)
	{
		$Rank=14;
	}
	elseif($Score>2499)
	{
		$Rank=13;
	}
	elseif($Score>1999)
	{
		$Rank=12;
	}
	elseif($Score>1499)
	{
		$Rank=11;
	}
	elseif($Score>999)
	{
		$Rank=10;
	}
	elseif($Score>749)
	{
		$Rank=9;
	}
	elseif($Score>499)
	{
		$Rank=8;
	}
	elseif($Score>299)
	{
		$Rank=7;
	}
	elseif($Score>199)
	{
		$Rank=6;
	}
	elseif($Score>99)
	{
		$Rank=5;
	}
	elseif($Score>59)
	{
		$Rank=4;
	}
	elseif($Score>34)
	{
		$Rank=3;
	}
	elseif($Score>14)
	{
		$Rank=2;
	}
	elseif($Score>4)
	{
		$Rank=1;
	}
	elseif($Score>-1)
	{
		$Rank=0;
	}
}
return 	$Rank;
}
if(mysql_escape_string($_GET["ajax"])!="1"){
?>

I tryed to solve the first error, i created a file connect.php:

<?php 
 // Connects to Our Database 
 mysql_connect("127.0.0.1", "root", "") or die(mysql_error()); 
 mysql_select_db("Damagekill") or die(mysql_error()); 
 ?> 

 Then i tryed to solve the second error, i modifyed the line:

 $q=mysql_escape_string($_GET["q"]);

by:

$q = (isset($_POST['q'])) ? $_POST['q'] : '';

Is it correct what i did ?
Plz help me to solve all the other errors. I am a noob in php.
Thanks a lot for you help.

RW43T

Then i tryed to solve the second error, i modifyed the line:

$q=mysql_escape_string($_GET["q"]);

by:

$q = (isset($_POST['q'])) ? $_POST['q'] : '';