[Resolved] PHP, Postgresql, and SELECT TAG

[jlpierce]

Hello all,

I have a registration page on my site that uses to files (register.php and regfrm.php).

All of the logic code for the registration page is contained in the register.php file, the html for the registration form is contained in the regfrm.php file. In the regfrm.php file I have php code snippets to populate fields with data and even populate a SELECT TAG from a MySQL database. The logic dictates that the form should be displayed if it has not been submitted or if the data submitted is invalid, if the form needs to be displayed I use an include('regfrm.php'); command at it works fine.

I am now working on another project, with this difference, the backend is Postgresql.

Now when I include('newunitfrm.php') when the form gets to the SELECT TAG it stops loading the rest of the page. There should be another 6 fields, of type text, displayed.

If I comment out the php code and manually place a couple of option statements inside of the select tag it works fine.

Any help would be greatly appreciated.

TIA

John

[toma42]

are you using htmlspecialchars on the values for your <options>?

[jlpierce]

No, I am not.

I am going to give it a try and see what happens.

I will let you know.

TIA

John

[jlpierce]

I have ran my return string through htmlspecialchars and the rest of the html parses.

However, the options string that is return is empy, it almost appears as if the function calls being made from the html are not even being processed. I say this because I have primed the string variable in the function FETCH_UNITS and then I am returning the string options which at this point should at the least contain the value that I manually assigned to the variable. It does not.

I know that the file DATAFUNCTIONS.PHP is being included, as I can remove the include statement and I get an error indicating a call to undefined function.

I am completely lost on this one.

Any direction and help is appreciated.

John

[e-mail]