Dave M G wrote:
PHP List, MySQL List
In my PHP environment, I have "Magic Quotes" turned off, and I use the
mysql_real_escape_string() function clean strings of SQL syntax before
inserting them into my database.
So the data stored in my database does not have escape characters in
it. Partic
It's possible that there is an .htaccess file in phpMyAdmin that has
Magic Quotes on that is messing you up...
Other than that, it's specific to phpMyAdmin, so maybe ask those guys
what they did...
On Sat, March 1, 2008 7:38 pm, Dave M G wrote:
> PHP List, MySQL List
>
> In my PHP environment, I
Whoops, finished my thought too early. I was going to append, should
we also have UserId, PreferenceId be the PRIMARY KEY? Then possibly a
secondary index on UserId in case I ever want to get all preferences
for a user?
On Sun, Mar 2, 2008 at 6:18 PM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> But i
But if you're using a varchar for the purposes of getting a list, you
might as well store it in a more compact format like int or SET. The
only benefit (which shouldn't be ignored) is that you have a
human-readable string to parse, right?
It seems like most people ended up with a normalized forma
Hello,
I've just read through the MySQL documentation about Unicode support,
collations and how it affects sorting and comparison of strings. And I
find it horrible, at least. I feel like I'm back in the MySQL 3.x days
where I used UTF-8 in my application and MySQL treated it binary. The
only
Good Morning Eli
I would consider implementation of mpm_common more specifically enabling
inter process communication with mutex's such as what you see at
http://httpd.apache.org/docs/2.0/mod/mpm_common.html#acceptmutex
and then utilising the flock directive to either lock/unlock a file such
such
Yes, you are exactly right. The schema is the structure of the database.
Keith
> I've been referencing a variety of sources, including wikipedia. What I
> know about a schema is that in SQLite the .schema command will show the
> the SQL structure of that databases tables, which would be analogo
Hey there
I have an external script that generates a lot of data and dumps it into a
table.
Prior to this ,it removes all the data in this specific table.
It requires both read and write privileges.
The web site on the other end reads all the data from the table and
generates standard ht
I've been referencing a variety of sources, including wikipedia. What I
know about a schema is that in SQLite the .schema command will show the
the SQL structure of that databases tables, which would be analogous to
"DESCRIBE foo" in MySQL (with the difference that SQLite shows all tables
in o
