Re: [PHP-DB] forum test

2002-11-11 Thread dwalker
Went to your page.  You might try to implement client side browser testing
and redirect visitors to functional pages rather than display a message
suggesting your page can't be viewed.  Most people would probably prefer not
to 'upgrade' just to see a single site they hadn't visited before.



Re: [PHP-DB] sort by date

2002-11-06 Thread dwalker
What archive and how do I access it?


-Original Message-
From: Hutchins, Richard <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, November 06, 2002 10:50 AM
Subject: RE: [PHP-DB] sort by date


>Just to weigh in on the tail end here, a FAQ of the top N items would be
>nice. But I have to say, I use the archives a lot before I post to the
list.
>The archives contain the answers to most questions out there. If
subscribers
>to this list checked the archives to see if their answer is there, then
>questions like register_globals might decrease in frequency.
>
>The other side effect of researching answers for yourself before posting is
>that you gain exposure to more of the language faster. How many times do
you
>read about something that doesn't solve your immediate problem, but puts an
>idea into your head as to how you might handle a future situation? I 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
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP-DB] PHP/MySQL and passing url params

2002-10-28 Thread dwalker
I discovered bugs with PHAKT PHP for UD4 but was able to create work
arounds.  Did you make the mistake of installing the XME phakt 1.5.x
module??


-Original Message-
From: alex hogan <[EMAIL PROTECTED]>
To: 'dwalker' <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Monday, October 28, 2002 10:18 PM
Subject: RE: [PHP-DB] PHP/MySQL and passing url params


>I am using PHAKT's PHP model.
>
>> -Original Message-
>> From: dwalker [mailto:dwalker@;healthyproductsplus.com]
>> Sent: Monday, October 28, 2002 8:43 PM
>> To: alex hogan; [EMAIL PROTECTED]
>> Subject: Re: [PHP-DB] PHP/MySQL and passing url params
>>
>> Are you working with the PHP model that came with MX or are you
>working with
>> PHAKT's PHP model for UD
>> -Original Message-
>> From: alex hogan <[EMAIL PROTECTED]>
>> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
>> Date: Sunday, October 27, 2002 6:43 PM
>> Subject: [PHP-DB] PHP/MySQL and passing url params
>>
>>
>> >Hi All,
>> >
>> >I am new to the list, as a matter of fact this is my first post so if
>> >I'm covering territory that has been already covered please excuse
>me.
>> >
>> >I am using PHP/MySQL/Dreamweaver MX.  I expect the razzing to start
>> >anytime now.;-)  I am also very new to php.
>> >
>> >I have a form that is gathering user information and inserting it
>into
>> >the database.  From there it is going to a "Thank You" page that
>shows
>> >their first name, username and password.
>> >
>> >The username and password are generated after they enter their
>> >information in the aforementioned form and then is displayed on the
>> >Thank You page.
>> >
>> >The problem I'm having is that when I put a url parameter on the go
>to
>> >page I get these errors;
>> >Notice: Undefined variable: row_rsID in
>> >D:\web\demo\login\TMP97xok4jxov.php on line 48
>> >
>> >Warning: Cannot add header information - headers already sent by
>(output
>> >started at D:\web\demo\login\TMP97xok4jxov.php:48) in
>> >D:\web\demo\login\TMP97xok4jxov.php on line 53
>> >
>> >When I define the variable $row_rsID = "";
>> >
>> >I get;
>> >Notice: Uninitialized string offset: 0 in
>> >D:\web\hogana\demo\login\TMP9ee7s4jxx8.php on line 48
>> >
>> >Warning: Cannot add header information - headers already sent by
>(output
>> >started at D:\web\hogana\demo\login\TMP9ee7s4jxx8.php:48) in
>> >D:\web\hogana\demo\login\TMP9ee7s4jxx8.php on line 53
>> >
>> >And my insert behavior disappears.
>> >
>> >Can someone shed some light on this?  If I'm missing a step or there
>is
>> >a better way to do this please let me know.  I've been trying to find
>a
>> >way to redirect in php but have come up empty there.  Is there a way
>to
>> >redirect without mixing languages?
>> >
>> >If I try to remove this I can't identify the user when I go to the
>Thank
>> >You page, I keep getting the first recordset.  Oddly enough the
>> >functions I wrote that generate the username and the password work
>> >great!  Isn't that always the case.
>> >
>> >
>> >TIA,
>> >
>> >alex
>> >
>> >
>> >
>> >--
>> >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


Re: [PHP-DB] PHP/MySQL and passing url params

2002-10-28 Thread dwalker
Are you working with the PHP model that came with MX or are you working with
PHAKT's PHP model for UD
-Original Message-
From: alex hogan <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Sunday, October 27, 2002 6:43 PM
Subject: [PHP-DB] PHP/MySQL and passing url params


>Hi All,
>
>I am new to the list, as a matter of fact this is my first post so if
>I'm covering territory that has been already covered please excuse me.
>
>I am using PHP/MySQL/Dreamweaver MX.  I expect the razzing to start
>anytime now.;-)  I am also very new to php.
>
>I have a form that is gathering user information and inserting it into
>the database.  From there it is going to a "Thank You" page that shows
>their first name, username and password.
>
>The username and password are generated after they enter their
>information in the aforementioned form and then is displayed on the
>Thank You page.
>
>The problem I'm having is that when I put a url parameter on the go to
>page I get these errors;
>Notice: Undefined variable: row_rsID in
>D:\web\demo\login\TMP97xok4jxov.php on line 48
>
>Warning: Cannot add header information - headers already sent by (output
>started at D:\web\demo\login\TMP97xok4jxov.php:48) in
>D:\web\demo\login\TMP97xok4jxov.php on line 53
>
>When I define the variable $row_rsID = "";
>
>I get;
>Notice: Uninitialized string offset: 0 in
>D:\web\hogana\demo\login\TMP9ee7s4jxx8.php on line 48
>
>Warning: Cannot add header information - headers already sent by (output
>started at D:\web\hogana\demo\login\TMP9ee7s4jxx8.php:48) in
>D:\web\hogana\demo\login\TMP9ee7s4jxx8.php on line 53
>
>And my insert behavior disappears.
>
>Can someone shed some light on this?  If I'm missing a step or there is
>a better way to do this please let me know.  I've been trying to find a
>way to redirect in php but have come up empty there.  Is there a way to
>redirect without mixing languages?
>
>If I try to remove this I can't identify the user when I go to the Thank
>You page, I keep getting the first recordset.  Oddly enough the
>functions I wrote that generate the username and the password work
>great!  Isn't that always the case.
>
>
>TIA,
>
>alex
>
>
>
>--
>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


[PHP-DB] String extraction from blobs. Extracted string to be placed into field within another table.

2002-10-20 Thread dwalker



What is the most effective method of extracting from a blob 
specified text to be placed into another table field.
 
 
 
 
This email message and all attachments transmitted herewith 
are tradesecret and/or confidential information intended only for 
the viewing and use of addressee.  If the reader of this 
message is not the intended recipient, you are hereby notified that 
any review, use, communication, dissemination, distribution or copying 
of this communication is prohibited.  If you have received this 
communication is error, please notify the sender immediately by telephone or 
electronic mail, and delete this message and all copies and backups 
thereof.  
 
Thank you for your cooperation.
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP-DB] MySQL Insert Select statement

2002-10-19 Thread dwalker
For some reason the Insert Select statement returned an ERROR and I had to
resort to

INSERT INTO Products
(ProductName,Size,SuggestedRetailPrice,ProductCategory,ManufacturerName)

SELECT *

FROM kalproduct ;

Is there a noticeable reason why:

INSERT INTO Products
(ProductName,Size,SuggestedRetailPrice,ProductCategory,ManufacturerName)

SELECT(kalproduct.Product, kalproduct.size, kalproduct.SRP,
kalproduct.Cat, kalproduct.manname)

FROM kalproduct ;

would have returned an error message??  I don't want to have to create
multiple tables for the purpose of inserting into others.

