RE: [PHP-DB] I have a problem to add a new line to the body of my email when I am using 'a href=mailto: ... function

2003-06-06 Thread Mark
I never knew that Body was supported. I had tried in years ago before it worked, and never looked back. If you look at the source code for this page (http://developer.netscape.com/viewsource/husted_mailto/mailto.html) you'll see that they use the javascript function escape() on the body text. I

RE: [PHP-DB] Datetime help in an INSERT...

2003-06-06 Thread NIPP, SCOTT V (SBCSI)
I have actually discovered that the $td value is blank. The reason appears to be that the page is reloading when a button is pushed, and that is when the $td value is being lost. My question now is, how do I keep the $td value after the page is reloaded? I would rather keep the value

[PHP-DB] Cookie issue

2003-06-06 Thread Marie Osypian
We are having complaints on our site about users not being able to log-in and we feel it maybe related to the setting of cookie. Here is the code used. Can anyone give me insight. /* some standard var's or other things like srand */ srand((double)microtime() * 100); $includes_root

Re: [PHP-DB] Datetime help in an INSERT...

2003-06-06 Thread CPT John W. Holmes
I have actually discovered that the $td value is blank. The reason appears to be that the page is reloading when a button is pushed, and that is when the $td value is being lost. My question now is, how do I keep the $td value after the page is reloaded? I would rather keep the value from

RE: [PHP-DB] address info, forms, maintanance

2003-06-06 Thread chip . wiegand
John W. Holmes [EMAIL PROTECTED] wrote on 06/04/2003 05:24:22 PM: Thanks to everyone for the suggestions. Got it fixed. Just added a couple lines of code - $sql1 = select * from endusers where name like '$name'; $result1 = mysql_query($sql1); $count1 =

Re: [PHP-DB] while - if - problem

2003-06-06 Thread Earl
Hey thanks Mike that surly made a difference. Earl ' - Original Message - From: Ford, Mike [LSS] [EMAIL PROTECTED] To: 'Earl' [EMAIL PROTECTED]; PHP-DB [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 6:13 AM Subject: RE: [PHP-DB] while - if - problem -Original Message- From:

RE: [PHP-DB] Datetime help in an INSERT...

2003-06-06 Thread NIPP, SCOTT V (SBCSI)
OK. I guess the next question would be what is the best option for performance? This portion of the app currently doesn't have any session functionality built in. I would be setting up the session for this sole purpose. I haven't worked with cookies yet. I suppose the URL method might

RE: [PHP-DB] Datetime help in an INSERT...

2003-06-06 Thread NIPP, SCOTT V (SBCSI)
Not sure exactly how I would implement this. Currently the reload URL is being provided via the $PHP_SELF variable. I like using this, but suppose I could change this if truly necessary. Also, the $td is not currently being passed into the function that generates the two buttons and hence

RE: [PHP-DB] Datetime help in an INSERT...

2003-06-06 Thread NIPP, SCOTT V (SBCSI)
I just responded to a separate but similar suggestion. The form elements, including the buttons, are all generated in a separate function. I am currently passing about 5 variables into this function and I am a little hesitant to pass any others. I am not sure about complexity,

Re: [PHP-DB] forms with php/mysql

2003-06-06 Thread Philippe Rousselot
Hi, Thanks all for your answers. What I mean by I am not a coder is that it will take me 3 month to do it while doing only that, because I code in PHP once a month. And since I help an association I cannot really spend my time doing this. What I can do is to take bits of code and put them

RE: [PHP-DB] Cookie issue

2003-06-06 Thread Marie Osypian
To add to this message: We are having problems with people using IE 6.0. They appear to sign-in and then are returned to the sign-in screen over and over. This doesnt happen to all that use the site. Thanks in advance -Original Message- From: Marie Osypian [mailto:[EMAIL PROTECTED]

RE: [PHP-DB] Datetime help in an INSERT...

2003-06-06 Thread NIPP, SCOTT V (SBCSI)
Thought I was on track, but stumped again... I am now getting a completely different error that I cannot figure out how it is related. I have passed the $td variable into the function and then get it back as a POST variable from a hidden field within the function. Here is the

RE: [PHP-DB] PHP/Mysql Script help.

2003-06-06 Thread Fulco of Scarborough
Thanks for all you wonderful help. With a little tweaking, and a new debugging program, I have been able to get the results I want. Now I'm going to begin adding some security features. Again, thanks for you help. Yours in Service, Jason Britton Scar's Legion http://st.fulco.net [EMAIL

Re: [PHP-DB] forms with php/mysql

2003-06-06 Thread Philippe Rousselot
done you can find the files at www.alcatorda.com/jcp/test/files.html and try it at www.alctorda.com/jcp/test/enregistrer.php I am sure it is full of bad codding but it works. I just have to make it nice now. Philippe Le Jeudi 5 Juin 2003 06:15, Peter Beckman a écrit : 1. Search the

Re: [PHP-DB] PHP sort from .... best solution?

2003-06-06 Thread A. Lyse
Hi! Thanks! But I got a problem with the code: The PHP file as it is with the code pasted into it will i'll past at the end of this post. The problem is I get the error: Warning: Invalid argument supplied for foreach() in /home/amotor/www/list_ingresser_artikler.php on line 43 If I put a // in

RE: [PHP-DB] Datetime help in an INSERT...

2003-06-06 Thread John W. Holmes
I am now getting a completely different error that I cannot figure out how it is related. I have passed the $td variable into the function and then get it back as a POST variable from a hidden field within the function. Here is the error I am now seeing; Unknown column 'sn4265' in

[PHP-DB] Problem when using browder back button

2003-06-06 Thread Harlan Lax
I am a bit confused. I have built a web site from dynamic pages using PHP Mysql. When a user selects an item from a drop down list that takes then to a detail page. When they click back on the browser button they get a message about the page has expired. Is this an issue of session or cookie?

RE: [PHP-DB] Problem when using browder back button

2003-06-06 Thread John W. Holmes
I am a bit confused. I have built a web site from dynamic pages using PHP Mysql. When a user selects an item from a drop down list that takes then to a detail page. When they click back on the browser button they get a message about the page has expired. Is this an issue of session or

RE: [PHP-DB] Problem when using browder back button

2003-06-06 Thread Matthew Horn
It's an issue of using POST instead of GET and has nothing to do with PHP. Most browsers won't re-post POST data for you for security reasons. GET, however, is just a URL with a query string, so it simply requests it. Assuming you can't re-write the POST inputs as GETs, is there a way around

RE: [PHP-DB] Problem when using browder back button

2003-06-06 Thread John W. Holmes
It's an issue of using POST instead of GET and has nothing to do with PHP. Most browsers won't re-post POST data for you for security reasons. GET, however, is just a URL with a query string, so it simply requests it. Assuming you can't re-write the POST inputs as GETs, is there a way

[PHP-DB] Calling Stored Procedures of Oracle in php

2003-06-06 Thread Ketan Parekh
Hi, I want to call a oracle stored procedure from php and retrieve the values. My procedure has 2 parameters which i have to pass and based on that it will return values. I am using the below code. I am getting errors like wrong arguements passed. Can anybody tell me the reason? $conn =

RE: [PHP-DB] Calling Stored Procedures of Oracle in php

2003-06-06 Thread Gary . Every
If this is a cut-n-paste of the code, check the line below for spelling: begin prcoedurename('[EMAIL PROTECTED]','3');end;; ^^^ Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original

[PHP-DB] Transfering variables

2003-06-06 Thread André Sannerholt
Hi everybody! I'm wondering how to transfer variables in a php-document to the same script after the form has been submitted!? Thanks. André -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MYSQL_CLIENT_COMPRESS

2003-06-06 Thread Armand Turpel
Hi, Is there any body who have experience with the flags in mysql_connect() in php = 4.3 . Especially the MYSQL_CLIENT_COMPRESS flag. Give it sense, to use this feature if both, apache/php and the mysql server reside on the same machine? Thanks, Armand -- PHP Database Mailing List

[PHP-DB] In Addition to 'Transfering variables'

2003-06-06 Thread André Sannerholt
I'm not sure if its get/post I need, beacause the variables are not a part of the form itself! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] In Addition to 'Transfering variables'

2003-06-06 Thread Hutchins, Richard
We all might benefit from an explanation of what you're trying to do here. Where does the data in your variables come from? If the variables are not part of the form itself, what _are_ they part of? What will be done with the data (e.g., used as query parameters, page display parameters, etc.)?

[PHP-DB] PHP Upgrade question...

2003-06-06 Thread NIPP, SCOTT V (SBCSI)
I know there is another mailing list for installation questions, but I am hoping for some help here. I get enough mail from this list alone without having to join another. Anyway, while attempting to compile version 4.3.2 I am running into the following error during the configure...

[PHP-DB] Is it worth upgrading Mysql on linux?

2003-06-06 Thread Chris Payne
Hi there everyone, I run a server from a great company which gives everything you need from $99 a month (450 gigs bandwidth, PHP, MySQL, SSL etc ...) Anyway, I currently run one of the latest builds of PHP but MySQL is only version 3.23.56 (Or something similar) - does anyone see any

Re: [PHP-DB] Is it worth upgrading Mysql on linux?

2003-06-06 Thread . ma
hi! if you upgrade i'd say upgrade to 4.1 which provides the IN()-method which allows komplex subselects. But may be this is not a very good idea cause 4.1 is only alpha afaik .ma e: [EMAIL PROTECTED] w: http://www.abendstille.at Life would be easier if i knew the source

RE: [PHP-DB] Is it worth upgrading Mysql on linux?

2003-06-06 Thread Hutchins, Richard
The following link may be of assistance: http://www.mysql.com/doc/en/Upgrading-from-3.23.html -Original Message- From: .ma [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 3:40 PM To: PHP-DB Subject: Re: [PHP-DB] Is it worth upgrading Mysql on linux? hi! if you upgrade

[PHP-DB] How to find the last ID?

2003-06-06 Thread Chris Payne
Hi there everyone, I'm creating a new entry using the following: mysql_query (INSERT INTO agents (agent_name) VALUES ('$agentname') but I need to find out the ID value it created, how can I do this easily? Thanks Chris

Re: [PHP-DB] How to find the last ID?

2003-06-06 Thread . ma
hi you can easily do this by using mysql_insert_id(); see http://www.php.net/manual/en/function.mysql-insert-id.php .ma e: [EMAIL PROTECTED] w: http://www.abendstille.at /***/ life would be easier if i knew the source code. Am Freitag, 06.06.03 um 23:16 Uhr schrieb Chris Payne: Hi

Re: [PHP-DB] How to find the last ID?

2003-06-06 Thread Chris Payne
Hi there, Thanks for your quick reply, very appreciated :-) Chris hi you can easily do this by using mysql_insert_id(); see http://www.php.net/manual/en/function.mysql-insert-id.php .ma e: [EMAIL PROTECTED] w: http://www.abendstille.at /***/ life would be easier

Re: [PHP-DB] How to find the last ID?

2003-06-06 Thread Jeff Shapiro
$last_id = mysql_insert_id(); Check out this page for details. http://www.php.net/manual/en/function.mysql-insert-id.php On Fri, 6 Jun 2003 17:16:01 -0400, Chris Payne wrote: Hi there everyone, I'm creating a new entry using the following: mysql_query (INSERT INTO agents (agent_name)

[PHP-DB] php4.3+apache2+interbase 7 problem

2003-06-06 Thread [EMAIL PROTECTED]
hello, i am installing Apache 2.0.40 and Php 4.3.1 and Interbase 7 and for some reason i have problem when my code try to select from a database if the query is update or insert delete etc. all works well until i try a select. if i install interbase 6 or lower version then everything is ok.

[PHP-DB] Seccond addition: 'Transfering variables'

2003-06-06 Thread André Sannerholt
Ok, the thing I accually want to do is to keep all the entries in one specific selection-option-box after the form has been submitted. I hope that is enough of explanation, because I cannot expect from you to go through my whole project... Regards, André -- PHP Database Mailing List

Re: [PHP-DB] Seccond addition: 'Transfering variables'

2003-06-06 Thread Becoming Digital
Entries from what? Do you have a code example of what you're working with now? Believe it or not, most of us would rather read through it than guess what you're trying to accomplish. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Andr Sannerholt

Re: [PHP-DB] Displaying groups from SELECT

2003-06-06 Thread Gürhan Özen
On Fri, 2003-06-06 at 21:49, Becoming Digital wrote: I'm wearing the stupid hat today, so please pardon this. I know I must be overlooking something. I have a small catalogue with two tables (categories, products) from which I'm trying to display items. I'm trying to print the contents as

Re: [PHP-DB] Displaying groups from SELECT

2003-06-06 Thread Becoming Digital
Thanks, Grhan, but I think I needed to explain things better. As is generally a good idea, the categories are referenced in the product table by ID, not name. Additionally, this is something along the lines of what I already had. I was trying to use only one query and make PHP do the remaining

Re: [PHP-DB] Calling Stored Procedures of Oracle in php

2003-06-06 Thread Ketan Parekh
RE: [PHP-DB] Calling Stored Procedures of Oracle in phpYou did not get it. Actually the procedure name means Any procedure Name say getName. It was just an example :-) - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Friday, June 06,

[PHP-DB] PHP Problem

2003-06-06 Thread Ramesh PAtel
Hi All Hi i install PHP4.3 and apache2 now i create one page for PHP Info i use ?php phpinfo();? i show all info on web page . But Problem is here When i create one page for Connect Database on PostgreSQL.it not work. mean Postgresql work well i test it. i thing PHP Command problem. Please

Re: [PHP-DB] PHP Problem

2003-06-06 Thread Becoming Digital
Please post the code you are trying to use so that we can try to find the problem. Without data, we can't tell you where things went wrong. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Ramesh PAtel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: