[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

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

[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

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.

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

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 you

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

[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: htmlboby bla bla bla function my_alert(name, lastname, address){ alert(name); } ?php echo javascript:myalert(. $Firstname . , . $Lastname . and .

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 a Onclick='warning()'CustID/a; - Original Message - From: Mikhail U. Petrov [EMAIL

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:

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

[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