dickm

No errors are reported by MYSQL. I just added your error check and no errors. Also I have echoed the variables and they are the same as the static data, so I am really puzzled.

I have the following query which when pasted into phpmyadmin sql works and returns results SELECT h.rec_id AS CapLog, h.remoteid AS Reference, h.branch AS Branch, h.dtplnprtd AS PrelimDate, h.estimate AS Estimate, h.cname AS Company, h.mycustomer AS OurCustomer, CONCAT_WS( ' ', RTRIM( h.jobsite1 ) , RTRIM( h.jobsite2 ) , RTRIM( h.jobsite3 ) , RTRIM( h.jobsite4 ) , RTRIM( h.jobsite5 ) , RTRIM( h.jobsite6 ) , RTRIM( h.jobsite7 ) ) AS Jobsite, h.contractor AS Contractor FROM history h INNER JOIN customer c USING ( cusid ) WHERE c.username = 'USERCPO' AND h.dtplnprtd BETWEEN '20110524' and '20110622' ORDER BY mycustomer ==================================================================================================================== Now the same query but using the variables instead of the static data in RED above returns no results in my script file??? $query = "SELECT h.rec_id AS CapLog, h.remoteid AS Reference, h.branch AS Branch, h.dtplnprtd AS PrelimDate, h.estimate AS Estimate, h.cname AS Company, h.mycustomer AS OurCustomer, CONCAT_WS( ' ', RTRIM( h.jobsite1 ) , RTRIM( h.jobsite2 ) , RTRIM( h.jobsite3 ) , RTRIM( h.jobsite4 ) , RTRIM( h.jobsite5 ) , RTRIM( h.jobsite6 ) , RTRIM( h.jobsite7 ) ) AS Jobsite, h.contractor AS Contractor FROM history h INNER JOIN customer c USING ( cusid ) WHERE c.username = '$remcode' and h.dtplnprtd BETWEEN '$dbegin' and '$dend' ORDER BY mycustomer"; Any ideas as to what is wrong would be appreciated.

Sorry Larry, the correct URL is http://localhost/form/AZCondFinRel.php . This the URL that appears as I am in the development stage with XAMPP. The program that calls this module is in the root folder for the website.

It will be impossible for me to use absolute paths instead of releative, because I will be loading and display hundreds of forms for the user and these will be all in various directories. To use absolute would be a nightmare in testing using Localhost and then the actual live URL. Any other options??

the correct URL is ./form/AZCondFinRel.php

I have changed this non-working code around from the previous that was submitted above. Now a new window is being opened, but errors with "Internet Explorer cannot display the webpage" The correct URL is showing in the browser address bar. <form action="./form/AZCondFinRel.php" onsubmit="window.open(this.action,'popupwin','width=1000,height=700,left=500,top=5,scrollbars=yes,resizable=yes');return false;" method="post" > If I remove the onsubmit command and attributes, the form opens correctly but in existing window. So still puzzled.

Having a problem with opening an addition window. This next coding portion is working correctly and opening the href in a new window. <td><a href="form_selection.php" onClick="window.open(this.href, 'popupwindow2','width=1100,height=800,left=500, top=50, scrollbars=yes,resizable=yes');return false;"><h4> Select and Prepare New Legal Form </h4> </a></td> =============================================================================== Now this segment of coding from a form is not working. The form action is opening the correct php page, but it is not opened in a new window as desired. Can anyone see what is wrong as it is basically the same as the href process. I have changed dimensions, I have changed "this.form.action" to many different variations with spaces, quotes, brackets, etc, but the page is ran correctly, just not in a new window. <form method="post" action="/form/AZCondFinRel.php" onSubmit="window.open( this.form.action,'popupwin','width=1000,height=700,left=50,top=5,scrollbars=yes,resizable=yes');return false;" > Mahalo

Thanks Paul; Printing out the results helped me track down my problems which were multiple. Two of the variables were not updating correctly from the previous POST and two were just my stupid misspelling. Now have the process working correctly. Mahalo

They come from session variables. $camt = $_SESSION['camt'];

This is driving me crazy. The echo statements for testing are returning the correct where condition variables but the columns are not updated in the table $query = ("UPDATE forms SET form_date = NOW(), form_amount = $camt, form_dispamt = $damt WHERE form_cusid = '$cusid' AND form_recid = '$rec_id' AND TRIM(form_type) LIKE '$afrmtype'"); $result = mysql_query ($query); // Run the query. echo ' Form ID: '. ' [<b>' .$frmid. ' </b> ]'; // this is the correct record id which is an auto-increment value echo ' Number of Rows: '. ' [<b>' .$num_rows. ' </b> ]'; // this is returning a count of 1 record Any help would be greatly appreciated. I have tried it with '$camt' for the SET variables and have tried the ".$camt." also and nothing has changed. The all give the same echo results but not update of data. Mahalo

