Hopefully someone can help me out with this -
I have two tables in mySQL: comments and diary
I want to populate a new field in comments with the current values of diary
- but only if they meet certain criteria.
Now, the problem is this - my webserver is using an older version of mySQL
that does
One of the first things that I did at my former job was to turn off all
external-facing network adapters to our DB machines. If you're fortunate
enough that your DB resides on it's own box and not the webserver itself,
then there's really no reason that you *need* to have it externally facing.
Ther
Would that help at all - since the COUNT(*) would execute fully and then
MAX would limit it? (or is the order of operations different than that?)
-M
-Original Message-
From: Yves Goergen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 10:26 AM
To: Mojtaba Faridzad; [EMAIL PROTECTE
I have PHP, mySQL and phpMyAdmin all running with IIS on a WinXP Pro
laptop as a protable dev box.
It's more PHP & mySQl dependant than it is OS dependant.
-M
-Original Message-
From: Louie Miranda [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 10:52 PM
To: Michael G. Tracey; [E
You'd want to use a BLOB (binary large object) if that's what your goal
is.
But if you're using this for a web application I'd highly suggest that
you instead save images to a directory and make a reference to the path
in the database. If you have many BLOB inserts or selects on a site,
your datab
Addslashes()
http://us3.php.net/manual/en/function.addslashes.php
-M
-Original Message-
From: Steve Marquez [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 4:28 PM
To: MySQL List; PHP eMail List
Subject: Characters
I am inserting a file via a PHP form. It works great, however, i
Ben, this is really a question you have to pose to them.
Many "professional" ISPs won't just automatically upgrade to the newest
version of X before taking the time to create a full test environment to run
through any and all circumstances that they think they might come across.
Also, a new versi
As Bhavin stated, ENUM is one way to do this, but you can (and should)
validate all data in your scripts prior to entering it in your database.
(assuming that you're not just using the command-line interface and have an
actual GUI)
All user-supplied information should be checked for validity - and