-Original Message-
From: John W. Holmes <[EMAIL PROTECTED]>
To: 'dwalker' <[EMAIL PROTECTED]>; 'professional php'
<[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]>;
[EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Saturday, October 19, 2002 7:24 PM
Subject: RE: [PHP-DB] MySQL Insert Select statement


>That's how you do it. Hopefully you've figured it out already.
>
>
>
>---John Holmes.
>
>
>
>-Original Message-
>From: dwalker [mailto:dwalker@;healthyproductsplus.com]
>Sent: Saturday, October 19, 2002 7:51 PM
>To: professional php; [EMAIL PROTECTED]; [EMAIL PROTECTED]
>Subject: [PHP-DB] MySQL Insert Select statement
>
>
>
>While reading the MySQL manual for INSERT SELECT, I was not able to
>determine how to include all 5 fields of one table into another table
>(containing 100 fields) into SPECIFIC data fields.  Do I need to
>explicitly list all the fields within the table of 5 fields?  If so,
>would the statement be:
>
>
>
>INSERT INTO Products
>(ProductName,Size,SuggestedRetailPrice,ProductCategory,ManufacturerName)
>
>SELECT(kalproduct.Product, kalproduct.size, kalproduct.SRP,
>kalproduct.Cat, kalproduct.manname)
>
>FROM kalproduct
>
>;
>
>
>
>
>
>
>
>Thanking you in advance.
>
>
>
>P.S.  I'd give it a try, but I'm trying to move 500 partial records into
>a table containing at least 2000 records -- didn't want to start from
>scratch.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>This email message and all attachments transmitted herewith are trade
>secret and/or confidential information intended only for the
> viewing and use of addressee.  If the reader of this message
> is not the intended recipient, you are hereby notified that
>any review, use, communication, dissemination, distribution
>or copying of this communication is prohibited.  If you have
>received this communication is error, please notify the sender
>immediately by telephone or electronic mail, and delete this
>message and all copies and backups thereof.
>
>
>
>Thank you for your cooperation.
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[PHP-DB] MySQL Insert Select statement

2002-10-19 Thread dwalker



While reading the MySQL manual for INSERT SELECT, I was 
not able to determine how to include all 5 fields of one table into another 
table (containing 100 fields) into SPECIFIC data fields.  Do I need to 
explicitly list all the fields within the table of 5 fields?  If so, would 
the statement be:
 
INSERT INTO Products 
(ProductName,Size,SuggestedRetailPrice,ProductCategory,ManufacturerName)
SELECT(kalproduct.Product, kalproduct.size, 
kalproduct.SRP, kalproduct.Cat, kalproduct.manname)
FROM kalproduct 
;
 
 
 
Thanking you in advance.
 
P.S.  I'd give it a try, but I'm trying to move 500 
partial records into a table containing at least 2000 records -- didn't want to 
start from scratch.
 
 
 
 
 
 
 
 
 
 
This email message and all attachments transmitted herewith 
are tradesecret and/or confidential information intended only for 
the viewing and use of addressee.  If the reader of this 
message is not the intended recipient, you are hereby notified that 
any review, use, communication, dissemination, distribution or copying 
of this communication is prohibited.  If you have received this 
communication is error, please notify the sender immediately by telephone or 
electronic mail, and delete this message and all copies and backups 
thereof.  
 
Thank you for your cooperation.
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP-DB] Variable won't be passed from HTTP address bar

2002-10-18 Thread dwalker
Perhaps , $action  is not equal to "test".  Try initializing the $action
variable - instead of leaving it uninitialized.



-Original Message-
From: Michel Bakkenes - bakkenes.net <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, October 18, 2002 6:26 AM
Subject: [PHP-DB] Variable won't be passed from HTTP address bar


>Ok.. I'm not a newbie I thought.. I do have experience with PHP, but I
>never suffered from this error.
>
>I used on my own redhat 8.0 server the following test-script:
>
>if($action=="test"){ echo "Test";}
>
>I tried it to run with: 127.0.0.1/index.php?action=test
>
>It doesn't print anything. (which means I even can't print hello world
>:P)
>
>Oh, other variable constructions like $bla = "blah" . echo $bla etc. do
>work..
>
>With regards,
>
>Michel Bakkenes
>J2ee developer
>
>Infolook BV
>Zevenbergen, The Netherlands
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP-DB] Passing string variable to HTML TITLE tag fails within Netscape but works well within IE.

2002-10-16 Thread dwalker

Just what I was looking for --  thank you.Putting together an entirely
dynamic site was difficult enough -- I need to avoid doing any EXTRA stuff
when ever possible.

Again, thanks.


THIS E-MAIL MESSAGE AND ALL ATTACHMENTS TRANSMITTED HEREWITH ARE TRADE
SECRET AND/OR CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE VIEWING AND
USE OF ADDRESSEE.  IF THE READER OF THIS MESSAGE IS NOT THE INTENDED
RECIPIENT, YOU ARE HEREBY NOTIFIED THAT ANY REVIEW, USE, COMMUNICATION,
DISSEMINATION, DISTRIBUTION OR COPYING OF THIS COMMUNICATION IS PROHIBITED.
IF YOU HAVE RECEIVED THIS COMMUNICATION IN ERROR, PLEASE NOTIFY THE SENDER
IMMEDIATELY BY TELEPHONE OR ELECTRONIC MAIL, AND DELETE THIS MESSAGE AND
ALL COPIES AND BACKUPS THEREOF.  THANK YOU FOR YOUR COOPERATION.

