No...
UPDATE table SET value1 = value1 + increment
Or...
UPDATE table SET value1 = value1 * multiplier
...and so forth...
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 28, 2001 5:06 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Updating a r
Sarcasm be damned. If it's MySQL, then
http://www.mysql.com/doc/
and it's searchable.
I've worked with four SQL databases and they are similar enough that I always
have to refer to the docs when things stop working. Tricks in one don't necessarily
work in the others. You need to look at the UPD
If there are variables you dont want passed in the
link, just use sessions. nothing wrong with using both
olinux
--- Bogdan Stancescu <[EMAIL PROTECTED]> wrote:
> So many suggestions, so little time! The URL thing
> is a great idea if you don't
> have any problems with users seeing the variables
Yes I got that much...
So it would be
UPDATE tblname SET value1 + $value1?
"David Piasecki" <[EMAIL PROTECTED]> wrote in message
000201c18ffd$a8187ec0$a6ccb0d8@pc5">news:000201c18ffd$a8187ec0$a6ccb0d8@pc5...
> You missed the first place you should have looked, the manual page on
> the 'UPDATE' s
You missed the first place you should have looked, the manual page on
the 'UPDATE' syntax:
http://www.mysql.com/doc/U/P/UPDATE.html
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 28, 2001 4:06 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Up
That isn't the answer I was looking for...
Since you are so nice could you be so kind in point me
where these golden docs are? I looked all over php.net and mysql.com,
nada not only that the three books I have as well. I am a newbie at
this, and do need a bit of hand holding thanks...
"Mi
Yup, that's the roulette selection, as they call it. It's pretty simple,
actually. The idea is that you use a concept similar to a roulette table,
just that the sectors aren't equal -- they're equal to their respective
weights. The procedure is as follows:
1. Assign the weighting to each of the p
I have an internal project I'm working on where I
would like to randomly send visitors to different
pages, but, I want to be able to give some pages a
better chance of getting shown.
So, my thought was that I would have a database table
that had records for each URL and it's weight. Then,
the pr
So many suggestions, so little time! The URL thing is a great idea if you don't
have any problems with users seeing the variables being passed by your script
(not that this was the issue I had in mind when I suggested my solution - it
just skipped my mind).
So, if you'd rather implement the forms
better yet, have a starting page multiplied by the page length
define a constant that gives the page limit then have the receiving page do
some math and do a mysql_data_seek() or array_seek() (which ever you are
using) and then limit the returns by the page limit size?
wouldn't that be the easie
Aren't all these form solutions making things more
complex than they need to be? Why not just pass the
parameters in the URL
Use php to echo out start_at and end_at variables
ie. http://website.com/search.php?keyword=something&start_at=15&end_at=30";>2
http://website.com/search.php?keyword=somet
Read the docs for the database in question. They will tell you what is and is not
allowed.
Miles Thompson
On Friday 28 December 2001 06:26 pm, Todd Williamsen wrote:
> Ok
>
> So to update a record lets say...
>
> I have a current value of 150 and the new value will be 250 now how would I
>
Ok
So to update a record lets say...
I have a current value of 150 and the new value will be 250 now how would I
total them to equal 400?
I was thinking
$sql = "UPDATE $table value1 = value1 + ?
is that correct? how do you update it with simple math?
What about division...
take the cu
Ok, here's what I have so far for my expiration date (thanks to Kevin) but
its returning incorrect dates:
function add_to_now($timestamp,
$seconds,$minutes,$hours,$days,$months,$years) {
$mytime =
mktime(1+$hours,0+$minutes,0+$seconds,1+$months,1+$days,1970+$years);
return $timestamp + $mytime;
Sure! If you need more help let me know - I can send you some code.
-Natalie
> -Original Message-
> From: Leotta, Natalie (NCI/IMS)
> Sent: Friday, December 28, 2001 11:57 AM
> To: 'Mihail Bota'; Bogdan Stancescu
> Cc: Karthikeyan; [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Pas
You could make hidden vars in your HTML page (in a form that submits to your
PHP), alter their values in the JS, and then when you submit to the PHP it
will have those. Then you can use $HTTP_POST_VARS to access the variables
from inside the PHP. There might be an easier way, but I know this way
Bogdan, in this respect, I have a question: can I pass the values of
javascript variables to php variables? if yes, how?
Mihai
On Fri, 28 Dec 2001, Bogdan Stancescu wrote:
> I don't understand why you won't use forms with buttons and hidden controls
> since you know about this solution. I have
I don't understand why you won't use forms with buttons and hidden controls
since you know about this solution. I have two suggestions along this line:
1. You probably don't want buttons on the page -- you may use image icons
instead (similar to a tape recorder's "play" and "fast forward" for next
Hi There ..
I used to be running php before on windows xp iis 5.1. Everything worked
fine.
It was installed by copying the php_mssql70.dll to the system folder and
uncommenting this in the php.ini file.
Now i have downloaded the new version and tryed to install it and get it
configured but im ha
Dear members,
I am querying a Mysql database, which will result in 100 of records. I want
to display 10 records in each page. First page it is working fine. When I
navigate to second page it is not working.
When I used hidden controls. Hidden controls send the details to next
page only by usin
Hi to everybody,
Im trying to use persistents connections to an Oracle Database through PHP,
for manageing transactions, and have some problems.
My Schema:
* Web Server: Apache 1.3.22 on a Linux RedHat 7.0
* PHP: 4.1.1 compiled with oracle module functions (OCI*)
* Data Base: Oracle 8.1.7 on a
21 matches
Mail list logo
