[PHP-DB] Fatal error: Unknown():

2004-03-30 Thread Maurice Kevenaar
Hi all, I'm using Firebird as an database. I'm gettin BLOB's form the database (memo) On one pc I receve the folloing 2 errors: Fatal error: Unknown(): You can lose data. Close any blob after reading of writing it. Use ibase_blob_close() before calling ibase_close() in Unknown on line 0 Warning

Re: [PHP-DB] DATE_SUB Issues

2004-03-30 Thread Ricardo Lopes
the first time i saw this post i get confused, let me see if i understand. you want the _CURRENT_ week stats OR the stats from the last 7 days if you want the first you cant use now the reason why that script works was because it was monday :) > SELECT SUM(distance), DATE_FORMAT(time_upload,

Re: [PHP-DB] DATE_SUB Issues

2004-03-30 Thread Ricardo Lopes
sorry, i press Control+Enter and i send the unfinished mail, here is the continuation: it worked because it was monday, probably today you arent happy. try this sql, but i dont like the GROUP clause SELECT SUM(distance), DATE_FORMAT(time_upload, '%u'), WEEK(time_upload, 1) FROM TRAININGLOG WHERE

[PHP-DB] Re: INSERT problem--Need help urgently

2004-03-30 Thread JeRRy
Date: Tue, 30 Mar 2004 15:13:35 +0800 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: INSERT problem--Need help urgently Hi all: I was having some problem with INSERT query here and do hope to get some help real soon. I have a form whereby once the form is submitted, the values ente

Re: [PHP-DB] INSERT problem--Need help urgently

2004-03-30 Thread irinchiang
sorie it was my typo error. actually in my code there is already {} with my first if statement and there is also a space after VALUES... I still need some help here with my code...how can I prevent it from inserting a duplicate row of null values>??? Anyone can help ? Thanks in advance. Regard

Re: [PHP-DB] INSERT problem--Need help urgently

2004-03-30 Thread Jason Wong
On Tuesday 30 March 2004 19:46, [EMAIL PROTECTED] wrote: > sorie it was my typo error. actually in my code there is already {} with my > first if statement and there is also a space after VALUES... Whenever you post code, use copy and paste, or be extremely meticulous that you do not introduce ty

Re: [PHP-DB] INSERT problem--Need help urgently

2004-03-30 Thread irinchiang
Hi Jason: okay I have echoed $sql and before I did enter anything into the form, the form is already inserting null values into the database. Maybe that is the reason for the duplicate row of null values. Do you know how can I prevent this from happening??Hope to hear from you soon. Regards,

Re: [PHP-DB] INSERT problem--Need help urgently

2004-03-30 Thread Jason Wong
On Tuesday 30 March 2004 20:13, [EMAIL PROTECTED] wrote: > okay I have echoed $sql and before I did enter anything into the form, the > form is already inserting null values into the database. Maybe that is the > reason for the duplicate row of null values. Yes, that would be the reason. > Do yo

[PHP-DB] Tree structure - how to show only current branch ??

2004-03-30 Thread -{ Rene Brehmer }-
Ok, Tom Reed got my thinker running big time ... and I've been trying to build an expandable and modifiable tree structure where it only displays the branch leading to the current folder... Showing the entire tree is easy, but how do I change the code to only display the branch we need??? ... I

RE: [PHP-DB] Tree structure - how to show only current branch ??

2004-03-30 Thread Galbreath, Mark A
Already been done: http://www.destroydrop.com/javascripts/tree/ Mark -Original Message- From: -{ Rene Brehmer }- [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 7:50 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Tree structure - how to show only current branch ?? Ok, Tom Reed got

Re: [PHP-DB] DATE_SUB Issues

2004-03-30 Thread Craig Hoffman
Thanks - I'll play with it today. __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ On Mar 30, 2004, at 3:32 AM, Ricardo Lopes wrote: sorry, i press Control+Enter and i sen

[PHP-DB] passing a variable value of PHP into the alert of JavaScript.

2004-03-30 Thread Prabu Subroto
Dear my friends... I want to make an alert which can display a value from the database. I am meaning : how can I pass a value of a variable from PHP into JavaScript alert ( alert("$Firstname, $LastName and $Address"); Is it possible? -- __

Re: [PHP-DB] DATE_SUB Issues

2004-03-30 Thread Craig Hoffman
sorry about the multiple reply's. I tested the query with a few future dates and it seemed to be worked. Thanks again for your help. Thanks - Craig __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net

Re: [PHP-DB] passing a variable value of PHP into the alert of JavaScript.

2004-03-30 Thread Mikhail U. Petrov
Hi! I didn't exactly understood what you mean, but I think there're no problems with it... You should echo these variables into html, for example: bla bla bla function my_alert(name, lastname, address){ alert(name); } bla bla bla Hello Prabu, Tuesday, March 30, 2004, 5:21:39 PM, you wrote: P

Re: [PHP-DB] passing a variable value of PHP into the alert of JavaScript.

2004-03-30 Thread Prabu Subroto
Akh... thank you my friend It's solved. May I ask another question? Can I call a function of PHP code from HTML tag just the same as I call a function of JavaScript from HTML tag? I meant, Like this "CustID"; - Original Message - From: "Mikhail U. Petrov" <[EMAIL PROTECTED]> Date: Tu

RE: [PHP-DB] Tree structure - how to show only current branch ??

2004-03-30 Thread Paul Miller
Ya it has - that is a great script! -Original Message- From: Galbreath, Mark A [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 7:15 AM To: '-{ Rene Brehmer }-'; '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] Tree structure - how to show only current branch ?? Already been done: http

Re[2]: [PHP-DB] passing a variable value of PHP into the alert of JavaScript.

2004-03-30 Thread Mikhail U. Petrov
Hi! No, you can't. PHP generate page and finish the work. After that you can't execute any PHP function. Hello Prabu, Tuesday, March 30, 2004, 6:20:16 PM, you wrote: PS> Akh... thank you my friend It's solved. PS> May I ask another question? PS> Can I call a function of PHP code from HTML t

RE: [PHP-DB] Tree structure - how to show only current branch ??

2004-03-30 Thread -{ Rene Brehmer }-
Eh ... now, I dunno what part you missed ... but that's JavaScript, and I'm working in PHP ... why would I care what's been done in JS ??? That won't get me much further with what I'm trying to do... Not to mention that I hate using others code, and never have sofar, then it will take about as

Re: [PHP-DB] Tree structure - how to show only current branch ??

2004-03-30 Thread Ignatius Reilly
The same can be achieved by using the excellent PEAR HTML_TreeMenu class. Key advantage, of course, is that the API is in PHP. HTH Ignatius _ - Original Message - From: "Paul Miller" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 30, 2004 4:22 PM

Re: [PHP-DB] Tree structure - how to show only current branch ??

2004-03-30 Thread Ricardo Lopes
> Not to mention that I hate using others code i dont agrre with that, i guess probably you write your own string/date handling functions, you write your own code to connect to database and other stuffs right? :-) > it will take about as long to convert that to something workable in PHP, as it >

[PHP-DB] Re: Tree structure - how to show only current branch ??

2004-03-30 Thread Kim Steinhaug
Well, I did a similar system for my CMS sollution. If I understand you correct you want to sort the main branch, keeping the subs. The sorting was in my case the part that I spent most of the time coding. The other part, selecting the subs I did really simple. As a main rule, I only select the m

[PHP-DB] Re: Newbie question

2004-03-30 Thread Kim Steinhaug
Well, Could be some sort of debugging mode on the PHP running on the server. On the other hand your script is depending on the fact that GLOBALS are turned on, which - you shouldnt. 1) Anywho - you form is using POST, so you should use this syntax : $_POST["variable"], if using GET the equ