-Original Message-
From: Howard Picken <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, October 16, 2002 1:51 AM
Subject: RE: [PHP-DB] Passing string variable to HTML TITLE tag fails within
Netscape but works well within IE.


>Hi Darrian
>
>Have had similar problems.  I got around it by
>wrapping all posted variables with rawurlencode().
>
>This replace any spaces or special characters with an nasi equiv
>ie space with %20.  IE will ignore it.
>
>GL
>
>Howard
>  -Original Message-
>  From: Darrian Walker [mailto:[EMAIL PROTECTED]]
>  Sent: Wednesday, 16 October 2002 1:10 PM
>  To: [EMAIL PROTECTED]
>  Subject: [PHP-DB] Passing string variable to HTML TITLE tag fails within
>Netscape but works well within IE.
>
>
>  Passing string variable to HTML TITLE tag fails within Netscape but work
>  well within IE.
>
>  I have a single page consisting of inventory items to be sold. When an
>item
>  is selected, it passes the product name to a DETAIL page as part of the
>  TITLE tag for the DETAIL page. My problem is: Netscape does not like the
>  SPACES between the text and refuses to display the DETAIL page.
>
>  Initially, I thought there might be some way to parse the string and add
>the
>  ascii code for SPACE, but I wasn't sure if I was on the right track. Does
>  anyone have a proven solution to this problem?
>
>  I thought the pseudo code might look something like this:
>function
>  parse_and_change(&grab_string){
>  $string_holder=$grab_string;
>  while stepping through the characters in this $string_holder
>  { if character = " " (or some other representation)
>  replace it with something that doesn't
>  scare netscape or title tag
>  }
>  return $string_holder;
>  }
>  ?>
>
>if (isset($HTTP_GET_VARS["itemname"])) {
>  $title = (parse_and_change($HTTP_GET_VARS["itemname"] ));
>  }else{
>  $title="Generic Product Title";
>  }
>  ?>
>
>  
>   
>  
>
>
>
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[PHP-DB] Re: [PHP] Re: Need help with HTTP-Authentication

2002-10-16 Thread dwalker

direct authentication with http headers

http://www.yourfavoritepage.com/login.php?v=nogo' );
}
?>




THIS E-MAIL MESSAGE AND ALL ATTACHMENTS TRANSMITTED HEREWITH ARE TRADE
SECRET AND/OR CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE VIEWING AND
USE OF ADDRESSEE.  IF THE READER OF THIS MESSAGE IS NOT THE INTENDED
RECIPIENT, YOU ARE HEREBY NOTIFIED THAT ANY REVIEW, USE, COMMUNICATION,
DISSEMINATION, DISTRIBUTION OR COPYING OF THIS COMMUNICATION IS PROHIBITED.
IF YOU HAVE RECEIVED THIS COMMUNICATION IN ERROR, PLEASE NOTIFY THE SENDER
IMMEDIATELY BY TELEPHONE OR ELECTRONIC MAIL, AND DELETE THIS MESSAGE AND
ALL COPIES AND BACKUPS THEREOF.  THANK YOU FOR YOUR COOPERATION.

-Original Message-
From: BAROILLER <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>;
[EMAIL PROTECTED] <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Wednesday, October 16, 2002 2:15 AM
Subject: [PHP] Re: Need help with HTTP-Authentication


>Hi,
>
>a simple question.. :)
>how do you do ?
>You can use 2 methods :
>with a .htaccess file on your webserver, updated with your table fields
>or a direct authentification with http headers and a little bit of php...
>Tell me more? may be I could help you.
>
>Regards,
>P.E. Baroiller
>
>"Davy Obdam" <[EMAIL PROTECTED]> a écrit dans le message de news:
>001901c2747e$fa0184a0$[EMAIL PROTECTED]
>> Hi People,.
>>
>> I have a problem with HTTP-Authentication, i have 2 users in my
>> database, and i want both to be able to login. However it works, but
>> only the first user is able to login. I Use a MySQL 3.23.xx database,
>> PHP 4.2.3 and Apache 2.0.40. Can anyone help me with this, any help
>> would be greatly apreciated. Thanks already;-)Maybe some examples?? ;-)
>>
>> Best regards,
>>
>> Davy Obdam,
>> mailto:[EMAIL PROTECTED]
>>
>>
>>
>>
>
>
>
>--
>PHP General 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