In PHP, you can see the error message as follows:
$result = mysql_query($sSQL) or die (br.mysql_error()
.brbr.$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()) );
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:
: Subscriptions [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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 have
= ag_admin_cart.paymethod_id
WHERE cartid = .$_SESSION['cartid'];
Jenifer
- Original Message -
From: Roger Baklund [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Cc: Subscriptions [EMAIL PROTECTED]
Sent: Monday, December 12, 2005 11:25 AM
Subject: Re: Joins on tables with funky data?
Subscriptions aka Jenifer
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
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
.
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 PROTECTED] wrote on 12/11/2005 10:46:08 PM:
Okay, so I
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 -
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
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: mysql@lists.mysql.com
Sent: Monday, October 03
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 they do the same thing
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
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
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
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
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
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
18 matches
Mail list logo