On Tue, Mar 8, 2011 at 11:16 AM, Ron Piggott
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 1-800-
> - BUT I don’t
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, Mar 8, 2011 at 11:16 AM, Ron Piggott
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
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
On Tue, Mar 8, 2011 at 11:16 AM, Ron Piggott
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 1-800-
> - BUT I don’t
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 of
be a push in the right direction (I
hope).
Hope this helps.
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 th
al 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? What is the mysql_error() returning to you?
I'd also recommend you
--Original Message-
> 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.
>
>
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 $
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
ED]>
Sent: 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
> $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, usin
i'm new in studing php/mysql so HELP ME! :) thx
the query doesn't flow...
What's wrong in this code?!
in the DB there are 2 tables, here you are the queries to create them:
-table autori:
CREATE TABLE autori (
nome varchar(50) NOT NULL default '',
mail varchar(50) default NULL,
PRIM
> -Original Message-
> From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
> Sent: 10 December 2002 20:02
>
> 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 witho
> 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
> ch
, SCOTT V (SBCSI); '1LT John W. 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 th
> To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Update Query Help...
>
>
> > $tmp = $_POST['sbcuid']."-".$_POST['system'][$a];
> > $update = "UPDATE accounts SET atime='NOW()' WHERE
> > \"id-sys\&q
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] Update Query Help...
> $tmp = $_POST['sbcuid']."-".$_POST['system'][$a];
> $update = "UPDATE ac
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
le.
Cheers
Jason
-Original Message-
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.
> $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
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
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 th
> 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 M
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 + "mor
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 f
TECTED] <[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
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 I'm
Hi Francesco,
Probably the easiest way is to load the records from table 2 into an
array and then lopp through updatign table 1
HTH
Steve
At 9:37 AM +0200 28/3/01, Francesco D'Inzeo wrote:
>Hi everyone.
>
>The scenario:
>
>Table1 Table2
>Field_01, <- Same as -> Field_01,
>
Hi everyone.
The scenario:
Table1 Table2
Field_01, <- Same as -> Field_01,
Field_02, <- Same as -> Field_02,
Field_03, <- Same as -> Field_03,
Field_04, <- Same as -> Field_04,
Field_05, Field_05,
Field_06, Field_06,
Field_07,
30 matches
Mail list logo
