In PHP, you can see the error message as follows:
$result = mysql_query($sSQL) or die ("".mysql_error()
."".$sSQL);
Just change it to write that mysql_error() to a file instead and that'll do
it. So, something like:
$result = mysql_query($sSQL) or die ( log_error(mysql_error()) );
where y
I'm not sure if this falls under a PHP topic or a MySQL topic, but I have a
table that contains a field that stores serialized data. Is there a way to
order a recordset by a piece of the serialized data? For example, if a
field called "data" contains serialized data that looks like this:
a:1
From: "Subscriptions" <[EMAIL PROTECTED]>
To:
Sent: Sunday, December 11, 2005 9:46 PM
Subject: Joins on tables with funky data?
Okay, so I haven't been able to find any corrupted tables. Has anyone ever
run into problems with joins between tables that contain funky data? I h
od_id = ag_admin_cart.paymethod_id
WHERE cartid = ".$_SESSION['cartid'];
Jenifer
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To:
Cc: "Subscriptions" <[EMAIL PROTECTED]>
Sent: Monday, December 12, 2005 11:25 AM
Subject: Re: Joins on tables
rruption, but
the tables check out fine.
Jenifer
- Original Message -
From: [EMAIL PROTECTED]
To: Subscriptions
Cc: mysql@lists.mysql.com
Sent: Sunday, December 11, 2005 11:15 PM
Subject: Re: Joins on tables with funky data?
"Subscriptions" <[EMAIL PROTE
Okay, so I haven't been able to find any corrupted tables. Has anyone ever run
into problems with joins between tables that contain funky data? I have a
table that contains encrypted info and some of the characters being used/stored
are definitely odd.
I'm still trying to find the answer to o
Hi all,
Say, is there a way to tell if a table has been corrupted? We're having some
weird things happening and the only thing I can think of is possible corruption
of a table, but is there anything you can do to find out?
Jenifer
Me, too. One thing that's a plus for my clients is to tell them that is
will cost them less if I develop in php/mysql as opposed to ASP/MSSQL.
Hosting is cheaper and I can do things in PHP that takes 5 lines as opposed
to ASP/MSSQL which takes 20. heh
Jenifer
- Original Message -
D'OH! You're right. heh So much for the degree in computer science. lol
Jenifer
- Original Message -
Subscriptions wrote:
Er... do you mean this instead?
>
> UPDATE your_table
> SET decimal_field = decimal_field + (0.15 * decimal_field);
No, but the
Er... do you mean this instead?
UPDATE your_table
SET decimal_field = decimal_field + (0.15 * decimal_field);
Would this work?
Jenifer
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Subscriptions" <[EMAIL PROTECTED]>
Cc:
Sent
I have a decimal field in my table... what would be the query to add 15% to
that number in every row? I need to mark the column up by 15% and want to make
sure I get the query right the first time. heh
Jenifer
There used to be a program called "AccessDump" that will dump access tables
into .sql files. Their website seems to be unresponsive at the moment,
though.
Here's a link:
www.AccessDump.com
They are from the south, so it's possible that the site was affected by the
hurricane.
Jenifer
-
Okay, I asked the web host guys and this is what they said:
"Hi Jenifer, we only use single instances of MySQL so the master/slave
replication issue would not be possible. As far as I know, the only way a
delayed update could occur would be if you had multiple updates queued
behind a slow upd
hmmm... let me ask the guys how they have it all set up.
Jenifer
- Original Message -
How is your MySQL installation set up? At my company, we have a
master server and several slaves replicating off that master. All
inserts/updates go to the master, and all selects go to the slave
Hi all,
I'll give you a little background so that my question is put into context.
I've already posted this question to my local programmers message group and
they said to post it here. So, here it goes:
I have a phone order system that I wrote in PHP. It has a series of pages
starting with
The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
I've looked through google and I can't find anything that makes since to me.
Can someone point me in a direction as to where I can find this out?
The problem I'm having is I have PHP 4.3.2, MySQL 4.0.13 and Apache 2.0.46.
I have
Just a quick question regarding how (if at all) MySQL's binary update log
consumes resrouces as it records modifications to various tables in the
database.
Are there any potential performance issues or limitations to be
expected (other than excessive consumption of diskspace) if this log is
not f
OBLIGATORY TOPIC REFERENCE TO BYPASS FILTER: mysql
Just a quick question regarding how (if at all) the binary update log
consumes resrouces.
Are there any potential performance issues or limitations to be
expected (other than excessive consumption of diskspace) if this log is
not flushed/rotated
18 matches
Mail list logo
