PHP :: Common Prob With Mysql LOAD DATA LOCAL INFILE ...

LOAD DATA LOCAL INFILE - Workaround For Local-infile=0
I'm using a PHP script for updating my database which relies on the "LOAD
DATA LOCAL INFILE" command. As my provider recently updated the
MySQL-database, he changed the "local-infile" setting to zero, i.e. my
update-script doesn't work anymore (=> "The used command is not allowed with
this MySQL version").

Is there a work-around to fix this problem? I though about the mysql_options
command, but to frankly speaking, I have no clue how to use it and couldn't
figure out how to properly use it even after reading the manual ... anyone
who could help?

LOAD DATA LOCAL INFILE
SQL Version: MySQL 3.23.49
PHP Version: 4.3.11

Tearing my hair out with this 1. My PHP script was woking perfect until I moved to a different hosting server. When my page loads a PHP script imports the data into a MySQL table. Code:

Using MySQL Command Load Data Infile
When I execute this SQL statement in my PHP code, I get an error
"File '.Address.txt' not found (Errcode: 2)"

$File = addslashes(".Address.txt");
$SQL = "Load Data InFile "" . $File . "" into table addresses";
$result = mysql_query($SQL) or die(mysql_error());

The file is located in the same directory as my .PHP file.

How do I generate a relative address for this file so that it can be found?
I'm running on XP Prof..

LOAD DATA INFILE Error?
I have been using this same script to import CSV files into MySQL with 70 different fields. I have moved to using the same code, just the table has changed and the number of fields is only 10.

This CSV file normally uses a tab to seperate columns, I have PHP replace all tabs with commas after it uploads the file. Here are the two files that are needed to run the script Code:

Importing To Mysql Without LOAD DATA LOCAL
I've just gone through the learning curve of realizing most virtual hosts have "LOAD DATA LOCAL" disabled :(

I have a two meg delimited ascii file I need to import on a regular basis (26 fields)

Anyone have a nice import routine using fopen they are willing to share before I attempt to hack one out myself? I can't seem to find such an animal out there (though some are close).

Such a shame, from what I have read, load data is much faster...

Load Data Into MySQL
I have a table in which its primary key is auto-incremented. Yet, when
I try to load data using load data infile, this column will not
auto-increment. I am leaving that column blank in my file to be
uploaded, yet it fills this value in with a zero for all records.

Should I be using a php script to load this file? Why isnt this
updating correctly?

LOAD DATA MySQL
I have been struggling to get an idea of how to achieve the task in
hand. What I am trying to do...

I have a MySQL database, I am trying to create php page to pick a file
(browse to file required) and either upload the file to the server or
if possible use the location path of the file to be a variable in a...

How To Automatically Upload Data From Mysql Database Local Server To Web
Please any one help me to provide php code to automatically upload data from mysql database local server to web mysql database.

Netscape Cannot Load Local PHP Pages
I am developing a php application on a windows xp machine running IIS and I cannot load the famous test.php page or any others with a php extension in my
Netscape 7.1 browser (I also tried version 4.6). I am always prompted
with: you are trying to open an application of type
"application/octet-stream " and what I would like to do with the file,
when in reality my browser should be processing it. It works great in
IE, and php pages on the web work fine in Netscape. So I know it is
something local, but I just can't figure it out! Is there a
particular setup of php files with Netscape, something mime-type
related? Does anyone have any advice?

PHP And MySQL Prob....
I've installed Apache 1.3.12 With PHP 3 built in. After i've installed MySQL 3.22.32 an this way the PHP3 insn't compile with MySQL (I have Freebsd and I install those thing as binaries). What I want to kown is if there's a way to link PHP3 to MySQL without compling PHP3 (like ./configure --with-mysql=/...) Some person told me to edit the php3.ini but I don't know what to do here ?

Similar_text, Mysql Prob
I was wondering if anyone here had a decent solution to this mysql/php
problem.

