Profile of dougmcc1

D
dougmcc1

Oct 4, 2009
Joined Jul 4, 2003

D
Creating static webpages on the fly
- PHP Help General Help
- I have a confirmation page on my website that generates a .html file. For example, maybe it's called confirmation.php. Also for example, maybe the page it is trying to generat...
2
D
Attaching HTML files to emails
- PHP Help PHP Coding
- I'm using the following php code to try to attach .html files to email using php but it's not attaching the file: $recipient_email="webmaster@domain.com"; $subject = "Test ema...
0
D
SOAP Requests
- PHP Help PHP Coding
- I have SOAP installed on my server but I'm not sure how to send or receive requests. If the following is my request, how do I send it to the API and how do I accept the respon...
0
D
Importing large CSV into mysql
- PHP Help PHP Databases
- Whats the best way to import large CSV text files (50MB or more) into a mysql table? Thanks.
4
D
[RESOLVED] Automatically capturing form fields in variables
- PHP Help General Help
- How do I configure php so that I don't have to initialize variables I capture from a form? For example, I dont want to have to do this: $formfield=$_POST['formfield']; I want ...
2
D
Find rows for a value with different dates in the same table
- PHP Help PHP Databases
- I need a single query/subquery for the following result. Assuming the fields in a single table are Date¦Product¦Sales, I want to return all products that had fewer sales yeste...
1
D
quicker execution of DELETE queries on large tables
- PHP Help PHP Databases
- Delete queries take a long time to run and I'm looking for ways to speed them up without having to delete or move data. I usually delete rows where the date field is equal to ...
9
D
#1071 - Specified key was too long; max key length is 1000 bytes
- PHP Help PHP Databases
- I'm using the XAMPP package. When I try adding some additional fields to existing indexes I get the following error message: "#1071 - Specified key was too long; max key lengt...
0
D
Indexes
- PHP Help PHP Databases
- What would an ideal index look like for the following query? $query="SELECT field1,field2,field3,field4,field5 FROM table WHERE field6 LIKE '%$value1%' AND field7!=''"; And th...
4
D
[RESOLVED] rmdir not working
- PHP Help PHP Coding
- I'm trying to delete folders on my website that were created using a script. The code being used to create the folders is simply: mkdir($new_folder, 0755); The code I'm using ...
3
D
displaying breadcrumbs as a store
- PHP Help PHP Coding
- I have a database where the categories are stored in one field like this: category1/category2/category3 The same subcategories are used under different categories like this: a...
2
D
Read-only Queries - only show affected rows instead of executing query
- PHP Help PHP Databases
- I have a script that has a text box where you can enter the query you want to run and see the results in the browser in a table. This is great for select statements but I'm wo...
2
D
what causes pieces of code not to run?
- PHP Help PHP Coding
- The code below isn't outputting anything after the first echo statement. Is there an error in the code or is there something else going on that's preventing the code from bein...
7
D
Synchronizing database tables and structures automatically
- PHP Help PHP Databases
- I have multiple mySQL databases. One database is the main database and the others just mimic the same one but have different data. In other words, all the databases have the s...
8
D
Downloading/Uploading Files To/From Remote FTP Servers
- PHP Help PHP Coding
- I have access to two FTP accounts. One has some files on it that I want to move to the other FTP account. I want to set this up to run as a cron job every day. I'm able to log...
4
D
[RESOLVED] Adding/Subtracting from Current Day's Date
- PHP Help PHP Coding
- Let's say today's date is 2006-06-01. How would I get data for the previous week without having to specify it? For example, the following wouldn't work: $enddate=date(Ymd); $s...
4
D
[RESOLVED] Difference Between fopen(), fsockopen()
- PHP Help PHP Coding
- What's the difference between fopen() and fsockopen()?
5
D
[RESOLVED] Sum Query returning duplicate output
- PHP Help PHP Databases
- I'm trying to run a query that sums up data for a certain value. It's summing up the data correctly but it's returning duplicate output because the value exists in the table m...
2
D
How to get subdirectory and file names in a folder
- PHP Help PHP Coding
- If I have a 'Scripts' folder and a 'Another' folder, how can I get all of the names for the folders in 'Another' folder using a script in the 'Scripts' folder? How would I get...
3
D
[RESOLVED] sessions not working on subdomains
- PHP Help General Help
- What would cause sessions to not work in any subdomain but www? My login script is at http://www.mydomain.com/login.htm. When someone logs in they are shown as logged in on an...
4

Ddougmcc1

Creating static webpages on the fly

Attaching HTML files to emails

SOAP Requests

Importing large CSV into mysql

[RESOLVED] Automatically capturing form fields in variables

Find rows for a value with different dates in the same table

quicker execution of DELETE queries on large tables

#1071 - Specified key was too long; max key length is 1000 bytes

Indexes

[RESOLVED] rmdir not working

displaying breadcrumbs as a store

Read-only Queries - only show affected rows instead of executing query

what causes pieces of code not to run?

Synchronizing database tables and structures automatically

Downloading/Uploading Files To/From Remote FTP Servers

[RESOLVED] Adding/Subtracting from Current Day's Date

[RESOLVED] Difference Between fopen(), fsockopen()

[RESOLVED] Sum Query returning duplicate output

How to get subdirectory and file names in a folder

[RESOLVED] sessions not working on subdomains

D
dougmcc1