Re: [PHP-DB] How to add 2 years to todays date ?

2002-03-18 Thread Andrey Hristov
In php $your_timestamp += gmmktime(0,0,0,1,1,1972); MySQL has INTERVALling options. Regards, Andrey - Original Message - From: Dave Carrera [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 18, 2002 10:11 AM Subject: [PHP-DB] How to add 2 years to todays date ? Hi All I

[PHP-DB] javascript problem

2002-03-18 Thread Ali Nayeri
hi all, i know this is not exactly the place to ask this, but i don't know where else to ask. i'm doing a multiframe project and i'm trying to get one of the pages to change the content of another frame when it loads. in the main.htm i have: html head titleA Global Village?/title ... script

[PHP-DB] Re: Conflicting results using PHP/Mysql

2002-03-18 Thread George Pitcher
Doug, Sorry for leaving this so long but I've been tied up in business meetings. It may be that my query is restricting the data retrieval but I cannot see how. If I look at the data I am playing with, I have 3 tables and I want to show transactions from a certain course. I also want to show

RE: [PHP-DB] increase date()

2002-03-18 Thread Rankin, Randy
Try this: $six_months_from_now = date(Y-m-d, mktime(0,0,0, date(m)+6, date(1), date(Y))); echo Six Months From Now: $six_months_from_nowP; -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 12:28 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] increase

Re: [PHP-DB] javascript problem

2002-03-18 Thread Josh Trutwin
I am not a JavaScript expert, but I had a similar problem. I THINK that you need to reference your frames like this: window.parent.frames.rightFrame.document.open(); Give it a try, hope that helps... Josh hi all, i know this is not exactly the place to ask this, but i don't know where

Re: [PHP-DB] javascript problem

2002-03-18 Thread Remco Oosten
If your framecontainer is your top-document perhaps you can use: top.rightFrame.document.open(); or maybe top.rightFrame.location=''; Remco - Original Message - From: Josh Trutwin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, March 18, 2002 4:25 PM

RE: [PHP-DB] I can't get Oracle record structure from PHP

2002-03-18 Thread Sumesh Nair
what error does it give u. also check some of these examples on http://conf.php.net/pres/index.php?p=slides%2Fociid=oci -Original Message- From: Csillag Zsolt [mailto:[EMAIL PROTECTED]] Sent: 17 March 2002 18:40 To: [EMAIL PROTECTED] Subject: [PHP-DB] I can't get Oracle record structure

[PHP-DB] Fill select boxes with dependent data from a database. How?

2002-03-18 Thread Marco Viehl
Hi all, i am searching for a solution for filling 2 (or 3) dependent select boxes with values from a database. That means, when you select a value in selectbox 1 the options for the second selectbox should be filled with values related to select box 1. Short example Value for box 1

RE: [PHP-DB] RE: [PHP-WIN] Stange 'page-loading' effect

2002-03-18 Thread Jonathan Hilgeman
You should check your error logs after getting the server not found error. There will frequently be PHP error messages stored in there that might help discern the problem. You can also set checkpoints in your code that write out Passed this part, passed this part, etc to a temporary debugging

[PHP-DB] How to bring down the mysql server smoothly

2002-03-18 Thread andy
Hi there, how is it possible to bring down the server after starting with safe_mysqld. I read, that killing the ps with -9 is demmaging the tables. Thanx, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] textarea and mysql query

2002-03-18 Thread jas
I need some help with a query to place the results within a text area... here is the code and so far every time I try it out all that happens is it displays the textbox but not the results of the query. form name=wel_area method=post action=index_confirm.php3 target=box ?php $record =

RE: [PHP-DB] textarea and mysql query

2002-03-18 Thread Hunter, Ray
Try this: form name=wel_area method=post action=index_confirm.php3 target=box ?php $record = mysql_fetch_array(@mysql_query(SELECT wel_area FROM cm_index,$dbh)); echo textarea name='wel_area' value='.$record['wel_area'].' cols='25' rows='8'/textareabrinput type='submit' name='save'

Re: [PHP-DB] textarea and mysql query

2002-03-18 Thread Jason Wong
On Monday 18 March 2002 14:53, jas wrote: I need some help with a query to place the results within a text area... here is the code and so far every time I try it out all that happens is it displays the textbox but not the results of the query. form name=wel_area method=post

Re: [PHP-DB] textarea and mysql query

2002-03-18 Thread jas
Yeah that didn't work either... If I put the same value ( value=\{$record['wel_area']}\ ) on a text line it works just fine however using the same value for a textarea doesnt give me any results nor does it give me an error message to go on, if there is a way to output the code to the screen like

Re: [PHP-DB] textarea and mysql query

2002-03-18 Thread jas
Sorry, the connection is established already so that part works just fine. It is getting the results of said connection \ query to appear in a textarea vs. a text line. Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... On Monday 18 March 2002 14:53, jas wrote: I need

RE: [PHP-DB] textarea and mysql query

2002-03-18 Thread Hunter, Ray
What is the result of $record['wel_area']. If this is a multidimensional array then you will need to access it differently... Example: echo $record[0][0].\n; Try this is your text area and see if that comes out... Thank you, Ray Hunter Firmware Engineer ENTERASYS NETWORKS

Re: [PHP-DB] textarea and mysql query

