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
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
How do you know it failed? What is the mysql_error() returning to you?
I'd also recommend you echo out the query to the browser window before
sending it so you can see exactly what's being sent to the database. That'll
help you troubleshoot SQL problems on your own.
> -Original Message-
>
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
> -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
is it a mysql field type of datetime?
if so, you may want to use this instead
$timestamp=date("Y-m-j H:i:s");
$update = "UPDATE accounts SET atime='$timestamp' WHERE id-sys='$tmp'";
that puts the current timestamp in mysql format for entry into your table.
Cheers
Jason
-Original Message
> $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
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
Hi,
The query code seems fine to me - did you try to otput $query to see if all
the variables you are using are OK. May be $order,$stationid or $orderNewsID
is misspeled or is not set properly.
HTH
Dobromir
-Original Message-
From: Jay Paulson <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <
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,
>
22 matches
Mail list logo
