Undefined index

rmorf

Hi
I am new to php and i have the following problem. I installed php and mysql on a windows server and we moved to the server a working php page with its data base. I modifyied the php.ini file and we can see php pages fine but when these pages have some dynamic content from the DB it comes with an error. Here is what i get:

Couldn't execute query.PHP Notice: Undefined index: shortlist in C:\Inetpub\wwwroot\LocalUser\ftphhb\rascals\rascals\shortlist.php on line 3 PHP Notice: Undefined index: action in C:\Inetpub\wwwroot\LocalUser\ftphhb\rascals\rascals\shortlist.php on line 4 PHP Notice: Undefined index: shortlistid in C:\Inetpub\wwwroot\LocalUser\ftphhb\rascals\rascals\shortlist.php on line 5 PHP Notice: Undefined index: client in C:\Inetpub\wwwroot\LocalUser\ftphhb\rascals\rascals\register.php on line 25

So i dont know what is causing this - the page is online still on the old server and is working fine.

Thanks inadvance

Please help me solve this problem. I red so many info for php mysql and settings but i cant find whats wrong with this websie. I think it might be somethng with the settings on the server but i dont know anymore what can be changed.

NogDog

It will be very hard for us to guess without seeing the code in question. However, since it appears to be a result of a query failing, I'd suggest putting some debugging in after the query is executed, something like:

$sql = "SELECT blah blah blah";
$result = mysql_query($sql) or die("Query failed ($sql): " . mysql_error());

Obviously this is just a generic example. The idea is to output an error message that includes the actual SQL that was used as well as the error message generated by MySQL, should the query fail for some reason.

mpb001

This comes from the error reporting values being different in the different environments.

ini_set( 'error_reporting', E_ALL );
ini_set( 'display_errors' , 1 );

Make all errors appear.

echo $test['a'];

would throw an error if I hadn't assigned $test['a'] beforehand. Nothing to do with mysql. It's also the same with saying $a = $_GET['a'] if there is no param passed in the url called a.

Eg. for a get call you'd build a wrapper somewhere with the following.

function Get( $param )
{
if( isset( $GET[$param ] ) )
return $GET[$param ];
else
return null/""/false or whatever

}

Bit of a funny one as it is best practice to check for the existence of things instead of relying on the dynamic creation of them as it does catch some of the harder errors to spot due to mispelling etc .