jonw118

Hello. I'd greatly appreciate any help!!! Basically I have a form on my page. When this form is field out it posts the results to the iContact (subscribes to a list). iContact requires that form field for email be called "fields_email". Ok. Now, I have a redirect URL we have to use which needs the email in the URL string. For example, the form field "fields_email" has a value of [email protected]. For that redirect link I need it to be: http://www.test.com/[email protected]. See below: <form method=post action="https://app.icontact.com/icp/signup.php" name="icpsignup" id="XXXX" accept-charset="UTF-8";" > <input type=hidden name=redirect value="http://XXXXX.com/?email="FIELDS_EMAIL" /> <label>Primary Email</label> <input type="text" name="fields_email" id="fields_email"> How can I replace the "FIELDS_EMAIL" in the redirect URL with the value entered by the user? I hope this makes sense. Thanks again for any help!

I am using the following php script to display all the files that are uploaded in a directory on a page. There are two files in the folder I do not want displayed: .htaccess & index.php. Can someone help me out and provide a little guidance about what I need to do to print all the file names EXCEPT for those two. I imagine some sort of if statement. CODE: Top of page: <?php $dirname = "."; $dir = opendir($dirname); ?> Body: <?php while(false != ($file = readdir($dir))) { if(($file != ".") and ($file != "..")) { echo("<a href='$dirname$file'>$file</a> <br />"); } } ?> Thanks so much!

Hi all - I'd greatly appreciate any help. I am using phpMyAdmin and trying to export a table to a CSV. Many rows within the CSV do not have any values in any of the columns. When I go to export to CSV it "skips" these rows and doesn't export them. Does anyone know if it's possible to export the rows to CSV even if there are null values in a rows columns? Thanks!

Awesome!!! Thanks so much for the help. Now, here is a little tricky question since I can now get them all in a table. In the function it calls to order them by ID. Is there anyway it could order them all alpha versus the "ORDER BY 'id'" or is that not possible because of this statement in the function (which is needed for the category specific pages): $sql = "SELECT * FROM `".TBL_PORTFOLIO."` WHERE id IN (SELECT `portfolio_id` FROM `".TBL_PORTFOLIO_INDUSTRY."` WHERE `industry` = '$industry') ORDER BY `id`"; $data=SelectMultiRecords($sql); return $data; }

Hi there, I have a site that has several different pages which display products from each category on the designated page. What I am looking to do is create one page that also lists ALL the products. Right now, in the category specific page it has this is in the code: $data = get_portfolio_industry('Building Products'); $offset = $_GET['offset']; if($offset == ''){ $offset = 0; } function get_industries($rec_id){ $sql = "SELECT * FROM `".TBL_PORTFOLIO_INDUSTRY."` WHERE `portfolio_id` = '$rec_id'"; $data = SelectMultiRecords($sql); return $data; } And this is the from the functions file: function get_portfolio_industry($industry){ $sql = "SELECT * FROM `".TBL_PORTFOLIO."` WHERE id IN (SELECT `portfolio_id` FROM `".TBL_PORTFOLIO_INDUSTRY."` WHERE `industry` = '$industry') ORDER BY `id`"; $data=SelectMultiRecords($sql); return $data; } My hope was I would simple combine the products like this: $data = get_portfolio_industry('Building Products,Building Services,General Products'); ...but unfortunately it doesn't combine them. Any thoughts? Any help would be much appreciated.