Okay, I have modified my code based on Larry's process on page 550, but am getting the error: //Warning: mysql_fetch_array() expects parameter 2 to be long, string given in C:\xampp\htdocs\preview_setup_AZ_state_form.php on line 343. Line 343 is the while condition line. I can't rely on post I don't think, because my user editing option occurs a few screens later, when they have an option to make changes based on a new display of information so that is why is am using SESSION instead of POST. Any suggestions for corrections would be appreciated. <p><b>Signee to use for this form: </b> </p><br /> <?php require_once ('./php/mysql_connect.php'); // Connect to the db. $cusid=$_SESSION['cusid']; $query="SELECT relcusid, concat(authsign,'-',signtitle) as mysig FROM relsignor WHERE relcusid=$cusid"; $result = mysql_query ($query); if (mysql_num_rows($result) > 0) { while($row=mysql_fetch_array($result, mysql_num )) { echo '<option value=\"$row[0]\"'; if ($_SESSION['my_sig'] == $row) {echo 'selected="selected"'; echo ">$row[1]</option>\n"; } } } Mahalo

Larry, after rereading and then studying your Sticky form process in PHP6 and MYSQL 5 Visual Quickpro Guide, I made the following corrections to my code and the radio button process is now working correctly for me. I first eliminated all the variable creation at the start and eliminated all the if else conditions that were working with the new variables that I created and just used what was already stored session variables from the original form. <p><b>Joint Check You Selected to:</b> <p> <input type="radio" name="jtchkname" <?PHP if ($_SESSION['jt_cknam']== 'none') {echo 'checked="checked"';} ?>/>None</p> <p> <input type="radio" name="jtchkname" <?PHP if ($_SESSION['jt_cknam']== 'mycustomer') {echo 'checked="checked"';} ?>/>My Customer</p> <p> <input type="radio" name="jtchkname" <?PHP if ($_SESSION['jt_cknam']== 'contractor') {echo 'checked="checked"';} ?>/>Contractor</p> <p> <input type="radio" name="jtchkname" <?PHP if ($_SESSION['jt_cknam']== 'lender') {echo 'checked="checked"';} ?>/>Lender</p> <p> <input type="radio" name="jtchkname" <?PHP if ($_SESSION['jt_cknam']== 'owner') {echo 'checked="checked"';} ?>/>Owner</p> <p> <input type="radio" name="jtchkname" <?PHP if ($_SESSION['jt_cknam']== 'other') {echo 'checked="checked"';} ?>/>Other Name</p> <P> I just have to learn to read more intelligently and follow your great examples, but thought I would pass this on to maybe help others. Mahalo

Here is the code that I have and on the first page that it appears, it allows the user to select only one of the options. However, when I return the full form for further editing by the user of all form items, this second of code always returns the checked option of 'owner'. The default option on the first page is 'none' and even if left at that, on the review page is is 'owner'. Any suggestions would be great. ==========First page code======= <p><b>Joint Check to Who:</b> <p> <input type="radio" name="jtchkname" value="none" checked="checked"/>None</p> <p> <input type="radio" name="jtchkname" value="mycustomer"/>My Customer</p> <p> <input type="radio" name="jtchkname" value="contractor" />Contractor</p> <p> <input type="radio" name="jtchkname" value="lender"/>Lender</p> <p> <input type="radio" name="jtchkname" value="owner"/>Owner</p> <p> <input type="radio" name="jtchkname" value="other" />Other Name</p> </p> ==========Review page code======= <?PHP $none_status = "unchecked"; $mycustomer_status = "unchecked"; $contractor_status = "unchecked"; $lender_status = "unchecked"; $owner_status = "unchecked"; // session jt_cknam is created from the post of jntchkname from first page if ($_SESSION['jt_cknam'] == 'none') { $none_status = "checked"; } else if ($_SESSION['jt_cknam'] == 'mycustomer') { $mycustomer_status = "checked"; } else if ($_SESSION['jt_cknam'] == 'contractor') { $contractor_status = "checked"; } else if ($_SESSION['jt_cknam'] == 'lender') { $lender_status = "checked"; } else if ($_SESSION['jt_cknam'] == 'owner') { $owner_status = "checked"; } //} ?> <p><b>Joint Check to Who:</b> <p> <input type="radio" name="jtchkname" value="none" checked = '$none_status'/>None</p> <p> <input type="radio" name="jtchkname" value="mycustomer" checked = '$mycustomer_status' />My Customer</p> <p> <input type="radio" name="jtchkname" value="contractor" checked='$contractor_status'/>Contractor</p> <p> <input type="radio" name="jtchkname" value="lender" checked = '$lender_status '/>Lender</p> <p> <input type="radio" name="jtchkname" value="owner" checked = '$owner_status'/>Owner</p> <P> Mahalo

