undefined variables

Anon

Can anyone help me with this:

$save="INSERT into employee
(FirstName,LastName,Phone,Email,Based)
VALUES(isset'$FirstName','$LastName','$Phone','$Email','$Based'))
WHERE (isset($employid=$employid))";

Each time I run this code I keep getting undefined variables errors on each of the values. Each field that is called is written as below. I've tried everything I can think of but can't work this out.

echo "<th width=\"40%\" >First Name</th>";
print ("<td><input type=\"text\" name=\"FirstName\" size=\"40\" maxlength=\"50\" name=\"FirstName\" value=\"$row[FirstName]\" >\n");

Thanks in advance, Jo
echo "</td>";

[deleted]

Well, what exactly are you trying to do with this query? you are using PHP functions inside and SQL query.

$save="INSERT into employee
(FirstName,LastName,Phone,Email,Based)
VALUES(isset'$FirstName','$LastName','$Phone','$Email','$Based'))
WHERE (isset($employid=$employid))";

Most likely you are getting a huge SQL error too because this query won't work. Thus it produces no results, thus the result-vars don't exist.

read this:

http://www.hvt-automation.nl/yapf/index.php?cmd=viewitem&itemid=12

Anon

Thanks, basically i hoped I could do this in the same way as I did my prev/next buttons etc. Guess I'll have to go back to using the forms command and submitting data that way.

mithril

Hmm.... what's up with the item submission on the YAPF site? I get neither form when I click Add New. Am I missing something really obvious here?

-geoff

[deleted]

No, I think you just found a bug! :-)

Nobody except me should see the 'add new' button.

I'll get right on it!

[deleted]

Should be ok now, you can logon and submit things.

mithril

Haven't posted anything, but the form shows up now so I'll assume the rest of that bit works🙂 Another bug you might want to look into the login process using Netscape 4.7. Instead of authenticating and reloading the page, it prints the word "logon" and the sql query used to authenticate logins. This only appears to happen in NS 4.7..... tested it with IE 5.5 and Mozilla 0.9.5 and it works perfectly in those cases.

-geoff