How can I update only N fields from the database?
usually we do:
UPDATE table1 SET field='VALUE' WHERE condition1
now I want to update fields with a certain condition but only X fields out N
total fields.
ie:
id value
--- ---
1a
2b
3c
4d
5e
how can i update such lik
Hi again.
$result = mysql_query("SELECT id FROM table");
$id_array = array();
while ($r = mysql_fetch_array($result))
$id_array[] = $r["id"];
// now $id_array[] is an array of IDs that was grabbed from the database.
Any faster and/or better approache to build the $id_array?
--
PHP Gener
NuSphere is also available for Windows. I am running it on my Windows 2000
workstation, but it is also available for 98/ME, etc..
-Original Message-
From: B. van Ouwerkerk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 12:20 AM
To: Ralph Guzman; Kyle Smith; [EMAIL PROTECTED]
S
Sounds like a strange request, what are you trying to do?
I don't think you can do this directly in mysql, but you could build an
array of results in php.
eg something like (crappy code below)
//Grab results
$db = mysql_connect($db_domain, $db_user,$db_password);
mysql_select_db($db_databasenam
I'd always understood that mysql doesn't allow multiple statements to be
submitted so this post obviously worried me. I did some tests and confirmed
that this is not a problem in MySQL queries from PHP. If I'm wrong about
this please let me know.
Tim
--
From: scott [gts]
I have WindowsNT4 Serv & PHP 4.0.6/CGI
My php.ini includes:
(...)
session.save_handler = files
session.save_path = /tmp
session.use_cookies = 1
(...)
Problem: When I run PHP script which uses sessions (commands like session_start()
etc.) the session file IS created in /tmp BUT cannot be received
Hi,
Two things:
1. PWS from the CD has a bug, you need to get the patch from MS. The
problem is with the MTS.
2. I use Badblue www.badblue.com for easy, fast development. I also
recommend Apache above IIS or PWS.
Cheers
BK
"Kyle Smith" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED
Ok have installed PHPTriad, when i run apache
(gulp) dos opens, all fine BUT when i run PHP.exe well look down (sorry if
im not allowed to post pictures but, its small!)
-lk6-http://www.StupeedStudios.f2s.comHome
of the burning lego man!
ICQ: 115852509MSN: [EMAIL PROTECTED]AIM:
Someone purchased items from my site let's say 3 items out of 5 total. All
items are the same. I just want to update 3 items status to "Reserved".
When he buy he just tell how many and not which ones.
"Lawrence Sheed" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]
Kyle Smith wrote:
> Ok have installed PHPTriad, when i run apache (gulp) dos opens, all fine
> BUT when i run PHP.exe well look down (sorry if im not allowed to post
> pictures but, its small!)
That attachment was apperantly chopped off.
If you want to post a file on this list, just upload
Have you thought about your database design carefully?
You might want to create a column for item count
eg
id, item name, items in stock
1, frog, 7
if, say a customer orders 3 frogs, decrement the items in stock by 3.
Just an idea...
Do you know about database normalization? How is the
(the damn thing took my attatchement off!!!)
Ok I have installed PHPTriad, when i run apache (gulp) dos opens, all fine BUT when i
run PHP.exe well look down
http://www.stupeedstudios.f2s.com/probs.gif
-lk6-
http://www.StupeedStudios.f2s.com
Home of the burning lego man!
ICQ: 115852509
M
> -Original Message-
> From: Richard Kurth [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 5:36 AM
> To: php
> Subject: [PHP] URGENT!!! Can't start Apache with php4 and mysql
>
>
> I have read the archives for this problem but I can't seam
> to fix it. This is on a RedHat
Could someone please help me sort out a database on this so i can find out if php
works, OR could you people please send me any scripts you have cause i just got php
working on my pc and i wanna know what its capable of.
-lk6-
http://www.StupeedStudios.f2s.com
Home of the burning lego man!
IC
Looks fine to me
Miles
At 10:31 AM 8/2/01 +0200, elias wrote:
>Hi again.
>
>$result = mysql_query("SELECT id FROM table");
>$id_array = array();
>
>while ($r = mysql_fetch_array($result))
>$id_array[] = $r["id"];
>
>// now $id_array[] is an array of IDs that was grabbed from the database.
>
>
Veniamin,
You can use OpenLink's Multi-Tier ODBC drivers for this.
Compile PHP --with-iodbc as per the HOWTO at www.iodbc.org.
The presence of the iODBC Driver Manager will let you use any ODBC drivers,
and then you can do compariative testing.
Our drivers download with a free non-expiring 2-us
Richard,
I've sometimes had to take a couple of swipes at this, trying both
/usr/local/mysql/lib
and
/usr/local/mysql/lib/mysql
And does libmysqlclient.so.10 have a symlink to something like
libmysqlclient.so.10.0.0
And because I just checked a second machine, where mysql is installed in a
com
try using single quotes :
preg_replace("/\$(\w+)/e", '${$1}', $template);
> -Original Message-
> From: Ryan Fischer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 01, 2001 6:37 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Replacing template variables with values?
>
>
> Hello! :)
Thanks!
That was exactly what I was looking for!
"Andras Balogh" <[EMAIL PROTECTED]> wrote in message
news:011f01c11b39$174c0b70$[EMAIL PROTECTED]...
Hi,
Use limit :
update mytable set status='Reserverd' where purch_id=1 limit 3;
This is mysql specific i think so it won't work with other db.
> if ( ( mysql_result($db_result,$db_record,'order_date')=00)
Uh, huh? Just try ==0 there. Not =000
-Rasmus
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list
Oops, Correction - You'll need to run apache first, leave it running, and
then try the below.
not enough coffee today...
-Original Message-
From: Sheed, Lawrence -SHNGI -AG
Sent: August 2, 2001 5:51 PM
To: 'Kyle Smith'; [EMAIL PROTECTED]
Subject: RE: [PHP] <- BEING AN ASS CLICK HERE
"Kyle Smith" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> zillion is actually a number?
Yes, a number performed by some old cartoon, anime style :-)
> i just downloaded a program which reads out
> text for you cause it just gets really boring reading the text, so now its
>
hmmm, i am seeing the same thing as tim here. are we doing something wrong?
i created a test table, entered some dummy data and then using scott's
example of "'; DELETE FROM seminar; " i tried executing
insert into test values (0,''; DELETE FROM test; ',1);
and got this error
ERROR 1064: You
FUD!
"Kyle Smith" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Whats the difference between ASP and PHP cause ASP has gotta have something
good about it cause microsoft uses it!
-lk6-
http://www.StupeedStudios.f2s.com
Home of the burning lego man!
ICQ: 1
I have tried the virtual() command but keep receiving error - undefined
function, can someone give an example in how to use this ?
- Original Message -
From: "Dave.O" <[EMAIL PROTECTED]>
To: "php" <[EMAIL PROTECTED]>
Sent: Thursday, August 02, 2001 4:26 PM
Subject: [PHP] shtml or php ??
Which is the best language to use, php or shtml, I use only a couple of SSI
commands in shtml to call in headers and footers, and run cgi scripts as
below. I thought maybe as I am getting more into php that I should change
the files from shtml to php, and use the equivalent commands to call in
he
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi All,
I'm currently just playing around with a few things and want to
write a script that will listen on a UDP port and then log/process the
information. The problem i have it that i don't know if php can do this. I
know that you can connec
Whats the difference between ASP and PHP cause ASP has gotta have something good about
it cause microsoft uses it!
-lk6-
http://www.StupeedStudios.f2s.com
Home of the burning lego man!
ICQ: 115852509
MSN: [EMAIL PROTECTED]
AIM: legokiller666
on 8/1/01 11:22 PM, Richard Lynch at [EMAIL PROTECTED] wrote:
>> caveat--if there are some options that most folks would reasonably call
>> 'optional' or 'dangerous', these shouldn't be expected. i am pretty new at
>> programming and php, so i have no idea if things like this exist. i
>> personal
Hi,
I'm in a process of doing site with MySQL database, and most of
the code I plased in index.php3 (in one file) but I've got some
problems with statements:
I have:
if (isset(...)) {
...
}
elseif (isset(...)) {
...
}
elseif (isset(...)) {
...
}
else {
...
}
IT DOESNT WORK!
but when I do:
i
I'm using a query similar to:
select tableA.*, tableB.* from tableA,
left join tableB ON tableA.keyfield = tableB.keyfield
When I then try to access the column "keyfield", after using
mysql_fetch_object() e.g.
$resultObject->keyfield
I get no value returned. What is the correct way to
Hi all ---
I'm having some trouble getting basic authentication working. Either that
or my privileges are screwed up, or something.
I am running Apache on Windows 2000 and PHP4. I've searched newsgroups,
this mailing list, various FAQs and the manual, I think my eyes are
crossing. I've got a
> Which is the best language to use, php or shtml, I use only a couple of SSI
> commands in shtml to call in headers and footers, and run cgi scripts as
> below. I thought maybe as I am getting more into php that I should change
> the files from shtml to php, and use the equivalent commands to ca
On 02-Aug-2001 Frédéric Mériot wrote:
> Thanks a lot, but I must precise that I'm running PHP (4.0.6) under NT2000
> (client not server) platform.
> 'fr_FR.ISO_8859-1' does not work too.
>
> So, it's not very important, but where can I find the entire list of
> countries with their ISO code?
>
I have read the archives for this problem but I can't seam to fix it
This is on a RedHat 7
I get this error when I try to start Apache
Starting httpd: Syntax error on line 256 of /etc/httpd/conf
/httpd.conf: Cannot load /etc/httpd/modules/libphp4.so into server:
libmysqlclient.so.10: canno
...And if all else fails, try www.webmonkey.com, devshed.com or search
for 'mysql tutorials' on google.com.
If you need a desktop reference, then I recommend the following books:
'MySQL and mSQL' -- by O'Reilly
'PHP Professionals'--published by WROX.
__John Monfort
Try
$str = preg_replace("", " ",$str);
jack
-Original Message-
From: Julian Simpson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 5:16 PM
To: [EMAIL PROTECTED]
Subject: [PHP] another REGEX question
I have a string can look like either of the following:
some stuff
some stu
A fairly detailed disucission, altho slightly out of date
http://php.resourceindex.com/Documentation/Reviews_and_Analysis/PHP_vs._ASP/
and one on the dangers of advocacy
http://www.perl.com/pub/a/2000/12/advocacy.html
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail:
it also appears that you're checking for the same thing
over and over and over
'0' is the same as "0"
and 00 is the same as 0
and "00" is the same as '00'
try checking for either 0 or "-00-00"
> -Original Message-
> From: Tim [mailto:[EMAIL PROTE
OK, this bugs me. Jeff -- you're obviously getting a kickback for any
business you refer to them -- why not mention that in your email so we
all know you have some financial interest in the company?
--kurt
> -Original Message-
> From: Jeff Pearson [mailto:[EMAIL PROTECTED]]
> Sent: T
>...ASP has gotta have something good about it cause microsoft uses it!
>
Hmm...you can get in sooo much trouble with that statement. Microsoft, in
any language, is not a synonym for 'quality'. Innovative? maybe. Quality?
no.
That statement should be your first reason why PHP is better. :-)
>
dude, aren't you being a little harsh?
> I hereby nominate Kyle as the official George W. Bush of the PHP General
> mailing list. Anyone second it?
to dubya, that is :)
-- mike cullerton
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For addition
I started to use this command in my soft about 3 months ago and all went
well, I've had to do some re-organising and I changed the varable that holds
the old image root, to the new image root and ofcouse moved the images, but
now my GetImageSize() doesn't work any more,
http://www.guia-marbella.c
What I did was this:
ln -s /usr/local/mysql/lib/mysql/libmysqlclient.so.10
/usr/lib/libmysqlclient.so.10
(that should be only one line)
This fixed my problem.
On 8/2/2001 6:36 AM this was written:
> I have read the archives for this problem but I can't seam to fix it
> This is on a RedHat 7
The Virtual() command works on my hosting server, I am running windows, idigostart
perl/apache with php4 installed, how do I get this virtual() command to work on my
machine, I assumed that the php4 I had installed was an apache module.
I have .shtml pages using includes for html, and "exec cgi
> -Original Message-
> From: Tim [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 10:41 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] Syntax
>
>
> You need to do:
>
> else if (isset(...)) {
Actually, elseif is a valid construct. See
http:
on 8/2/01 5:32 PM, Jeff Oien at [EMAIL PROTECTED] wrote:
> Is there a routine out there to strip all characters from a phone
> number except the numbers? I was going to write my own but
> figured there must already be one out there I can use. Thanks.
> Jeff Oien
ereg_replace ("[^0-9]","",$string
For the ImageCopyMerge() function in the PHP manual
(http://php.net/manual/en/function.imagecopymerge.php) it states at the
top that "(PHP 4 >= 4.0.1)" is required in order to use it. However,
farther down the page, it says "Note: This function was added in PHP
4.0.6"
Am I mis-reading something?
4.0.6 apxs
warning = E_ALL;
Warning: Undefined variable: search in
/home/httpd/vhosts/mediawaveonline/test2.php on line 4
Warning: Undefined variable: search in
/home/httpd/vhosts/mediawaveonline/test2.php on line 7
Warning: Undefined variable: search in
/home/httpd/vhosts/mediawaveonline
Hi Julian,
personally, I'd take out both tags, using something like:
$str = preg_replace("/<\/?p.*?>/i", "", $str);
Which gets rid of:
Or any case insensitive matches. That's probably just me though ;)
James.
"Julian Simpson" <[EMAIL PROTECTED]> wrote in message
news:20010802214051.BGVV2
Ok, im trying to cut down on the posts here but this time im really stuck, so could
somebody guide me through the usage of mySQL and PHP and show me how to input data
into a mySQL database and read it, or just redirect me to another page (which is what
normally happens)
NOTE: i am using phpMyA
- Original Message -
From: "R." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 02, 2001 11:07 AM
Subject: [PHP] Re: Netscape Enterprise Server
> On which system?
>
> You can fined for Win9x an Nt/2000 a lot of usefull info there:
> http://benoit.noss.free.fr/php/inst
Hello,
I need to convert an application that run on mysql to an oracle database. The
application strickly use the db_mysql class
from phplib. Can anyone suggest me another class and maybe common pitfalls to avoid ?
Thank you,
py
You need to do:
if (isset(...)) {
...
}
else if (isset(...)) {
...
}
else if (isset(...)) {
...
}
...
On 02 Aug 2001 17:10:26 +0200, BRACK wrote:
> Hi,
>
> I'm in a process of doing site with MySQL database, and most of
> the code I plased in index.php3 (in one file) but I've got some
> pro
Yes, ASP is revenue generating to Misocroft. PHP is free, so it's no good
for them.
At 04:34 PM 8/2/2001 -0700, Kyle Smith wrote:
>Whats the difference between ASP and PHP cause ASP has gotta have
>something good about it cause microsoft uses it!
>
>
>-lk6-
>http://www.StupeedStudios.f2s.com
>H
This is just a little bit off-topic - sorry
I'm running Mandrake 8.0 and am pretty new to Linux. I want to download my
entire website to my hard drive and put it in hte /var/www folder, but apache
is the owner and the group for that directory. I'm just wondering, if I chown
the directory so th
Thanks for the info, I am a PHP developer who will have to maintain some
outsourced (darned) ASP codes.
For all ASP converts who are currently converting, look at
http://asp2php.naken.cc/
At 04:18 PM 8/2/2001 -0400, [EMAIL PROTECTED] wrote:
>Hokay, my 2p...
>
>I'm a (former) ASP programmer who
if you're using apache, there's a *much* easier/secure way
of doing this.
setup an .htaccess file to restrict access to certain
username/passwords.
check out both:
man htaccess
man htpasswd
> -Original Message-
> From: Jon Yaggie [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02,
Hello,
How does one do the trick of hiding a folder's directory listing from a
public browser?
i.e. Lets say the full address is www.mysite.com/php/magicphppage.php
Well I still need some other files to read and write to
magicphppage.php I don't want the public to be able to simply type
ww
Just as the solution to spray paint the m/b green made me smile, this did
too.
This will strip out all characters except numerals at the beginning, right!
martin Cameron
On Fri, 03 Aug 2001 11:52, you wrote:
> on 8/2/01 5:32 PM, Jeff Oien at [EMAIL PROTECTED] wrote:
> > Is there a routine out
Glad to hear...steve's post was a good one...something else to think
about: sometimes people go for the .*? method, and sometimes the [^>]*>
way...they give the same results in most cases, but the .*? will match
the least amount it can, using the dot...the negation will match
anything...so, unless
Can someone show me how to display the contents of a table in a MS
Access file using ODBC on my Windows machine?
Thanks,
John
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list admin
Ok, I'm trying to seperate my php from my html the method I've been
trying to use is like so:
$html = fread(fopen("htmlpage.html", "r"), filesize("htmlpage.html"));
print $html;
This works perfectly fine, except if I want to use a variable
lets say that my htmlpage.html includes the f
I was just looking through the mailing list archives for some help
with my gettext problem (basically, I can't get it to work).
Anyway, I came across your post:
> Thanks for the reply. This will not solve my problem. The problem is,
for some
> languages the sentence structure may be different.
At 01:36 PM 8/2/01 -0700, Kyle Smith wrote:
>could somebody guide me through the usage of mySQL and PHP and show me how
>to input data into a mySQL database and read it
Kyle,
I wrote a script which does all that and it's open source. You can see the
script in action if you go to the Stupid We
In my script that puts out a form I have a drop down list which include ==>
echo "$Education\n";
echo "Bachelor's Degree\n";
It uses a $PHP_SELF target. After the form is submitted, on the new
page, in the textbox I have Bachelor\\\'s Degree getting outputed by
$Education and the more I submit t
On Wed, 1 Aug 2001 15:13:10 -0500, [EMAIL PROTECTED] (Richard Lynch)
wrote:
>> I'm going nuts trying to add a line of data in the beginning of a text
>> file.
>
>Files are like cassette tapes.
>
>You can't add something at the beginning without re-copying everything
>somewhere else first, and the
on 8/2/01 5:30 PM, Chuck Barnett at [EMAIL PROTECTED] wrote:
> Hi I have a question about parsing a page on another server to grab some
> headlines.
>
> I want to search down the page until I find a string "-headlines-" then I
> want to grab everything between the next pair of tags.
>
> Anyone
I am using the form below, and it works except for sending the message to
the user, any ideas/clues ?
Being so close to it working is driving me nuts !
Feedback Form
Please provide me your feedback!
Enter your name:
Enter you e-mail:
Enter your feedback:
http://www.imsltd.com/feedba
HI
I don't know why you are like G.Bush. But I have a vision that
formed while scanning some of the lists recent postings.
I see a man shoveling snow, again, from the sidewalk. While this
is going on a kid is running around building a snow man, making a
fort, throwing snow balls, holle
it's a little bit complicated, but here goes.
1) format your harddrive
2) take out your motherboard and spraypaint it
bright orange.
3) dance around the desk three times holding the
motherboard above your head chanting
"mail mail, give me mail"
"date date, give me date"
"o
hahah that had two interesting effects the first was that it left the < > and the
second
was that it turned off all the highlighting in my editor due to the "?>"
any idea how to include the braces in the match and perhaps not using the ?> string
for the sake of convenience :)
Julian
8/2/01
If I am talking to other geeky types I explain the full history of
"Personal Home
Page" outgrowing it's name to become "PHP: Hypertext Processor" , recursive
like
"GNU" ete. etc.
If I am talking to non geeky types, and they bother to ask, I go with
"Professional
Hypertext Processor".
Brian
When on mailing lists such discussion get longer and longer, like
'Attitude of B van Ouwerkerk', I always remember of this email. Could
everyone give a moment of thought and get back to the purpose of this list?
I know that this includes myself too, which I apologize for my behavior:
Q: How man
Is it maybe one of those where you mix&match your GET/POST?
Try moving the ACTION before the METHOD. No, it shouldn't matter...
--
WARNING [EMAIL PROTECTED] address is an endangered species -- Use
[EMAIL PROTECTED]
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunt
>There has to be an ultimate php tutorial out there which goes from start to
finish being easy >on the brain. if someone finds a tutorial this good,
i may be forced to post less on this >list. and i wouldnt like that
Try the WebMonkey and the DevShed ones, I think... Or just try the firs
Miles,
The LIMIT works great with UPDATE too.
"Miles Thompson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> Come on, you're pushing SQL in directions it's not supposed to go! It is
> set oriented after all.
> So it's experimentation time. I've never tried
on 8/2/01 9:01 PM, Ralph Guzman at [EMAIL PROTECTED] wrote:
> In mySQL, how do I set an auto increment field to start at a certain
> number-let's say 1? Do I just insert the first record with the desired
> number I wish to start with?
>
it appears to depend on the table type. i believe you
78 matches
Mail list logo
