I am wondering if there is a way to do an UPDATE query where only some of the
text changes.
The column I need to modify is named “toll_free”
What I need to search for is: 800-
I need it to replace it with is 1-800-
- BUT I don’t want to change instances of 1-800-
- I need to leave the rest
On Tue, Mar 8, 2011 at 11:16 AM, Ron Piggott
ron.pigg...@actsministries.org wrote:
I am wondering if there is a way to do an UPDATE query where only some of the
text changes.
The column I need to modify is named “toll_free”
What I need to search for is: 800-
I need it to replace it with is
I was wondering this Bastien. Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
-Original Message-
From: Bastien Koert
Sent: Tuesday, March 08, 2011 11:20 AM
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] UPDATE query
On Tue
, March 08, 2011 11:20 AM
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] UPDATE query
On Tue, Mar 8, 2011 at 11:16 AM, Ron Piggott
ron.pigg...@actsministries.org wrote:
I am wondering if there is a way to do an UPDATE query where only some of
the text changes.
The column I need
Hello, I ma new to the list and looking for some help with the following
query.
insert into Temp (CompId) SELECT distinct(company_id) from Associations
where product_id=9;
When I exe that statement directly on the mysql command line It exe's with
no problem. However when I
exe that through php
-
From: Aaron Bryer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 3:02 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Update Query
Hello, I ma new to the list and looking for some help with
the following
query.
insert into Temp (CompId) SELECT distinct(company_id) from
the select statement but that seamed to make
more errors
Thanks
Aaron
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 3:07 PM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Update Query
How do you know it failed
.
Rich
-Original Message-
From: Aaron Bryer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 3:18 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Update Query
I did that below is the exact excerpt from the source of the
web browser
!--insert into Temp (CompId) SELECT
Hi,
I have (amogst others) three tables in my database named Bookings, User, and
Representative. A User and a Representative are different types of user,
however I now want to merge these tables into one - User. When a Booking is
made, the User_ID and the Rep_ID are stored in the Booking table. I
$query1 = UPDATE news,autori SET
news.titolo='$titolo', news.testo='$testo',
news.data='$data', news.nome='$nome',
autori.mail='$mail' WHERE news.nome =
autori.nome AND id='$id';
You can't do an update across tables the last time I checked. Even if it's
possible in newer versions, using
: Monday, July 14, 2003 2:32 PM
Subject: Re: Re: [PHP-DB] UPDATE query
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I am attempting to UPDATE a table and I have having absolutely ZERO
success. Here is the query:
$tmp = $_POST['sbcuid'].-.$_POST['system'][$a];
$update = UPDATE accounts SET atime='NOW()' WHERE
\id-sys\='.$tmp.';
echo $update;
$result1 =
$tmp = $_POST['sbcuid'].-.$_POST['system'][$a];
$update = UPDATE accounts SET atime='NOW()' WHERE
\id-sys\='.$tmp.';
echo $update;
$result1 = mysql_query($update, $Prod) or die(mysql_error());
echo mysql_affected_rows();
Try:
$update = UPDATE accounts SET atime=NOW() WHERE id-sys='$tmp';
-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 1:35 PM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] Update Query Help...
I am attempting to UPDATE a table and I have having absolutely ZERO
success. Here is the query:
$tmp = $_POST['sbcuid
SCOTT,
I am attempting to UPDATE a table and I have having absolutely ZERO
success. Here is the query:
$tmp = $_POST['sbcuid'].-.$_POST['system'][$a];
$update = UPDATE accounts SET atime='NOW()' WHERE
\id-sys\='.$tmp.';
echo $update;
$result1 = mysql_query($update, $Prod) or
. Thanks again for the help. Hopefully
someone will come up with something to help me get this working.
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 1:45 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: [PHP-DB
. Holmes'; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Update Query Help...
SCOTT,
The list's crystal ball filter is down for maintenance.
Show us the tbl schema and the debug print of $update.
Then we won't be firing blind!
=dn
I understand that the column name does not normally need quotes
I have definitely isolated the problem. If I change the column name
that the match is being performed on from 'id-sys' to 'id_sys' I can
execute
the query without having to worry about quoting the column name and
everything works. I think that I am just going to leave the column name
hello all:
I need to be able to update a field in MySQL, the catch is that I have to add on to
text that is already there and I have to be able to do it within MySQL (phpMyAdmin).
My first idea was to do:
SET prod_desc = prod_desc + more info to tack on to end
but this is a mathematical
At 9:06 -0800 1/28/02, Adv. Systems Design wrote:
hello all:
I need to be able to update a field in MySQL, the catch is that I
have to add on to text that is already there and I have to be able
to do it within MySQL (phpMyAdmin). My first idea was to do:
SET prod_desc = prod_desc + more info
SET prod_desc = prod_desc + more info to tack on to end
but this is a mathematical function which returns 0!
update table set field = concat(field, more info) where id = 1;
find the string functions in the mysql manual...
with kind regards,
Joffrey van Wageningen
--
PHP Database Mailing
Hello Adv. Systems Design,
I need to be able to update a field in MySQL, the catch is that I have to add on to
text that is already there
and I have to be able to do it within MySQL (phpMyAdmin). My first idea was to do:
SET prod_desc = prod_desc + more info to tack on to end
but this is a
] [EMAIL PROTECTED]
Date: Tuesday, October 02, 2001 2:22 AM
Subject: [PHP-DB] Update Query?
Hello-
I'm trying to run an update query in an application I'm making. I keep
getting a MySQL error however when I try and print out the mysql_error()
nothing is returned. I run the same query in phpMyAdmin
Hello-
I'm trying to run an update query in an application I'm making. I keep
getting a MySQL error however when I try and print out the mysql_error()
nothing is returned. I run the same query in phpMyAdmin and the query runs
fine. Below is the update query I'm running and the php code that
24 matches
Mail list logo