Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Populate array and print data in a table cell
TY jpadie I will change that and test later tonight and post my other questions appropriately. -
Populate array and print data in a table cell
Thank you so much. I admit I feel a bit embarrassed now for not commenting and structuring this before posting and want to extra thank you for taking the time to do that. That said, I do see the listing now under my sizes column. It is printed correctly for each value but this did not put them... -
Populate array and print data in a table cell
I am writing a tagging template for our company and have run into ome trouble printing a list of database balues in a single cell. <?php $itemidpass = $_GET['itemid']; $username="test"; $password="tester"; $database="test"; mysql_connect(localhost,$username,$password)... -
Embed ODBC query in email
UPDATE! I think I got it figured out using the Output Buffer you suggested Vac. Nice!!! Below is the code I have now... modified slightly to include the Content Type and Mime Boundary needed for the email to be interpreted in HTML (just using the Output buffer showed the raw HTML code in the... -
Embed ODBC query in email
Thanks for the help... I have not used Output Buffering yet so I will give this a try. I was also kicking around the idea of having the Output act as it's own module and instead of embedding the results in the email text, output the results into an HTML cache page and use a seperate email... -
Embed ODBC query in email
I am having trouble getting a result set to send via email. The email sends when I run the script through firefox and it displays the data contained in the result set but the email message does not show the data... just the number of rows in each result set. Pass and Login edited out <?php... -
PHP passing query values through POST
How can you set a variable to have a value based on a query that returns single values? <?php $conn = odbc_connect("HOMES", "", ""); $query = "SELECT DISTINCT sls_his_invc_no FROM sls_his where sls_his_item_id IN (SELECT item_id from item where item_vend_id = 'MONTAGE') and... -
Passing variables to iframe using PHP
As it is calling an INSERT statement as the result print or odbc_result_all are not the best... do I need to use one of those to still execute the result? -
Passing variables to iframe using PHP
I got it... I hope... it seems to write the data to the database correctly. getcustid5.php <?php print('<iframe align="right" src ="updnps1.php?npsbilldate=' . $_POST[ 'billdate' ] . '&npscustid=' . $_POST[ 'sls_his_cust_id' ] . '" height="550" width="36%"> </iframe>'); $conn =... -
Passing variables to iframe using PHP
I want to be able to pass these two variables to the iframe so that they can be used in the Insert statement of the iframe source page and be written to the database tables. Here are the codes: getcustid5: <?php print('<iframe align="right" src ="updnps1.php?billdate=' . $billdate ... -
PHP Self help
Ok I am checking out ipframes and it looks like that is my best bet... but I want to be sure that I will be able to pass along the variables to the iframe page. Also once I hit the submit button in the iframe will it only reload the frame or the whole page? -
PHP Self help
No I cannot as this is not a public thing... it is an intranet server parsing the PHP and serving up the pages pulling the data from our database. It is all locked behind our VPN with no incoming port 80. You would have to be in my store or server location. -
PHP Self help
Ok NM it did work. but just in case try this as well: www.ashleyjaxonline.com/viewscreens.html -
PHP Self help
No it does not work... I will just make a page with the images. -
PHP Self help
Attached are three screens of my code in production. In case that attachement does not work just email me and I will send it.http://www.ashleyjaxonline.com/screens.doc -
PHP Self help
Initially to use this page I have to start at enterbilldate.html where the yyyymmdd date is entered and the submit button is clicked... this pushes the $billdate variable to getcustid2.php. When that loads up it shows the populated pulldown menu followed by three rows of "No rows found". Once... -
PHP Self help
Pervasive 9.5 I am running Debugs now and will let you know if I find something. Note that using my original code for the data works fine using odbc_result_all amd the queries exactly as I have posted them... the only thing is that it showed three rows of No Rows Found once the Pulldown is... -
PHP Self help
get the pull down but moving to get the data still kicks Apache offline. Below is the error log from Apache: zend_mm_heap corrupted [Sun Aug 17 23:45:57 2008] [notice] Parent: child process exited with status 1 -- Restarting. [Mon Aug 18 07:58:23 2008] [warn] pid file... -
PHP Self help
Thanks, I will try this. As for the slm thing, both the table and the first column of the table are called slm... dont ask me I did not program the database initially... in fact I believe this particular table is created when PROFIT is installed. So much for production value huh? Regardless I... -
PHP Self help
Well dont I feel stupid... instead of posting my code I reposted jpadie's code he suggested above... no wonder no one responded. Below is what I am usng now and need some help with: <?php $conn = odbc_connect("HOMES", "", ""); if (!empty($_POST['billdate'])){ $billdate = $_POST[ 'billdate'...
