NEED HELP DESPERATELY!!!!!

Anon

hello please spend some time help me...
this is our codes:

if (!($newresult = mssql_query("INSERT INTO User (FirstName,LastName) <--LINE 1818VALUES('$form_first_name','$form_last_name')")))
{
echo("\nYour request has been timed-out!");
echo("\nPlease contact the system adminstrator!");
exit() ;
}

we are doing a registration web page using php as a connectivity to ms_sql, where user key in their first name, last name, n by clickin on submit, the info will be sent to our sql server as input. BUT WE GET THE FOLLOWING ERROR MSG:

Your request has been timed-out! Please contact the system adminstrator!PHP Warning: Undefined variable: form_first_name in C:\Inetpub\wwwroot\submit.php on line 18 PHP Warning: Undefined variable: form_last_name in C:\Inetpub\wwwroot\submit.php on line 18 PHP Warning: MS SQL message: Incorrect syntax near the keyword 'User'. (severity 15) in C:\Inetpub\wwwroot\submit.php on line 18 PHP Warning: MS SQL: Query failed in C:\Inetpub\wwwroot\submit.php on line 18

please HELP!!! THANKS A BILLION!!

van__

ahem:

Warning: Undefined variable: form_first_name

Rule #1: PHP doesn't lie.
If PHP is freakin becuase it says some var isn't set, then that var sure as hell is not set, go check your code. Typos can be a big problem. And if you're dealing with mssql, I bet you have a VB/asp background and are having issues with PHP's case sensitivity.

Anon

what is the syntax to set var ?? and where shd i put this var?
yes i have vb background but i am not using asp.

van__

Well, technically, these should be set:
'$form_first_name','$form_last_name'

but they are not, so check to see what the form input names are, they need to be spelled exactly the same with the same casing.

that means that $form_last_name does not equal $FORM_LAST_NAME

also, you had an error in your mssql syntax.
I know nothing about working with microsoft servers or daatabases, so I can't help you there.

Anon

Well, I've checked and i am very sure that i did not mispelled the input names.
Any other suggestions you can think of?
Thanks a Billion Van~~~

Anon

Without seeing the rest of the code I doubt I can help but do some error checking...

Try commenting out the if and just echo the variables. If they are set work your way back, the error could be a missing " further up... if they aren't set check the scope... if they're in a function make sure they are global

Mark

Anon

http://www.php.net/manual/en/function.mssql-query.php

i have no experience with mssql.. any way, try:

$query = "INSERT INTO User (FirstName,LastName) VALUES('$form_first_name','$form_last_name');"

echo $query.'<br>try this query at console';

if ((mssql_query($query) === false) echo 'doesnt work';
else echo 'like worked';

// take a look at your database with the console (or any way that you could use) and confirm if it really doesn't work.

Anon

We followed all instructions...but still could not get it to work... we used echo($variable) but the output is still undefined variable. We tried to use $query=INSERT INTO...but the result is still the same. Any body can help me???

Anon

Hi,

Maybe I could help if you post here the original form and the complete php-file where the data gets posted to.

I guess that everyone is talking around without knowing the exact problem.

Arjaan