[PHP] Am i missing something here?

[uk_viper]

Just a simple submit form sending data to the MySQL database. The script connects but does not insert the data

form.php

<?php

	echo '<form action="admin/_serverstatus.php" method="post">';
	echo '<input name="server" type="text" value="Server" /> << Server IP ';
	echo '<input name="submit" type="submit" value="Add" />';
	echo '</form>';

?>

admin/_serverstatus.php

	<?php
	include_once '../db.php';
	// process the form
	
	// clean the username and password
	$server = mysql_real_escape_string($_POST['Server']);
	
	// check for valid details
	$sql = mysql_query("INSERT INTO `uptime` VALUES ('$server')");
	
	if ($sql)
	{
		// success
		echo 'Server has been added';
		
	}
	else
	{
		// failure
		echo 'nope';
		echo mysql_error();
	}	


?>

 

[uk_viper]

i update it as the row it enters into is called server

	<?php
	include_once '../db.php';
	// process the form
	
	// clean the username and password
	$server = mysql_real_escape_string($_POST['Server']);
	
	// check for valid details
	$sql = mysql_query("INSERT INTO `uptime` (`server`) VALUES ('$server')");
	
	if ($sql)
	{
		// success
		echo 'Server has been added';
		
	}
	else
	{
		// failure
		echo 'nope';
		echo mysql_error();
	}	


?>

 

[uk_viper]

ok so any suggestions on where to change code as theres still no luck

 

[uk_viper]

issue resolved

 

[uk_viper]

changed letter to lowercase

$server = mysql_real_escape_string($_POST['Server']);

to

$server = mysql_real_escape_string($_POST['server']);

 

[uk_viper]

typical, single letter case