I am having trouble trying to control the amount of data that a user can enter in a textarea on a form. The code (just a small segment of the full page form that I have is as follows: <hr /> <p><b>Special Notes Regarding this form information: </b></p> <p><textarea cols="45" rows="5" name="comments" wrap="hard"> </textarea></p> <br /> <hr /> I have the limit set at 5 rows, but when typing in the area, the user can continue on and on and this will be unacceptable. I have thought of a message to say only type on the first 5 lines, but that doesn't seem to be very professional. Any help would be appreciated Mahalo,

The below code generates a pull down menu list of names that user can select to use. It is one of many input options on the form including text and radio button form options. I am able to store all the other input options to be redisplayed in case of editing needs, but unable to redisplay the user selection from this signature pull down menu. When I return the user to this page currently the signature pull down menu is at the default start display, not the users choice. Any suggestions would be appreciated. <?php require_once ('./php/mysql_connect.php'); // Connect to the db. $cusid=$_SESSION['cusid']; $query="SELECT relcusid, concat(authsign,'-',signtitle) as mysig FROM relsignor WHERE relcusid=$cusid"; $result = mysql_query ($query); echo "<select name = mysig value=''>mysig</option>"; while($nt=mysql_fetch_array($result)){//Array of records stored in $nt echo '<option value=" ' . $nt["mysig"]. ' "> '. $nt["mysig"] .'</option>'; } echo "</select>"; ?> <p><b>Signature to use: </b> </p><br /> <hr /> <div align="center"><input type="submit" name="submit" value="Submit My Information" /> <input type="hidden" name="submitted" value="TRUE" /> </div>

Thanks a million Larry, you are the best. It was my forward slashes that came from some testing with htmlentities and addslashes and once removed like your code that you tested, all is well in my world again. Mahalo, ps...just received my ordered copy of your book "Effortless Flex 4 Development" and am looking forward to seeing what can be done.

Okay Larry, I have changed the code as follows and it still is not opening an additional window. <table align="center" cellspacing="0" cellpadding="5"> <tr> <td><a href="form_selection.php" onclick="window.open(this.href, \'popupwindow2\',\'width=600,height=400,left=30, top=10, scrollbars=yes,resizable=yes\');return false;"> Select and Prepare New Legal Form </a></td> </tr> </table> Mahalo,

Okay Larry, I have changed the code as follows which includes some height and width changes just for visual testing and it is not opening an additional window. <table align="center" cellspacing="0" cellpadding="5"> <tr> <td><a href="form_selection.php" onclick=window.open(this.href, \'popupwindow2\',\'width=600,height=400,left=30, top=10, scrollbars=yes,resizable=yes\');return false;"> Select and Prepare New Legal Form </a></td> </tr> </table> Mahalo,

Sorry for the confusion Larry, so I must not be explaining myself properly. The initial display of data is a grouping of records and fields of information in rows. Each row of the ten row display has the rec_id at the left and it is underlined with the href tag. When the user selects one of the records the in the top code, a second window is opened with the sizes in the code that is smaller than the initial display of the records , and in this window is display all the fields of information related to that record. What I want to do with the second set of coding is all the user to again click on an href tag that will display some additional information in a third window but smaller than the second window. This way they can close the smallest (third window) and still be able to access information from the second window before also closing that window and returning to the original display of ten records. Hope this helps. dickm

Aloha to everyone. I am trying to give some editing options to users and am trying to work with opening additional windows and having some problems. The first additional window is opened with the following code and is working correctly. while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $bg = ($bg=='#eeeeee' ? '#ffffff' : '#eeeeee'); // Switch the background color. echo '<tr bgcolor="' . $bg . '"> <td align="left"><a href="view_full_record_form.php?rec_id=' . $row['rec_id'] . '" onclick="window.open(this.href, \'popupwindow\',\'width=1000,height=800,left=200, top=50, scrollbars=yes,resizable=yes\');return false;">' . $row['rec_id'] . '</a></td> Now I am trying to open another, smaller popup window inside of the existing window and am using the following code, but it is not opening another window and I can't see my problem. <table align="center" cellspacing="0" cellpadding="5"> <tr> <td><a href="form_selection.php" "onclick=window.open(this.href, \'popupwindow2\',\'width=800,height=600,left=30, top=10, scrollbars=yes,resizable=yes\');return false;"> Select and Prepare New Legal Form </a></td> </tr> </table> Thank you for any help that you can provide. Mahalo dickm PHP 5.3.1 MYSQL 5.1.41

Just thought that I would pass along the solution to this error problem. In my coding I had the following new code additions: $cust = escape_data($_REQUEST['customer']); $_SESSION['mycustomer']=$cust; What became the indication solution for me was the part of the error statement that said "be advised that the session extension does not consider global variables as a source of data", so I changed the code as follows and the error condition did not appear: $_SESSION['mycustomer'] = escape_data($_REQUEST['customer']); Hope this helps clarify this problem for others also. dickm

Thanks for the reply Paul. Register_Globals is off in my php.ini so I am really baffled by this error. dickm

I am now getting this error in my coding, since adding the last module that we have been discussing regarding single and double quotes in the previous topic: Warning: Unknown: Your script possibly relies on a session side-effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a source of data, unless register_globals is enabled. You can disable this functionality and this warning by setting session.bug_compat_42 or session.bug_compat_warn to off, respectively in Unknown on line 0 I have been looking thru my code and not finding any variables with the same name as the session variable. Any other causes?? dickm

Mahalo to Larry and Paul for your input. I will return to the coding and make the changes as you have suggested. I like the long term solution, rather than the quick fix that I applied. dickm