27;t researched
how to do it in Mozilla or Netscape.
Beckman
-------
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
--
th printing? I would assume that the ideal page
> > size is not the ideal printed page size. oi vay!
> >
> > TIA
> >
> >
> > -----
> > Do you Yahoo!?
> > Yahoo! Finance: Get your refund fast by filing online
>
caching. Look to the manual for that.
-------
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
_timestamp() and date<(unix_timestamp()-(365*86400)) ...
Documentation:
http://mysql.com/date_sub (should redirect to
http://www.mysql.com/doc/en/Date_and_time_functions.html)
-------
Peter Beckman
ROM users WHERE
> username='$username' AND password=md5('$password')");
-------
Peter Beckman Internet Guy
[EMAIL PROTECTED
; Regards
> Piotr Babula
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter Beckman
List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.co
.jar
How do I get connected from a remote PHP+Apache box to Oracle9i on linux?
Beckman
-------
Peter Beckman Inter
Hi Jeff,
>
> do a print_r($_SERVER) to see which other variables are available. Maybe one
> of them will contain what you're looking for.
>
> Regards, Torsten
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: htt
pc)(KEY=extproc)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=aleph0)))
>
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zed2.mdah.state.ms.us)(PORT=1521)))
> Services Summary...
> Service "aleph0" has 1 instance(s).
> Instance "aleph0", status
http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
-------
Peter Beckman Internet Guy
[EMAIL PROTECTED]
which keeps
track of what line in which scripts each execution is at?
Thanks,
Peter
---
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL PROTECTED] http://www.purpleco
ideas?
Peter
-------
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Maili
__FILE__ should work.
>
> ---John Holmes...
> - Original Message -
> From: "Peter Beckman" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, October 23, 2002 3:00 PM
> Subject: [PHP-DB] Function that outputs "at line xxx"
>
>
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net
code that stats an HTML page for the
> > time,
> > > and if it's too old, update it. Be sure to use file locking so you don't
> > > clobber yourself.
> > >
> > > Moreover, do you open one connection and re-use it in a page, or do you do
> > &
;
> > Thank you in advance for any help.
> >
> > Graeme :)
> >
> >
> > Public Sub House()
> >
> > On Error Resume drink
> >
> > If Pint.empty = True Then
> > Pint.refill
> >Else
&g
; > when
> > > I
> > > upload, it has a Error in query. I checked all the little details but
> > > can't
> > > find out why? Any ideas are welcome.
> > >
> > > Jacco
> >
> > This one is an easy problem to fix. All you have
hy does it not do this at my localhost?? I have the % around my code so
> that it searches correctly right? Or should I clean up my code??
> Jacco
>
>
> --
> http://seabird.jmtech.ca
>
> Attitude is Everything!
> But Remember, Attitudes are Contagious!
> Is
d because it works fine locally
>
> What is the differense in my code posted locally and remote?
>
> Jacco
> --
> http://seabird.jmtech.ca
>
> Attitude is Everything!
> But Remember, Attitudes are Contagious!
> Is Yours worth Catching
> "Peter Beckman"
line 2
> > > SQL: SELECT * FROM airline_a WHERE Field1 LIKE '%%' Field2 LIKE '%%'
> > > Field3
> > > LIKE '%%' ORDER BY
> >
> > You need some ANDs between each of your field LIKE &
>maxlength="28">
>
>
>
> face="Arial, Helvetica, sans-serif">Last
> Name:
>
>maxlength="28">
>
>
>
> face="Arial, Helvetica, sans-serif">Address:
>
] = "something";
> $my_array[1] = "something else";
>
> I've probably missed something in the docs but I don't seem to find any
> hard fast rules on defining arrays or rediminsioning them.
>
> alex
>
> > -Original Message-
> &
the page,I get this error:
> Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
> resource in
>
> What is wrong???
>
---
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL PROTECTED] http://www.purplecow
ssell
> IT Support Manager
> Barloworld Optimus (Pty) Ltd
> Tel: +2711 444-7250
> Fax: +2711 444-7256
> e-mail: [EMAIL PROTECTED]
> web: www.BarloworldOptimus.com
>
---
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[E
PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
---
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL PROTECTED] http://www.purplecow.com/
-
you should definitely use it. Just avoid having it on
all columns by default.
Peter
On Tue, 29 Oct 2002, Peter Beckman wrote:
> With MySQL you save a bit by declaring a column not null. If it is null,
> you are using a bit. For performance on high volume and high transaction
>
me']."'");
> $_POST['uname'] = stripslashes($_POST['uname']);
> $_SESSION['username'] = $_POST['uname'];
> $_SESSION['password'] = $_POST['passwd'];
> $db_object->disconnect();
> ?>
> WelcomeY
#x27;;
> ... Etc ...
>
> But when I run any sort of array function (is_array, foreach) on
> $_SESSION['categories'] it appears that it is a scalar, not an array.
>
> Any ideas?
>
> - Ryan
>
>
> --
> PHP Database Mailing List (http://www.php.
7;uname'] = stripslashes($_POST['uname']);
> $_SESSION['username'] = $_POST['uname'];
> $_SESSION['password'] = $_POST['passwd'];
> $db_object->disconnect();
> ?>
> Welcome href="javascript:loadPage('mainlayer&#x
ate = date('m d, Y');
> > > $update_login = $db_object->query("UPDATE users SET last_login =
> '$date'
> > > WHERE username = '".$_POST['uname']."'");
> > > $_PO
this as i will end up with 50 extra variables.
> Thanks in advance for your comments.
>
> Andrew Wilson
> Technical Support
> Netway Networks
> 8920-8877
>
>
>
>
> Netway Networks Pty Ltd
> (T) 8920 8877
> (F) 8920 8866
>
>
>
nt strlen($_SESSION['categories']);
If you get "5", then the variable might be a string with the contents
being the word "Array". Pretty doubtful, but we're being thorough here.
Peter
> Hmph
>
> - Ryan
>
> > -Original Message-
>
ttype():string
> strlen():5
>
> > -----Original Message-
> > From: Peter Beckman [mailto:beckman@;purplecow.com]
> > Sent: Wednesday, October 30, 2002 8:57 AM
> > To: Ryan Neudorf
> > Cc: [EMAIL PROTECTED]
> > Subject: RE: [PHP-DB] Session variables and arrays
&
> Mississippi Internet...(800) MISSISSIPPI...http://www.mississippi.net
> Vicksburg Online...(800) MISSISSIPPI...http://www.vicksburg.com
> ========
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, vis
t; http://seabird.jmtech.ca
>
> Attitude is Everything!
> But Remember, Attitudes are Contagious!
> Is Yours worth Catching
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
-
why not??
> > Jacco
> >
> > --
> > http://seabird.jmtech.ca
> >
> > Attitude is Everything!
> > But Remember, Attitudes are Contagious!
> > Is Yours worth Catching
> >
> >
> >
> > --
> > PHP Database Mailing L
to take input from a web form by the variable
> $search_string and then the query string is constructed from that e.g.
>
> $query = "select count(distinct itemid) from business where name or
> description like'" . $search_string . "'";
>
>
> Any he
t; print $row["descript"];
> print("\n");
> } while($row = mysql_fetch_array($header));
>
> } else {print "Sorry, no records were found!";}
>
>
> ?>
>
>
> --
> PHP Database Mailing List (http
f you used
this input and it was checked:
Peter
On Sun, 3 Nov 2002, David Jackson wrote:
> Peter Beckman wrote:
>
> Peter,
> Thanks for your prompt reply.
>
> > Gonna need some additional information, such as:
> >
> > 1. The first three rows your query returns
>
long
> as 30 seconds or more, we've gotten over 17,500 unique entries in the
> past 24 hours, and the site is growing).
>
> Thanks for your help.
>
> -- Josh
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsu
= mysql_fetch_array($header)) {
print "{$row['descript']}";
}
} else print "Sorry, no records were found!";
print '';
?>
That looks prettier to me.
Peter
-------
Peter Beckma
ffset = 365;
> }
>
> $new_exp_day = strftime("%Y-%m-%d",mktime(0,0,0,$mn,$dy+$offset,$yr));
>
> --
> Frederik Feys
>
> [EMAIL PROTECTED]
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
who's tired of answering that
> register_globals has been turned off in recent versions raise your hand!
> :-)
>
>
> Marco
> --
>
> php|architect - The magazine for PHP Professionals
> The first monthly worldwide magazine dedicated to PHP programmer
>
know I
> benefit from it.
>
> Still, nothing better than being able to get help from some of the seasoned
> pros on this list right away.
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
-----
l=php-db
Newsgroup: news://news.php.net/php.db
Peter
On Wed, 6 Nov 2002, dwalker wrote:
> What archive and how do I access it?
-------
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL P
; > >
> > > When I print_r() the variable I have values so I know that works.
> > >
> > > Any thoughts on this?
> > >
> > > Thanks.
> > >
> > > Aaron
> > >
> >
> >
> > --
> > PHP Database Mailing List (
>
> William
>
> ---
> William Trappeniers
> mail at: [EMAIL PROTECTED]
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
-------
P
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
meaningful
> names, but, not sure if this means the DB has to work harder or not.
>
> Thanks!
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
-------
Box 1290
> CHATSWOOD NSW 2067 CHATSWOOD NSW 2057
>
>
> Ph: +61 2 9413 2944 Fax: +61 2 9413 9901
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter Beckman
did look through the archives before I posted, and didn't find
> anything. Please flame in private if I missed something!
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter BeckmanSy
ational +44-121-242-1473
> ---
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
successfully.
>
> Do I use the mail()??
>
> any thoughts
>
> Thanks
> [Ryan Holowaychuk]
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
----------
> .kristina
>
> [EMAIL PROTECTED]
> kfxdesign.net
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL PROT
PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL PROTECTED] http://www.purplecow.com/
o the full extent of the law.
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter BeckmanSystems Engineer, Fairfax
no clue why you'd want to do it this way, but if
your MySQL server is that taxed, then this is how I'd do it -- put the
processing on the web server.
Peter
On Fri, 8 Nov 2002, Leif K-Brooks wrote:
> The problem is, I need to make a page that shows all of the polls, and
> one qu
r code would be appreciated!
Peter
-------
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL PROTECTED] http://www.purplecow.com/
--
x27;s
> wrong???
>
>
> I'm using postgresql 7.2.2, php 4.2 and redhat 8.0. I've added support for
> pgsql and I've confirm that pqsql.so is loaded.
>
> Pls help
>
> Regards
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To u
(http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
-------
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL PROTECTED] http://www.purplecow.com/
---
any other way?
>
> Thanx in advance
> Achilles
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter BeckmanSystems Engineer, Fairfax C
l_query ( $query ) or die( mysql_error () );
> $x = 0 ;
> while ( $row = mysql_fetch_assoc ($result)) {
> ?>
>
>echo $row[$table_headers[$x]] ;
> ?>
>
>$x++ ;
> }
> ?>
&
ypted with double rot13 encoding. Any unauthorized attempt
>to decrypt it will be prosecuted to the full extent of the law.
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
27;m trying to decide whether to make it
> only update the changed rows or be lazy and make it update them all if
> only 1 has changed.
>
> Peter Beckman wrote:
>
> >Straight from the MySQL Documentation, which is where you should look first
> >always:
>
#x27;ve not looked at indexing but think it's time to start, but in a way even
> I can understand so I thought i'd ask you all here :-)
Peter "RTFM"
---
Peter BeckmanSystems Engi
t; thanx in advance,
> >
> > - Manos Papagelis
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> --
> PHP Database Mailing List (http://www.php.ne
i just can't come up with
>anything...
>
> P.S. Sorry for my bad english!
>
> Martin Allan Jensen
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/
hout
> this cache, MySQL's performance fell by two-thirds.
>
> ---John Holmes...
>
> > -----Original Message-
> > From: Peter Beckman [mailto:beckman@;purplecow.com]
> > Sent: Monday, November 11, 2002 12:29 PM
> > To: Maxim Maletsky
> > Cc: Manos Papa
t;
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
-------
Peter BeckmanSystems Engineer, Fairfax Cable Access Cor
help!
>
> --
> Darren Bentley / Systems Administrator
> Borealis Internet / 1-800-667-0307
> Prince George, BC, Canada
> http://www.pgweb.com
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
collection, scripts, whatever) under
>the GPL?
>
> Thank you for any help you may give in pointing me in the right direction.
>
>
> M.Cortes
> Fort LeBoeuf School District
>
>
-------
Peter Beckman
orking fine, and the form
>
>
>
>$sys = $system['Name'];
> if ($cnt == 1) {
> $cnt = 2;
> echo ""; ?>
>
>
-------
Peter BeckmanS
he second, why are you trying to use PHP instead of just linking to
the Access.mdb file via the web server?
Peter
-------
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL
ew at this, so please help me out. Thanks.
>
> - Anthony
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
-------
Peter Beckman
CAN only define ONE year, and ONE value in
>each LOOP!
> >
> > THANKS!!!
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
>
> --
> PHP Database Mail
cription = $ProductDetails["ProductDescription"];
> $PictureOfProduct = $ProductDetails["PictureOfProduct"];
> }
> if(mysql_num_rows($Q) > 0)
>
> Anyone got any ideas? I'm a bit lost as to why this doesn't work.
>
> G :)
--
do this?
>
> Any idea or reference how can I start this, is greatly appreciate.
>
> Thanks in advance
> Nato
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
>
>
>
>
>
>
>while ($refResult = db_fetch($refQuery)) { > ?>
>
>
>
>
> } ?>
>
>
>
> }
> }
> ?>
---
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EM
et/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
-------
Peter BeckmanSystems Engineer, Fairfax Cable Access Corporation
[EMAIL PROTECTED] http://www.purplecow.com/
-
> I am thinking PGP for this but to be honest I've never really worked
> with PGP and wouldn't have the first clue.
>
> Does anyone have any experience with this or can offer and advise at
> all?
>
> Again, sorry for the OT discussion.
>
> Aaron
>
> --
> PHP
crypted?
>
> Hense the email.
>
> Aaron
>
> -Original Message-
> From: Peter Beckman [mailto:beckman@;purplecow.com]
> Sent: November 15, 2002 12:35 PM
> To: Aaron Wolski
> Cc: 'Jason Vincent'; [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Email Encr
uot;]);
>
> $sql_element_low = "UPDATE $table SET medialow=NULL WHERE
> ".$_POST["tbl"]."contentID=".$_POST["id"]."";
> echo $sql_element_low."";
>
> mysql_query($sql_element_low) or
CTED]
> >
> > "There is no reason anyone would want a computer in their home."
> > --Ken Olson, president, chairman and founder of Digital Equipment
> > Corporation, 1977
> > (They why do I have 8? Somebody help me!)
> >
> > --
> > PHP
code above correct? If not, can you show me how one
might pass by reference correctly?
I've tested both pieces of code, but can't determine if there is a
speed/memory difference, and I don't actually have 125K in data handy!
Thanks,
Peter
-----
e"],10,2).':'.
> substr($show["Time"],12,2);
>
> echo "";
> echo "$sms_time ";
> echo "$smsc ";
> echo "$org_sms ";
> echo "$dest_sms ";
>
rsist through the insert, which cannot happen (need to be
able to prove the md5 hashes generated by DCC is accurate, and adding
slashes in the wrong place will screw that up).
What's the answer? addslashes then remove the single-quoted-slashes?
Thanks for the help.
Peter
---
Peter Beckma
for yr help
>
> --
> Warm regards,
> Afif
> mailto:[EMAIL PROTECTED]
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---------
> 0 order by
> priority asc
>
> and then
>
> select * from ads_value where status = 'current' and priority = 0 order by
> RAND()
>
> TIA,
>
> -Lisi
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, v
gt; $query = "INSERT INTO $sess_table
> > > VALUES('$SID', '$expiration', '$value')";
> > >
> > > $result = mysql_query($query);
> > >
> > > if (! $result) :
> > >
> > >$query = "UPDATE $sess_table SET
> > >
ops, the $GLOBALS[acdb] was legacy code for the site I was using.
Ignore it. Sorry! Your SessionTableName is set in php.ini -- if
$sessiontablename is empty, there is an issue that will prevent sessions
from being written/read from!
Peter
> > -Original Message-
> > From: Pete
abase) or die( "Unable to select database");
> $path = 'c:\\demo\\' ;
> $query = "insert into PH_PHOTO (PHOTO_PATH) VALUES ('$path')";
>
> $result=mysql_query($query);
>
> mysql_close();
> ?>
>
>
>
>
>
> --
> PHP Dat
access?
> >
> > Thanks for your help
> >
> > Regards
> >
> > Chris
> >
> >
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
-
t (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
-----------
Peter Beckman Internet Guy
[EMAIL PROTECTED]
d
replacing the search strings and continue to fail. Argh.
I know the word "fat" is in the body of more than 50 messages, as well as
in the headers, as there are 10,051 pieces of spam I'm trying to parse.
Peter
--
o use
the debugging tools the nice people at PHP gave you for Christmas.
Beckman
On Wed, 27 Nov 2002, Peter Beckman wrote:
> I'm writing a command line script to go through a mailbox on the file
> system. PHP the binary is compiled with imap, I've confirmed by using
> imap_hea
body where match(body) against
('"print pal"');
Peter
-----------
Peter Beckman Internet Guy
[EMAI
it is the
preg_match line that does the "magic."
Peter
-----------
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
-
he start of the parameters?
>
> Thanks,
> Eddie
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
-----------
Peter Beckman
>
> Jim.
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter Beckman Internet Guy
[EMAIL PROTE
1 - 100 of 189 matches
Mail list logo