2002-03-18 Thread jas
Yeah it is not multidimensional at all, a simple text blob is what should be pulled into the textarea. I am not trying to query multipled record fields at all. One field per textarea. Do you know of a good tutorial on pulling sql queries into textareas? If you do please let me know as I have

Re: [PHP-DB] textarea and mysql query

2002-03-18 Thread John Hughes
jas [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I need some help with a query to place the results within a text area... here is the code and so far every time I try it out all that happens is it displays the textbox but not the results of the query. form

Re: [PHP-DB] textarea and mysql query

2002-03-18 Thread Jason Wong
On Monday 18 March 2002 15:09, jas wrote: Sorry, the connection is established already so that part works just fine. It is getting the results of said connection \ query to appear in a textarea vs. a text line. Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... On

RE: [PHP-DB] textarea and mysql query

2002-03-18 Thread Shrock, Court
You problem lies in the html that you are outputting. For normal html input tags, you use the value attribute to initialize the default display. For textarea tags, you do not use the value attribute; instead, enclose what you want displayed between the openining textarea tag and the closing

[PHP-DB] SQL statement - PHP/mySQL - brain fart

2002-03-18 Thread Summit
For some reason I keep thinking that this should be simple - but I just can't seem to figure it out. Help??? Please??? [I've been working on it for two days now.] Overview: What I'm trying to do is query one table by passing it two different variables - and return only the results that are

[PHP-DB] How display a BLOB field contents in a HTML file?

2002-03-18 Thread Sergio Cornejo
Hi. I work in a client project that need to show a images of his products in a HTML file. I work with MySQL 3.23.47 for windows 98, Apache 1.3.23 for windows and PHP4. I insert the images with EMS MySQL Manager (is too easy) My databese work ok wend i retrive text information like product_ID

Re: [PHP-DB] passing array through $PHP_SELF

2002-03-18 Thread Mike de Libero
Sorry to say but the inelegant solution is the only way I have found how to do it :(. I read it on php FAQTs on how to pass arrays on multi-step forms. This is a very similar thing. So yes you have to implode the array then pass it in a hidden field. Then explode the array after being passed

RE: [PHP-DB] passing array through $PHP_SELF

2002-03-18 Thread Shrock, Court
Why not write hidden inputs and name them appropriately so that when the form gets submitted again, the array gets created automatically--no implode/explode. input name=input[var1] value=hello input name=input[var2] value=world then, upon submittal, the array, $_POST['input'], would look like

Re: [PHP-DB] passing array through $PHP_SELF

2002-03-18 Thread Jason Wong
On Tuesday 19 March 2002 09:27, John Hughes, Jomari Works wrote: I have a page that selects students from a mysql table who meet a certain requirement. Those who meet the requirement have a check box variable that is checked. (The other students have the check box, but it is unchecked.) The

Re: [PHP-DB] SQL statement - PHP/mySQL - brain fart

2002-03-18 Thread Jason Wong
On Tuesday 19 March 2002 10:22, Summit wrote: For some reason I keep thinking that this should be simple - but I just can't seem to figure it out. Help??? Please??? [I've been working on it for two days now.] Overview: What I'm trying to do is query one table by passing it two different

[PHP-DB] post to a url and return to same page

2002-03-18 Thread mailing list
Hello, I am trying to post to a URL and return to the same page with the result and or error messages. The shared server that is hosting this site was not compiled with CURL. Is there an alternative way to post a form to an alternate url and return to the same page without having to rely on

[PHP-DB] login problem wasn't solved

2002-03-18 Thread its me
i have sell.php page which requires loggin so i put in it: ? session_start(); if(!(session_is_registered(valusername))) { $page=$PHP_SELF; session_register(page); header(Location:http://$HTTP_HOST/auction/login.php;); exit(); } ? then in login.php i have; $sql = SELECT

RE: [PHP-DB] SQL statement - PHP/mySQL - brain fart

2002-03-18 Thread Gurhan Ozen
ok it is 1:37 am here and i have been up since 6:00 am (the day before) and have to be awake ths mornign again at 6:00 am so if I make any mistakes trying to answer your question, please take it easy:) I was wondering if you'd wanna use temporary tables to accomplish it.. You may wanna do:

[PHP-DB] Re: php-db Digest 18 Mar 2002 18:40:25 -0000 Issue 1105

2002-03-18 Thread Rob Small
At 06:40 PM 3/18/2002 +, you wrote: Subject: How to add 2 years to todays date ? Hi All I think the subject line says it all. How to add 2 years to today's date ? Any helps as always most appreciated. Dave Carrera Php Developer Subject: Re: [PHP-DB] How to add 2 years to todays date ?

Re: [PHP-DB] SQL statement - PHP/mySQL - brain fart

2002-03-18 Thread Frank Flynn
Well it's sorta' simple once you get your mind around this - you need two tables but you've only got one. And there's no OR, you need both to be true for a site_id ... The query would be easy if you actually had two tables so we'll search off of the same table twice giving it different names

[PHP-DB] Re: Conflicting results using PHP/Mysql

2002-03-18 Thread George Pitcher
Thanks to Kevin, who yesterday emailed me with a solution to my JOIN problem. Thanks to all who helped me see the wood for the trees. George - Original Message - From: Doug Thompson [EMAIL PROTECTED] To: George Pitcher [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: