Search results for query: *

Ok,I've got a dynamically created form that gets emailed to clients as HTML. PHP/Mysql creates it. Worked fine for everyone until we changed hosts and went from PHP4 to PHP5. Now, it works fine on my Mac and one of my clients PC's, but the rest of his staff receive it as raw html code instead...

i just switched hosts, going from php4 to php5 and have a slew of problems with my code now. Can anyone tell me what's going on here? I'm getting a PHP notice error of: PHP Notice: Undefined offset: 1 in /var/www/vhosts/domain.com/httpdocs/folder/file.php on line 76 that points to this code...

I need to insert data into two tables at the same time from a form for adding new vendors, but I'd like to grab the auto generated ID from the first table and put it in the second table so that they match. Is that even possible and if so, what would the code look like? Thanks. Using php/mysql.

Can someone tell me what is wrong with my sql statement below? I keep getting a syntax error. Thanks. SELECT * FROM (SELECT vendorname, SUM(cogs)AS sumcogs FROM spec_registrar WHERE orderdate >="2006/01/01" GROUP BY vendorname )as totals WHERE sumcogs >="10000.00

I'm giving jpgraph a try for the first time. Went thru the install with everything left at default. Used some sample code from a tutorial over at phpfreaks.com. I'm getting an error message that I don't know how to address. Maybe someone can shed some light? This is the message in my browser...

Is it possible to populate a dropdown menu with the file names that are found in a specified folder on the webserver? For instance, in my /images folder, the dropdown would have all the image files listed. What I'm trying to do is make a page for the user to select a file and then associate...

What is the best way to store keywords in a database table. I have a document, and want to be able to first, register various keywords associated with the document, and then have a page where the user can type in keywords to do a search for matching documents. Then they would eventually select...

I've got a fairly unique situation where i need to filter out records based on a location code. I have two regions in a warehouse, Quickpick and then Stock. The Quickpick locations have a code of a letter followed by 3 numbers (A001, B203). The Stock locations are 2 letters and a number (FJ4...

I'm attempting to have 2 other dropdowns appear or hide based on a selection from the first dropdown. I'd like them both to be invisible when the page loads and then to appear if a certain selection if picked from the first dropdown. Could you please assist in the making them invisible when it...

No, I'm not trolling for a date. I need help with the date function. Background: Currently I have a spreadsheet that I keep weekly data in for a list of companies. The list is very long now and i can't not crunch the data like I would like to, so I thought to put it in a database. What i need...

I've got a simple page for adding new courses to the database. That works fine. I'd like to add in the feature that whenever a new course is added, an email is sent to a certain email address to notify that person that the new course was added. How would I go about dropping this into my code...

My host reported an error and said that my script was allowing to many connections. Is there something that should be coded to close a connection after a user leaves the site? I thought this was automatic, but I guess not?? I can't imagine there were more than 50 users at one time on this...

Is there a way to get an update query to fire off w/o using a form? I have a page that shows new information requests. once my client views the detail page for each request I want the number of views to increase in count, so that new unviewed ones will only show on the first page. Kinda like a...

Can I do an update and select in the same query? I want to show a record and also update the "times it was viewed"...is that how I'd do it?

Ok, I have a simple form that dynamically lists a document and a quantity that a customer subscribes too. They are listed in table form on a page. I have a simple form included that allows the user to either update the quantity or delete the document from the list altogether. Here's the thing...

Ok, I have an invoice form on a client site that is generated using php pulling data from mysql database. Emailing of the form to customer is built in. Some of the customers aren't getting it b/c of email server issues blocking html email. So, client would like the form to be attached as a pdf...

I am using the below query and for some reason, when I add in the pubid it drops records from my output list. Maybe someone can tell me how it's written wrong. SELECT c.custnumber, c.custtype, c.firstname, c.middleinitial, c.lastname, c.companyname, c.department, c.region, c.street1...

I have a page that i'd like to load varying textarea boxes populated by an entry in the database. I'd like different boxes to show up based on the url string. for example... ...sitetext.php?page=Main would load 3 textarea boxes with the appropriate data. if I selected...

I'd like for a record's status to change automatically from unread to read if a page loads with the record on it. How could this be done? php/mysql pages. thanks.

Ok, I don't do much Access programming, but a coworker need some reporting done. I'd like to have one report output that would have a summary at the top by program areas summarizing the purchases for the month. Below that I need one of the program areas to have a detail listing of purchases...