I have a mysql database with a list of groups (group_id, group_name,
group_location, group_time, group_day). group_name must be unique for
each group_location - so there is only ever one particular group name
per group location.

I want to let users join a group or add a new group as they please. The
user is provided with a form to fill out group_name, group_location,
group_time, group_day and they post the form to a php page that checks
what groups are in a particular location.

I want to provide to the user information in this order:
1.)exact group_name match if there is one (showing the details of the group)
2.)the group information they provided in the posted form if there are
no exact matches
3.)close group_name matches if there are some (showing the details of
the group)

This is an intuitively ordered list and makes it all the more user friendly.

So after the user posts the form page to the checking page, I have a
query that selects the group_id of the group_name they selected:

$query_group = "SELECT group_name FROM groups WHERE group_id =
'".$_POST['group_id']."'";

Then I do a while loop with $row = mysql_fetch_array($query_group) and
have an if then else for various options:

$row['group_name'] = $_POST['group_name']
$row['group_name'] = $_POST['group_name']

and for similar text:
similar_text(strtoupper($group_name), strtoupper($row['group_name']),
$similarity_pst);

Where I show similar matching group_names if
(number_format($similarity_pst, 0) > 90){

Of course this is all out of order if the first row is similar matching
then it shows the similar match before a later exact match in the mysql
table.

How do I get a well-ordered output as indicated above? I don't want a
lot of nested queries to achieve it (one query for exact, one query for
LIKE and no match). Is there an elegant solution? Maybe dump out all
groups for the specified group_location and push the matching score onto
the array and sort?? Or maybe a temp table - no idea, never used that in
mysql.

I would also like to use the better string comparison power of
similar_text or even levenshtein in php.

PHP + MYSQL PROB, SELECTING EVERY OTHER ROW
I have a MYSQL Db with 1 table called 'Coordinates', it contains 3 columns, 'id', 'lat', 'long'. I'm try to create SQL insert statements using the power of PHP, as my table has 92,000 rows in so far.

I have written some functions, which will work out the four points around these 2 coordinates, but I need to add/call the values from 1 row with the following row. For example: Code:

Common MySql Search Algorithms In PHP?
I need to put together a simple search function. I imagine there is
already some PHP code out there that handles the basics?

For instance, how do I search for just words, from one word boundry to
another?

Common Email Characters Not Accepted By Mysql
I'm making array of characters to replace with temporary proxys (equalsign, singlequote, doublequote, etc.) that will be switched back the original character when a user views his or her emails. For those of you who've done e-mail scripts with mysql before, which characters have proven to be the most trouble (I'm only imagining how many emails one email could hold up if checkmail.php's error array didn't have a certain charactter)?

Login Prob Well More Of SQL Prob
i keep getting this error message:

Warning: Wrong datatype in call to extract() in /web/sites/94/billycohen/www.billycohen.f2s.com/login.php on line 77 PHP Code:

Save Html-forms Data To Local Disk?
A question on html-forms:

We have an application where users will get a CD with,
among other things, some html-forms for them to fill in.
When they click the submit-button, the data is transferred
to a webserver php-script that will then process the info.
The forms-definition looks something like this:

<form action="http://www.ourdomain.com/receiver.php" method="post">
<p>Question 1:
<p><textarea name="reply01" cols="40" rows="5"></textarea>
<p>Question 2:
<p><textarea name="reply02" cols="40" rows="5"></textarea>
<p>Question 3:
<p><textarea name="reply03" cols="40" rows="5"></textarea>
... etc ...
<p><input type="submit" value="Submit answers!">
</form>

Now, my concern is (since there might be quite a lot of data filled in),
if e.g. the internet-connection for some reason is broken
at the moment when the user clicks the submit-button,
there is a risk they will lose all the text and would have to re-type it,
which I would like to avoid, of course.

How can I best solve this issue?

Ideally, I would like to store the info on their local C: drive
before submitting, and automatically retrieve the text if they
later return to the page, but I guess that's not possible from
an html doc, right?

If so, any other suggestions how to resolve this issue?

Importing From CSV Using LOAD DATA
what attributes should i use for a text coloum should it be binary?

INSERT Data On Page Load?
I have an avatar system where certain avatars are locked until the user unlocks them by going to certain pages of the site.

So far ( being the newb I am ) I only know how to INSERT data from a form. Is there a way to do it on page load or similar?

I also need it to first check if the data already exists and if not it inserts the data and then displays a message to the user that they have unlocked the avatar. Code:

Passing Form Data To An Email Address/Excel Sheet On A Local Computer
I am right now learning PHP & want to know if there is a way to send
web form data to an Excel sheet located on a network. My windows xp PC
doesnot have a copy of Excel. Also i am not connected to the internet,
its a local computer.

What i am trying to do is to make a PHP script which will send a simple
form data to an excel sheet (or create a new Excel sheet) on another PC
on a network.

Since i am not connected to the internet, i will not be able to send an
email (anyway, sendmail is not available on Windows OS), nor do i have
any server on windows.

Is it possible to send form data to Excel sheet on local computer? Even
my PC is a local PC. Some one was saying its possible thru Windows
Scheduler.

How To Populate Data Into Text Fields On Page Load??
I am creating an account management page that shows the user's contact information and I would like to populate the textfields so that the user doesn't have to type in all his information when he wants to change something. I want to have him type in only the information he wants to change or update.

I already have the data displayed on the page. But now I would like to take the data and fill in the textfields with it.

Protect Local Mysql DB Access
I just password-protected an intranet site by including a password
authentication script in each page of a private section. The script
checks the login against the mySQL database. Appropriate file
permissions have been set up on the private directory.

My concern is now about protecting the Mysql password. Let's assume I
use Apache to protect the access to this password (<files></files> or
SetEnv in httpd.conf).

In my intranet directory, I have a public folder where I let users put
their html/php files to build their own pages.

How can I prevent a user from creating a php file like this :

$conn = mysql_connect($_SERVER['SQL_DB'],$_SERVER['SQL_USER'],$_SERVER['SQL_PASS'])
or die(mysql_error());

$sql = 'update user set private_access= Ƈ' where username =
'myself''
$result = mysql_query($sql) or die(mysql_error());

In that way, without knowing the Mysql pwd, any user can finally have
access to the private section.

Advice For Setting Up Local Hosting/mysql/php ?
this is going to sound dumb to most but here goes. Please keep in
mind, I am coming from a windows background.

I want to do some development using PhP and animated gifs. I see that the
patch can be applied to PhP 4.3.2 and 4.3.3 to enable imagegif and animate
functions. I have come to the realization that I am going to have to run
my own local linux server.

My question then is what do I need to install a local server to host web
pages from, I will also need a database. I want to run a typical hosted
site except I want to be able to easily create gif animations and I also
want access to ImageMagick. My current host has access to neither.

The installation of the MySql I think I can handle. It's the apache and
other web stuff part I think I am going to have trouble with.

So what do I need to run a typical host site then? PhP, Perl, cgi-bin,
MySql, Apache, umm?? Any good books or sites for setting up a server
step-by-step?

Transferring A MySQL Database From Local PC Onto An ISP Server
If I have an MySQL database on my local w2k, how do I transfer it onto my
ISP server?
The ISP gave me the name of an empty MySQL database they set up for me, the
username and the password with no further explanations.
I came here from ASP/Access where I was just uploading a mdb file into my
webspace.
But with MySQL there should be a different procedure,

Can't Connect To Local MySQL Server Through Socket
I created a test web form, that successfully input the data into my test database. However, today I created a second form, added the layout code, putting the layout and mysql connection details into a php include code.

These are the only changes I have made, apart from field names etc, but today, I get the following error message:

QuoteWarning: mysql_query(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/fhlinux177/f/further-flight.co.uk/user/htdocs/napsters/enter.php on line 50

Warning: mysql_query(): A link to the server could not be established in /home/fhlinux177/f/further-flight.co.uk/user/htdocs/napsters/enter.php on line 50

Your nap has been added to the database. Good Luck!
I checked, but the nap hasn't been added to the database.

I use the code I found on phpmac.com. It currently looks like this: Code:

Can't Connect To Local MySQL Server Through Socke
What does this mean. The code below is where its occuring:

Error retrieving records adam: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Code:

Cannot Make Connection To Local MySQL Server From Within Dreamweaver.
I am using OS X and Dreamweaver MX. I am trying to make a connection
to the MySQL Server from within Dreamweaver using the Applications
panel and clicking on the "+". A window opens asking for:
Connection Name: Apress
MySQL Server: localhost
User Name: apress
Password: xxxxxx
Database (Select):
When I click select so the Dreamweaver can browse to the databases in
MySQL the connection is not being made because Dreamweaver cannot find
the MySQL Server. I think that "localhost" is wrong even though I am
using the APRESS book: PHP Dreamweaver MX 2004 and it says to use
localhost. MySQL and PHP are on my local machine. I am NOT using a
remote machine. I used phpMyAdmin to create the databases.

MySQL Load With PHP
Would a medium sized (~500 pages) database driven website, search
engine and mailing list be too much for one MySQL database? Instead of
making using different databases I would use different tables. I would
use PHP for all of this.

Local Access Database To Shared PHP/MySql Hosting Export
My client has an MS Access database application on her local machine. I have
full access to that in terms of changing the design.

I've got a simple PHP/MySql application on shared hosting, so no direct
access to the db server.

I'd like to give her the facility to export the information in her local
Access application to the shared PHP/MySql site. From one command button (or
similar) in the Access application.

It would be probably be a complete overwrite. That is to say all the
information on the shared site would be overwritten with that from the local
machine.

I'm assuming that I'd have to make an HTTP request to some PHP page which
would then run the SQL to delete all the records, then append all the new
ones.

Is this the right approach? I don't want to spend weeks finding out that
this is fundamentally flawed in some way. The client has an ADSL connection.

Cannot Load MySQL Extension.
This is prolly the third windows box I've set up PHP/MySQL on, but for some reason this one is giving me greif. Anywho, PHP is successfully installed and running, apache works fine, and MySQL is running as a service. All sql/php modules are loaded up fine in apache's conf file, but when I try running phpmyadmin, I get this error:
'cannot load MySQL extension'

phpmyadmin documentation says:
"Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar. "

Now, I haven't been able to find this software package. Anyone know what could be causing this? I've never had this problem before.

Cannot Load A Mysql Extension
this simple matter but ý need a urgent need.
ý tried set phpMyAdmin on RedHat9 mysql3.23.54 php4.2.2 and apache 2.0.40 but when try to reach index page of PhpMyAdmin it gives me an error as "cannot load a mysql extension check php config" even if mysql.so is under lib/php4/.
What thing must change php config file?

Cannot Load Mysql Extension
I posted this to the sourceforge phpMyAdmin ng, but there was a comment
that it was properly a php question, so I'm posting it here.

I'm on Windows XP, and have just installed Apache, php 5, and
phpMyadmin from zipped binaries. The only thing irregular thing I’m
conscious of doing is unpack phpMyadmin, files and directories,
directly into Apache2htdocs, because that was the only place I knew I
could reach with the <http://localhost> syntax. The phpMyadmin book I’m
using focuses on domains, and not local file-based installations, so
I’m floundering a bit here.

I believe I have php flying, because I can use Firefox to browse to
http://localhost/phpinfo.php and see the HTML-like display in the
browser. I created a little echo-the-date .php and put it in
Apache2htdocs, it renders the date in Firefox properly. The
_SERVER["SERVER_SOFTWARE"] entry reported by phpinfo is “Apache/2.0.52
(Win32) PHP/5.0.2.”

I have uncommented extension=php_mysql.dll in php.ini, and set
extension_dir to "c:php5ext". I copied libmysql.dll and php_mysql.dll
to ..system32. In fact, I have nine copies of libmysql.dll in six
different file sizes on my system. (Could that be the problem-battling
DLLs?)

Per page 18 of Jason Gilmore’s “Beginning PHP 5 and MySQL,” I added
“index.php” to httpd.conf’s DirectoryIndex entry.

However, when I attempt to browse to <http://localhost/index.php>,
which is the configuration test for phpMyadmin, I get the dread--
cannot load mysql extension, please check PHP Configuration Documentation

I imagine this is some little thing in my.ini, httpd.conf, or php.ini.
Any suggestions?

Cannot Load MySQL Extension
I'm trying to run phpMyadmin and i iinstalled it on my redhat 7.2 and this is the message i get when i look load my index.php file.

CPU Load Problem On A Php/MySQL Linksite
I got a CPU load problem on my Php/MySQL based Link site. Site gets 6000-10.000 unique visitor and 120.000-180.000 page hits. Its not too many traffic I think. After my hosting (Shared) complained about CPU load 2 months ago I reduced MySQL queries and remove some sections on site. And indexed some table columns in my databas. But its not worked. Then I used a Cache system and included cached files on the site. Queries decreased 80%. But thats not decreased CPU load too. I have learnt "ob_start()" function uses CPU to compress file. I was using it for a long time and I removed it. Guess what,that's not worked too.

I wonder that how can I be sure what's making this CPU load. Which part of site or which code, function? In the logs MySQL skip-locking has most of the (CPU) resources . I heard some debug tool, benchmark tests. Is there a way to know whats going on in the code? What tool (script) do you recommend?

On my site outgoing links open in a new window and every link has a frame to count hits, commenting and voting. So every click makes a database connection to UPDATE hit value. I think this can make that CPU load problem.
But I tried to write these hit values to text file and import it to database time to time with cronjobs. But nothing has changed. Same old heavy site.

Now I'm going to try write whole database to the static pages. Like this forum every heavy traffic site uses this in there days. But I dont have that huge traffic I think. In this case I dont really understand this:

If I write 100.000 pages from database in every 10 minutes isn't that a big cpu and HDD load too? What is the catch?

I read in a forum search engine bots makes a really heavy traffic. I use mod_rewrite (Search Engine Friendly urls) on my site to spiders visit whole site. And I see that I got very frequent Google,Yahoo,MSN and other bot visits. But everyone wants that huh? Should I ban these bots with robots text or meta tags?

I dont understand how can 10.000 visitors make that problem. I see that in Cpanel up to %700 cpu load with a red sign. Shared hostings say they allow "10%-20%" CPU usage maximum. But my server's Root admin says 99% of system resources are free on Linux command line! So which one is true? But cpanel resets the server after some time with this cpu load. So hosting providers dont want my site...

Please help me to get rid off this problem. Especially I want to know what is my site's problem? I tried 3 hosting provider and same problem comes up. Do I need a dedicated host for this site? (!)

Load Multiple Pictures Into MySQL?
I'm trying to create a picture database for a site that I'm working on and I
would like to do the following:
- (main goal) Have a php script load an entire directory of photos into my
mysql database in one swoop.
- Display thumbnails on a general viewing page.
- allow for viewing individual pictures by clicking on the thumbnails.

<?php
error_reporting(E_ALL);
$id = $_REQUEST["iid"];
$link = mysql_connect("localhost", "root", "") or die("Could not connect:
" . mysql_error());

mysql_select_db("mysql") or die(mysql_error());
$sql = "SELECT b1 FROM t1 where id in (1,2,3)";

$result = mysql_query("$sql") or die("Invalid query: " . mysql_error());
header("Content-type: image/jpeg");

while ($row = mysql_fetch_array($result))
{
$fileContent = $row['b1'];

$im = imagecreatefromstring($fileContent);
$width = imagesx($im);
$height = imagesy($im);
$imgw = 50;
$imgh = $height / $width * $imgw;
$thumb = ImageCreate($imgw,$imgh);

ImageCopyResized($thumb,$im,0,0,0,0,$imgw,$imgh,Im ageSX($im),ImageSY($im));
ImagejpeG($thumb);

imagedestroy ($im);
imagedestroy ($thumb);
mysql_close ($link);
}
?>

It is only displaying one image.

Cant Solve Cannot Load MySQL Extension
Using Windows Installer on XP Pro SP2 with IIS5, phpMyAdmin, MySQL....trying
to get OSCommerce working and having a mare.

PHPMyAdmin ? Error - Cannot Load Mysql Extension
Good Day:
I installed my php5, mysql5, and Apaceh2.2.
and my configurations was:

PHP: (php.ini):
-----------------
extension_dir = "C:php5ext"

Uncomment this line:
extension=php_mysql.dll

Apache: (httpd.conf):
----------------------
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps

LoadModule php5_module "C:/php5/php5apache2_2.dll"

**it works As i write a simple program with php, i tried to use PHPMyAdmin after downloading it & put the folder of htdocs.

But it gives me that error.
----------------------------------

phpMyAdmin - Error

Cannot load mysql extension. Please check your PHP configuration. -
Documentation

-----------------------------

what about configuring phpMyadmin?

MySQL Causes High Cpu Usage And Load Average
I get high load average and high cpu usage from MySql and i thing its because of this query i recenty added (mostly the str replace) i already optimized it a bit ....

Triggering A Mysql Query On Page Load
I need to trigger a mySQL select query when the page loads. Is there
a way I can do this with PHP, javascript, or some other language?

Cannot Load Mysql Extension - Php_mysql.dll File Required.
I need php_mysql.dll file and where i can add this file...cause my sql server
shows a error that "Cannot load mysql extension"..

Optimizing MySQL To Make Site Load Quicker
I recently coded a site that is based mainly off of mysql. I currently query the database 4 times in two for() loops I'm not sure how to change it, because I see no other way. I can't put the queries outside of the loops because in the loop it queries something different every time.

I want some help optimizing it! However, I don't want to post all my code here, because it's basically the main part of my site, and I don't want others copying me.

Imap_header Prob
I'm trying to read only new mail from a mailbox and display it in a table.
What I'm doing is this (server data obfuscated):

$mail=imap_open('{SERVER}', 'ACC', 'PW');
if($mail){
$headers=imap_headers($mail);
// Get number of mail
$current=imap_num_msg($mail);
// Get content of mails retrieved, formated and presented
$header=imap_header($mail,$current);

for($i = 1; $i <= $current; $i++){
********$header=imap_header($mail,$i);
********$recent=$header->Recent;
********$unseen=$header->Unseen;
********if($recent*==*"N"*||*$unseen*==*"U"){
**process*mail*in*various*ways
**[snipped]

*
As I understand it (php.net on imap_headers) the if($recent == etc) method
is the way to get only new mail and ignore the rest. But I still get all
mail every time I open the mailbox.

Am I doing something wrong or is our slightly non-standard mail server
misbehaving?

Php Whois Prob
I borrowed this code from php.net but my problem is that this is working fine on the command line (php.exe -q whois.php) but when accessed through the browser i get an error message -- bad file descriptor(9) PHP Code:

Prob With Gdlib
May i know wats the prob with this function?
The program is:

<?php
var_dump(gd_info());
?>

and the output is like this:

Fatal error: Call to undefined function gd_info() in C:wampwwwimg
gdinfo.php on line 2....

I m trying to improve the color and brightness of the images in admin
panel dynamically.

Pear Prob
I am having a small problem using Pear.

I am trying to install a web application which uses pear, unfortunately
I am getting some errors.

You can visit the page here to see the error:

My phpInfo(); results can be viewed here:

I am using a Linux VPS server which I access remotely.[color=blue]
>From the root of the server pear is located at:[/color]
/usr/share/pear

Similarly, from the root of the server my site is hosted at:
/

Md5 Prob - Display Related
I have set up a basic user registration form on my site URL and all the info ins successfully transferred to the MySQL database.

The problem is that after a user has submitted his info a confirmation page loads URL telling the user their username and password. The thing is it displays the md5, i.e. the encryted password. Is there an alternative to md5 that will also add an encytped password to the db or is there a reverse operation I can run on the md5?

I have only been learning for the past few days so go easy. Below is the 'submitform.php' php code I use. PHP Code:

Php Email Headers Prob
I am working through "Beginning PHP5 Web Development", by WROX, and I am
having trouble sending HTML email messages in one application. The email
goes through, but is displayed only as text/plain not text/html.
Here are the headers:

Date: Wed, 25 Oct 2006 14:05:03 -0400
To: XXX@gmail.com
Subject: Please Confirm your postcard
MIME-Version: 1.0
Content-type: multipart/alternative; boundary="==MP_Bound_56gdfg56gd56gg=="
From: no-reply@postcardorama.com
X-vif-MailScanner-Information: Please contact the ISP for more information
X-vif-MailScanner: Found to be clean
X-vif-MailScanner-From: no-reply@postcardorama.com

This is a Multipart Message in MIME format
--==MP_Bound_56gdfg56gd56gg==
Content-type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><body>(html)Hello glennsend,

Please click on the link below to confirm that you would like to send this
postcard:

<center><table width="500" border=0 cellpadding="4"><tr><td>Greetings, glenn
rec!</td></tr>
<tr><td>glennsend has sent you a postcard today.<br>Enjoy!<td></tr><tr><td
align="center"><img src="http://localhost/mail/postcards/congrats.gif"
border="o"></td></tr><tr><td align=center></td></tr><tr><td
align=center>Enter your message here:

</td></tr></table></center>

<a href="http://localhost/mail/confirm.php?id=1b55d1414b145e3170f70e111336e437">
Click here to confirm</a></body></html>
--==MP_Bound_56gdfg56gd56gg==
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

(text)Hello glennsend,

Please visit the following URL to confirm your postcard:

http://localhost/mail/confirm.php?i...0f70e111336e437
--==MP_Bound_56gdfg56gd56gg==--

And the relevant PHP code:

$boundary = "==MP_Bound_56gdfg56gd56gg==";
$headers = "MIME-Version: 1.0
";
$headers .= "Content-type: multipart/alternative; boundary="$boundary"
";

$message = "This is a Multipart Message in MIME format
";
$message .= "--$boundary
";
$message .= "Content-type: text/html; charset=iso-8859-1
";
$message .= "Content-Transfer-Encoding: quoted-printable

";
$message .= $confirmmessage . "
";
$message .= "--$boundary
";
$message .= "Content-Type: text/plain; charset="iso-8859-1"
";
$message .= "Content-Transfer-Encoding: 7bit

";
$message .= $textconfirm . "
";
$message .= "--$boundary--";

If someone can tell me why this does not appear as html,

Dynamic Link Prob.
header("Location: http://www.blah.com/mocks/functions.php/?id=".$res1['teamid']."");

This must be the wrong way to send this.

Prob In PhpMyAdmin On IIS Installation On Windows XP
I have PHP installed on a Windows XP platform using IIS as
server. When updating a MySQL database field set to MEDIUMTEXT
in phpMyAdmin, the transaction seems to fail if the text contains
more than a few hundred characters.

The update is actually made successfully, but afterwards, the server
cannot locate the phpMyAdmin page as requested by the client
browser. I get a "Page cannot be found" error. Clicking
on Update from the browser clears the problem.

Anyone know what's causing the problem? Potential sources
of the problem could be with the driver for MySQL, with the IIS
settings, or with the phpMyAdmin settings. I suspect IIS.