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:

[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 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 help where is Probl

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,

Re: [PHP-DB] Displaying groups from SELECT

2003-06-06 Thread Becoming Digital
Thanks, Gürhan, 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 w

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

[PHP-DB] Displaying groups from SELECT

2003-06-06 Thread Becoming Digital
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 below without using two queries, but I'm having a difficult

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" <[E

[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 (http://ww

[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. also

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

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 wo

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

[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] 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

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 c

[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 advantages

[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... che

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.)? Ha

[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

[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 (http://w

[PHP-DB] PHP, ODBC, Unable to Connect

2003-06-06 Thread Joseph McDonald
Here is the code (acct # blurred for obvious reason): ##begin paste## ##end paste## Here is the result: ##being paste## Warning: SQL error: [Simba Technologies Inc.][SimbaEngine C/S ODBC Driver][SimbaClient][SimbaClient LNA]Client RPC error. Error = (103) Error sending message. Trap = (111) Error

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 se

Re: [PHP-DB] Transfering variables

2003-06-06 Thread mike karthauser
on 6/6/03 5:52 pm, André Sannerholt at [EMAIL PROTECTED] wrote: > I'm wondering how to transfer variables in a php-document to the same script > after the form has been submitted!? if ($_POST['submit']) { //stuff } else { // form stuff } HTH -- Mike Karthauser Managing Director - Brights

[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] 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] 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 'sn42

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 Mes

[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 = ora_logo

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] 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 arc

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 th

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 a

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 PROTECTE

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

2003-06-06 Thread Ford, Mike [LSS]
> -Original Message- > From: A. Lyse [mailto:[EMAIL PROTECTED] > Sent: 06 June 2003 11:34 This was sent privately to me, but I'm redirecting the response back to the list in case it helps anyone else. > Feeling kinda stupid. hehe. sorry I didnt label the lines. Probably no more stupid t

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

2003-06-06 Thread Ford, Mike [LSS]
> -Original Message- > From: A. Lyse [mailto:[EMAIL PROTECTED] > Sent: 05 June 2003 21:21 > > 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: Invali

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 erro

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] Sen

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 tog

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, performance

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)
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] 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

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 = mysq

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 fro

[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 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 fro