[PHP] AW: [PHP-WIN] best user authentication method?

2001-01-18 Thread Michael Rudel

Hi Romulo,

If you're only working (and all your clients, too) with M$, means M$-Win,
M$-IIS, M$-IE, so the best method is NTLM, but all Users must be registered
in your PDC as Users. Its very usable in Intranets.

Greetinx,
  Mike
(Germany)

-Ursprngliche Nachricht-
Von: Romulo Roberto Pereira [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 17. Januar 2001 05:27
An: php-general; php-windows
Betreff: [PHP-WIN] best user authentication method?


hello!

What is the best user authentication methd for linux (apache)? and for
windows (IIS)? 

--
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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] Problem with PHP using Java Classes

2001-01-18 Thread Fraser MacKenzie

Thanks.  I will try this.

Fraser

On Thu, 18 Jan 2001, Alex Akilov wrote:

 Fraser,
 
 
extension_dir=/usr/local/lib/php/extensions/no-debug-non-zts-20001214:/home/local/java/jdk1.2.2/jre/lib/i386
 
 Change the above to only list the directory that contains the
 libphp_java.so.
 The jdk directories should go to java.library.path (or LD_LIBRARY_PATH
 or ld.so.conf).  Note that java.library.path should also list the
 location
 of libphp_java.so (as you had correctly).
 
 Alex
 
 
 


-- 
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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] date(t)

2001-01-18 Thread Maurice Rickard

It does indeed work.  Thanks, Toby!

-Maurice

At 10:47 PM -0500 1/18/01, Toby Butzon wrote:
You might try this:

Arguments for mktime for my reference and for yours are ...

int mktime (int hour, int minute, int second, int month, int day, int year
[, int is_dst])

Then put it together with date() like this...

date("t", mktime(1, 1, 1, $mm, 1, $));

This is untested, but should work.

--Toby

-- 
Maurice Rickard
http://mauricerickard.com/

-- 
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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] MySQL + PWS Problems

2001-01-18 Thread Chris

i downloaded the binaries but when I compiled it said I was missing
string.obj
- Original Message -
From: "Phil Driscoll" [EMAIL PROTECTED]
To: "Chris" [EMAIL PROTECTED]; "PHP" [EMAIL PROTECTED]
Sent: Wednesday, January 17, 2001 4:44 AM
Subject: Re: [PHP] MySQL + PWS Problems


 Whenever I try to connect with ANY Mysql code on my cpu, I get an error
 saying it can't connect.
 I installed usingthe 4.04 win32 installer(heresey I know) which has mysql
 built in. Do I have to edit
 anything to all me to try the scripts on my personal cpu?

 Chris

 Reading between the lines, I suspect you haven't installed mysql. The php
 binaries have support for mysql built in (ie the ability to talk to mysql)
 but not the database itself.

 You can get mysql from www.mysql.com

 Cheers
 --
 Phil Driscoll
 Dial Solutions
 +44 (0)113 294 5112
 http://www.dialsolutions.com
 http://www.dtonline.org


 --
 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 administrators, e-mail: [EMAIL PROTECTED]



-- 
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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] Web hosting for PHP/MySQl development

2001-01-18 Thread Egan

Any recommendations for a good, savvy host for doing some PHP/MySQL
development? Not looking for a free service, obviously, but

 knowledgeable tech support

We try.

 good mysql/php 4/zend support

No Zend yet.

 decent mail handling

APOP for secure POP password.  Sendmail.  Not sure what else you mean.

 and developers tools like: telnet/ssh

Yes.

 emacs

Emacs, yikes!  I hate to imagine 100 users all loading emacs at the
same time.  This might be negotiable per account, upon request.  How
about vim in the meantime?

 procmail

Yes.

 crontab access

Yes, and I wonder how many others offer that?  Not many, I expect.


If you traceroute to vha.sevenkings.net vs. the competition, I think
we compare favorably.  We have good connectivity and ample bandwidth
near a major NAP in Chicago.  We're not on the backwaters like many
competitors are.

We're not fully open yet, but we're ready for some early testers.
Email me if you want to be one and I can let you have a test account
to try out at no charge (for a while, not forever).  We do ask that
testers bring less than 2GB traffic per month with them.  :-)


Egan



-- 
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 administrators, e-mail: [EMAIL PROTECTED]




[PHP] Good Reads

2001-01-18 Thread Sean Brown

Does anyone have any suggestions on a good book for beginners. I currently
own "PHP3 Programming Browser-Based Applications" by David Medinets. I have
no regrets thus far on purchasing the book but it seems to leave a lot out
and his examples are somewhat... skewed.

Cheers


-- 
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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] a text formating cpu question

2001-01-18 Thread php3

Addressed to: Noel Akins [EMAIL PROTECTED]
  [EMAIL PROTECTED]

** Reply to note from Noel Akins [EMAIL PROTECTED] Thu, 18 Jan 2001 22:05:46 +

 Hello, Question 1: A long time ago, I started my first big project
 using php3 and MySQL that  would return on a query a listing of info
 from the database that was  displayed in the browser with nested
 tables. If a user really wanted to  test the limits of the database,
 he/she could get back over 3000  lines. Being that html tables were
 being used to display the info, a large  number of tables were being
 created, and would crash netscape. I pretty  much shelved this
 project for this reason. I'm now working on a similar  project that
 won't return so many lines, but I would like to be able to use
 something other than html tables to display the info in a neat
 manner. Is  there any php related things I could use to format a list
 in a  browser other than html tags? could someone point me in the
 right direction?


PRE


Or break up your table so there are many small tables rather than one
big one.


Breaking up the table is probably best.  Pre text looks pretty uggly.


 Question 2: Is there a way for php to detect the cpu speed of a users
 computer?


I don't think so.



Rick Widmer
Internet Marketing Specialists
http://www.developersdesk.com

--
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 administrators, e-mail: [EMAIL PROTECTED]




RE: [PHP] Not quite relevant question about coding and query

2001-01-18 Thread Jason Murray

 $query = "insert into user values
('firstname','lastname','address','phone')";
 $resultinsert = mysql_query($query);
 
 $getID = "select userID from user"; // Will this get me the 
 // Id of the record I just inserted?
 $resultID = mysql_query($getID);

No, it won't - it'll return every userID in the table.

If your userIDs are sequential, you can just select "MAX(userID)" instead
of userID.

Jason

-- 
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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] Not quite relevant question about coding and query

2001-01-18 Thread [EMAIL PROTECTED]

thanks for Jason:-) Lucky the ID is sequential. That was command I was
looking for.
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
- Original Message -
From: Jason Murray [EMAIL PROTECTED]
To: 'Jacky@lilst' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, January 18, 2001 11:56 PM
Subject: RE: [PHP] Not quite relevant question about coding and query


  $query = "insert into user values
 ('firstname','lastname','address','phone')";
  $resultinsert = mysql_query($query);
 
  $getID = "select userID from user"; // Will this get me the
  // Id of the record I just inserted?
  $resultID = mysql_query($getID);

 No, it won't - it'll return every userID in the table.

 If your userIDs are sequential, you can just select "MAX(userID)" instead
 of userID.

 Jason

 --
 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 administrators, e-mail: [EMAIL PROTECTED]



-- 
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 administrators, e-mail: [EMAIL PROTECTED]




RE: [PHP] Not quite relevant question about coding and query

2001-01-18 Thread Dave Haggerty



-Original Message-
From: Jason Murray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 18, 2001 9:57 PM
To: 'Jacky@lilst'; [EMAIL PROTECTED]
Subject: RE: [PHP] Not quite relevant question about coding and query


 $query = "insert into user values
('firstname','lastname','address','phone')";
 $resultinsert = mysql_query($query);

 $getID = "select userID from user"; // Will this get me the
 // Id of the record I just inserted?
 $resultID = mysql_query($getID);

No, it won't - it'll return every userID in the table.

If your userIDs are sequential, you can just select "MAX(userID)" instead
of userID.

Jason

--


Im no expert...I am learning this stuff "as we speak"but shouldn't
mysql_insert_id() do it?

Cheers,

Dave


-- 
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 administrators, e-mail: [EMAIL PROTECTED]




[PHP] PHP site on CD-ROM

2001-01-18 Thread Philip Apostol

Can I run a PHP/Apache/MySQL services on a CD-ROM.  We have PHP scripts that
handle queries on a large database.  We would like to distribute it on a
CD-ROM so they could access the database offline.  Is it possible? Or are
there any similar solutions for this?  Im thinking of a text-file database
and access it via javascript but have no much time to study on this.  If php
can be run on the cd-rom, that would be a better solution.   But any
solution you posted here will be highly appreciated.  Thanks in advance.

Philip


-- 
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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] Not quite relevant question about coding and query

2001-01-18 Thread php3

Addressed to: "Jacky@lilst" [EMAIL PROTECTED]
  "Jason Murray" [EMAIL PROTECTED]
  [EMAIL PROTECTED]

** Reply to note from "Jacky@lilst" [EMAIL PROTECTED] Fri, 19 Jan 2001 
13:15:13 -0600

What happens when more than one person updates the tables at nearly
the same time?

a - insert record 9

b - insert record 10

a - get max ID = 10

b - get max ID = 10

Something doesn't look right here


What you are looking for is  mysql-insert-id()
Get the id generated from the previous INSERT operation


   http://www.php.net/manual/en/html/function.mysql-insert-id.html




 thanks for Jason:-) Lucky the ID is sequential. That was command I
 was looking for. cheers Jack [EMAIL PROTECTED] "There is
 nothing more rewarding than reaching the goal you set for yourself"
 - Original Message - From: Jason Murray
 [EMAIL PROTECTED] To: 'Jacky@lilst'
 [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent:
 Thursday, January 18, 2001 11:56 PM Subject: RE: [PHP] Not quite
 relevant question about coding and query


   $query = "insert into user values
  ('firstname','lastname','address','phone')";
   $resultinsert = mysql_query($query);
  
   $getID = "select userID from user"; // Will this get me the
   // Id of the record I just inserted?
   $resultID = mysql_query($getID);
 
  No, it won't - it'll return every userID in the table.
 
  If your userIDs are sequential, you can just select "MAX(userID)" instead
  of userID.


Rick Widmer
Internet Marketing Specialists
http://www.developersdesk.com

--
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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] PHP site on CD-ROM

2001-01-18 Thread Rasmus Lerdorf

You would need to go through a web server for it to work.

On Fri, 19 Jan 2001, Philip Apostol wrote:

 Can I run a PHP/Apache/MySQL services on a CD-ROM.  We have PHP scripts that
 handle queries on a large database.  We would like to distribute it on a
 CD-ROM so they could access the database offline.  Is it possible? Or are
 there any similar solutions for this?  Im thinking of a text-file database
 and access it via javascript but have no much time to study on this.  If php
 can be run on the cd-rom, that would be a better solution.   But any
 solution you posted here will be highly appreciated.  Thanks in advance.

 Philip


 --
 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 administrators, e-mail: [EMAIL PROTECTED]



-- 
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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] RE: Ethics question...

2001-01-18 Thread jeremy brand

 Apache doesn't have threading (yet).
 If your business depends upon it, you may want to take a look at
 Solaris/Zeus if you are really getting heavy load high traffic.

We serve millions of hits a day off of a small farm of FreeBSD servers
running Apache+php for our dynamic content.  Thttpd for our static
pages (images, etc).

Our farm used to be linux, but FreeBSD has been better. Linux 2.2
would flake out under extreme load and not recover.  FreeBSD gets
stressed under extreme load as well, but it recovers.  If you know
redhat better and can't use Freebsd, that is fine.  It might save
_you_ more time to use redhat as the savings in administration could
easlily be overturned if you don't know freebsd better than redhat.
Don't get me wrong, on a personal note, I love linux (the most, I
might add).

I think the single most importand piece of software that saves us the
most money is thttpd.  That all runs in a single thread and uses
select to pump out content.  Since it is a single thread, it never
chews up tons of memory forking children.  I think our farm would need
to be twice as big if we tried to use apache for our static content.
I have nothing bad to say about apache, don't get me wrong.  This is
simply the way that works best for us. Our DB lives on a separate quad
sparc and all of our content is centralized and remotely NFS mounted.

Jeremy

Jeremy Brand :: Sr. Software Engineer :: 408-245-9058 :: [EMAIL PROTECTED]
http://www.JeremyBrand.com/Jeremy/Brand/Jeremy_Brand.html for more 
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
"LINUX is obsolete"  -- Andy Tanenbaum, January 29th, 1992
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
   http://www.JEEP-FOR-SALE.com/ -- I need a buyer
  Get your own Free, Private email at http://www.smackdown.com/


-- 
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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] RE: Ethics question...

2001-01-18 Thread Rasmus Lerdorf

  By the way, there is a PHP module for thttpd.

 Thank you.  I know.  I haven't had a chance to spend time testing it.

 Would anyone recommend it for mission critical environments?

I can't really do that since I have never tried it.

-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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] Not quite relevant question about coding and query

2001-01-18 Thread [EMAIL PROTECTED]

So what i should really do is like this:
$anotherQuery = "select mysql_insert_id(UserID) from user";
$resultUserID = mysql_query($anotherQuery);
is that corerct?
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
- Original Message -
From: [EMAIL PROTECTED]
To: Jacky@lilst [EMAIL PROTECTED]; Jason Murray
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 19, 2001 12:36 AM
Subject: Re: [PHP] Not quite relevant question about coding and query


 Addressed to: "Jacky@lilst" [EMAIL PROTECTED]
   "Jason Murray" [EMAIL PROTECTED]
   [EMAIL PROTECTED]

 ** Reply to note from "Jacky@lilst" [EMAIL PROTECTED] Fri, 19
Jan 2001 13:15:13 -0600

 What happens when more than one person updates the tables at nearly
 the same time?

 a - insert record 9

 b - insert record 10

 a - get max ID = 10

 b - get max ID = 10

 Something doesn't look right here


 What you are looking for is  mysql-insert-id()
 Get the id generated from the previous INSERT operation


http://www.php.net/manual/en/html/function.mysql-insert-id.html



 
  thanks for Jason:-) Lucky the ID is sequential. That was command I
  was looking for. cheers Jack [EMAIL PROTECTED] "There is
  nothing more rewarding than reaching the goal you set for yourself"
  - Original Message - From: Jason Murray
  [EMAIL PROTECTED] To: 'Jacky@lilst'
  [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent:
  Thursday, January 18, 2001 11:56 PM Subject: RE: [PHP] Not quite
  relevant question about coding and query
 
 
$query = "insert into user values
   ('firstname','lastname','address','phone')";
$resultinsert = mysql_query($query);
   
$getID = "select userID from user"; // Will this get me the
// Id of the record I just
inserted?
$resultID = mysql_query($getID);
  
   No, it won't - it'll return every userID in the table.
  
   If your userIDs are sequential, you can just select "MAX(userID)"
instead
   of userID.


 Rick Widmer
 Internet Marketing Specialists
 http://www.developersdesk.com



-- 
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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] RE: Ethics question...

2001-01-18 Thread jeremy brand

 I can't really do that since I have never tried it.

I plan on testing it under extreme load eventually.  If I do before
someone else does, I'll post my results.  But for the mean time, our
set up is working perfectly, so it may be a while.

I'm a big thttpd advocate, so I'd (for no better reason) love to run
thttpd+php instead of apache if it could provide = service under
pressure.  It most likely already does.  I know thttpd by itself is
the absolute best I have tested for high performance static content.
It kicks apache up and down the block on this regard.

Jeremy

Jeremy Brand :: Sr. Software Engineer :: 408-245-9058 :: [EMAIL PROTECTED]
http://www.JeremyBrand.com/Jeremy/Brand/Jeremy_Brand.html for more 
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
"LINUX is obsolete"  -- Andy Tanenbaum, January 29th, 1992
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
   http://www.JEEP-FOR-SALE.com/ -- I need a buyer
  Get your own Free, Private email at http://www.smackdown.com/


-- 
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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] Not quite relevant question about coding and query

2001-01-18 Thread [EMAIL PROTECTED]

Sorry, I think it should be like this:

$queryInsert = "insert into user values ('firstname','lastname','email')";
$resultinsert = mysql_query($queryInsert);

$UserIdLatest = mysql_insert_id(userId);


Is that correct?
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
- Original Message -
From: [EMAIL PROTECTED]
To: Jacky@lilst [EMAIL PROTECTED]; Jason Murray
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 19, 2001 12:36 AM
Subject: Re: [PHP] Not quite relevant question about coding and query


 Addressed to: "Jacky@lilst" [EMAIL PROTECTED]
   "Jason Murray" [EMAIL PROTECTED]
   [EMAIL PROTECTED]

 ** Reply to note from "Jacky@lilst" [EMAIL PROTECTED] Fri, 19
Jan 2001 13:15:13 -0600

 What happens when more than one person updates the tables at nearly
 the same time?

 a - insert record 9

 b - insert record 10

 a - get max ID = 10

 b - get max ID = 10

 Something doesn't look right here


 What you are looking for is  mysql-insert-id()
 Get the id generated from the previous INSERT operation


http://www.php.net/manual/en/html/function.mysql-insert-id.html



 
  thanks for Jason:-) Lucky the ID is sequential. That was command I
  was looking for. cheers Jack [EMAIL PROTECTED] "There is
  nothing more rewarding than reaching the goal you set for yourself"
  - Original Message - From: Jason Murray
  [EMAIL PROTECTED] To: 'Jacky@lilst'
  [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent:
  Thursday, January 18, 2001 11:56 PM Subject: RE: [PHP] Not quite
  relevant question about coding and query
 
 
$query = "insert into user values
   ('firstname','lastname','address','phone')";
$resultinsert = mysql_query($query);
   
$getID = "select userID from user"; // Will this get me the
// Id of the record I just
inserted?
$resultID = mysql_query($getID);
  
   No, it won't - it'll return every userID in the table.
  
   If your userIDs are sequential, you can just select "MAX(userID)"
instead
   of userID.


 Rick Widmer
 Internet Marketing Specialists
 http://www.developersdesk.com



-- 
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 administrators, e-mail: [EMAIL PROTECTED]




[PHP] temporary unsubscribe mailing list

2001-01-18 Thread Wen Ni Leong

I would like to unsubscribe the mailing list for a week which is
effective from 20th of Jan 2001 to 28th of Jan 2001.
I hope you can automatic reactive me into the mailing list after the
28th of Jan 2001.

Thank you.

From Wendy Leong
[EMAIL PROTECTED]

-- 
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 administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] Not quite relevant question about coding and query

2001-01-18 Thread php3

Addressed to: "Jacky@lilst" [EMAIL PROTECTED]
  [EMAIL PROTECTED]

** Reply to note from "Jacky@lilst" [EMAIL PROTECTED] Fri, 19 Jan 2001 
14:00:02 -0600

 Sorry, I think it should be like this:

 $queryInsert = "insert into user values ('firstname','lastname','email')";
 $resultinsert = mysql_query($queryInsert);

 $UserIdLatest = mysql_insert_id(userId);


 Is that correct?

Yes, that is the 'proper' way to find out the value of a auto_incremant
field.  The SELECT MAX( userid ) method will work fine in testing, but
then you get to pull your hair out when it starts to fail under heavy
load.


You might have a bit of a problem with the values() clause of the
insert.  That statement expects you to list all the entries in the
table, in the order they appear, unless you specify a list right after
the table name.  I've given up on that syntax in favor of this one:


$QueryInsert = "INSERT INTO user SET " .
   "   firstname = '$FirstName', " .
   "   lastname = '$LastName', " .
   "   email = '$Email' );

It also works with update:

$QueryUpdate = "UPDATE user SET " .
   "   firstname = '$FirstName', " .
   "   lastname = '$LastName', " .
   "   email = '$Email' .
   "WHERE userId = 1234 " );

I like the fact that you can list any fields in any order while leaving
out anything you want.





Rick Widmer
Internet Marketing Specialists
http://www.developersdesk.com

--
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 administrators, e-mail: [EMAIL PROTECTED]




[PHP] Gear Head -- From Home Pages to Popularity

2001-01-18 Thread php3

Addressed to: [EMAIL PROTECTED]
  [EMAIL PROTECTED]
  [EMAIL PROTECTED]

In his current column for Network World, Gear Hear (AKA Mark Gibbs)
talks about PHP and Zend Technologies.  Since you hang out on this
mailing list, you may not learn much, but go ahead and take a look.  It
is great to know that PHP is getting this kind of press in a major
weekly magazine for network managers.


   http://www.nwfusion.com/columnists/2001/00288015.html


PHP4 has become wildly popular and is now a
major language in Web scripting. According to the
October 2000 NetCraft Web survey, PHP was
running in more than 3.8 million domains on
715,283 IP addresses.



He promises more on PHP next week!




Rick Widmer
Internet Marketing Specialists
http://www.developersdesk.com

--
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 administrators, e-mail: [EMAIL PROTECTED]




[PHP] Gear Head -- From Home Pages to Popularity

2001-01-18 Thread php3

Addressed to: [EMAIL PROTECTED]
  [EMAIL PROTECTED]

The current column for Gear Head, (AKA Mark Gibbs) in Network World
magazine is all about PHP and Zend Technonogies.  Since you hang around
on this mailing list, you may not learn much but rejoice in the thought
that his column is pointed at corporate network managers, and is quite
positive about PHP and Zend.


Rick Widmer
Internet Marketing Specialists
http://www.developersdesk.com

--
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 administrators, e-mail: [EMAIL PROTECTED]




<    1   2   3