help with variable declaration

confuddled

OK, I know I am an idiot for using Adobe GoLive, but what can I say? When you are finished with the flamethrowers, please somebody help me out here.

I am trying to create a simple page with a form that will query a MYSQL db and return the results in a table on the same page.

I have been working through a GoLive tutorial and have done all it suggests, but GLive is not delcaring one of the variables correctly and I cannot find the error or recognize the correct syntax.

When I parse the page in my browser I get this error message:

"<ERROR Number="8" Description="Error: "Undefined index: itemnum" on line 12"

Here is the code that it refers to:

$results = WrapMySQLDatabaseResults("products", "select * from products where itemnum = " . $GLOBALS["itemnum"] . "", "block=5","results");

When I parse the page in my browser I get this error message:

Can anybody help a newbie out here?

steadyguy

Interesting that GL should think an invalid index is an error ... PHP nly raises a notice, which most people never see ... in any case, it appears that you need to initialize the value of $GLOBALS['itemnum'] ... I personally avoid the $GLOBALS array like the plague. Since it is a global value, you can do it pretty much anywhere you like ... though you'll need the global keyword:

global $itemnum = 0;

If you're expecting $itemnum to be set by some sort of user input, then I would HIGHLY recommend against using $GLOBALS, and also suggest that you make sure you validate the data before you use it.

Probably the easiest place to put this would be immediately before the line that generates the error.

confuddled

Thanks to both of you for the quick replies. I ended up dumping GoLive and coding it by hand using an HTML form page that loads the PHP results page. I found a good tutorial that online that made it clear for me. I still don't understand the Global variables and how exactly GL is structuring the code (nor do I really want to). Thank you though for trying to enlighten this lost soul.

Goodby GoLive hello Notepad...