RE: [PHP-DB] Interbase BLOB problem

2002-10-30 Thread David Russell
Hi Peter, Thanks for this. I have been waiting for the PHP Manuals to include documentation on the interbase BLOB functions. I need to find a real connection and download it grin Actually my problem was that I have 2 machines - Windows (development and testing) and Linux (Server). The site was

[PHP-DB] Re: Decimal places.

2002-10-30 Thread David Robley
In article 118DC586DF4FD311948800A0247C044D02775821@NTSVR1, [EMAIL PROTECTED] says... Hay guys, I have two variables ( integers ) that are being minused one from the other and i am printing the result to the screen but i am getting unwanted decimals. print ($eall - $sall) / 1000; My

[PHP-DB] Retruning an array from a row

2002-10-30 Thread Erick Wellem
Hello All, How can I return and print an array from a user defined function from a database from a row like this, *just one row*, but it contains more than 1 columns: +++ | Field1 | Field2 | +++ | Data1 | Data2 | +++ I want the output will be:

RE: [PHP-DB] losing my session variables

2002-10-30 Thread Ford, Mike [LSS]
-Original Message- From: Peter Beckman [mailto:beckman;purplecow.com] Sent: 30 October 2002 04:09 To: Seabird Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] losing my session variables Put session_start() somewhere in your code. .. but make sure that somewhere is before you do any

Re: [PHP-DB] Retruning an array from a row

2002-10-30 Thread 1LT John W. Holmes
- Original Message - From: Erick Wellem [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 6:44 AM Subject: [PHP-DB] Retruning an array from a row Hello All, How can I return and print an array from a user defined function from a database from a row like this,

RE: [PHP-DB] Decimal places.

2002-10-30 Thread Josh Johnson
This works too: print (int)(($eall - $sall) / 1000); -- Josh -Original Message- From: Andrew Wilson [mailto:will;netwaynetworks.com.au] Sent: Tuesday, October 29, 2002 11:18 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Decimal places. Hay guys, I have two variables ( integers ) that

[PHP-DB] posted my problem online

2002-10-30 Thread Seabird
Hi everyone, I keep bumping into my problem with my session variables. Maybe a online example helps. I created a account: http://seabird.jmtech.ca username=forum password=forum I placed a array under my navigation on the left and one inside my welcome page (that onloads.) As you can see, it

Re: [PHP-DB] Inserting current date(MySQL)?

2002-10-30 Thread Jeffrey_N_Dyke
it looks like you have defined $ADDDATE and it is not a posted variable. what happens if you just have: ?php $ADDDATE=date(Y-m-d); mysql_query (INSERT INTO client (cl_add_date, cl_first_name, cl_last_name, cl_company, cl_phone, cl_email, cl_address, cl_city, cl_state,

Re: [PHP-DB] Inserting current date(MySQL)?

2002-10-30 Thread 1LT John W. Holmes
I'm my trying to insert to current date from a php form? I know that MySQL has a CURDATE() fucntion and PHP has several date function, but I cann't seem to get either to work? Here is my existing code: $ADDDATE=date(Y-m-d); [snip] VALUES ('$_POST[ADDDATE]', You've got two

[PHP-DB] Resolved: Inserting current date(MySQL)?

2002-10-30 Thread David Jackson
John, Jeffery, Alex and Jason -- Thanks for you response. As you all suggested it was as simple as CURDATE(). without any quotes or backticks. Thanks again, David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problems with ODBC connectivity

2002-10-30 Thread Andrew Hill
Bill, 1. Are you getting an error message in your PHP? 2. Can you successfully test the DSN in the ODBC Administrator? 3. Is the ODBC entry uncommented in the php.ini for your new install? Best regards, Andrew Hill Director of Technology Evangelism - OpenLink Software Universal Data Access and

[PHP-DB] Newbie-Question: What's that @?

2002-10-30 Thread Marcus Fleige
hi there, i've got a general question about php-scripts: whats the difference between @mysql_query($query) and @mysql_query($query)? is it the same as in batch programming? like, ignore all return messages? thanks and greetings from germany, marcus -- ^v^ [EMAIL PROTECTED] -- PHP

RE: [PHP-DB] Newbie-Question: What's that @?

2002-10-30 Thread Ryan Jameson (USA)
Well the only difference I see is the ? ... hehe... but if you are refering to the @ symbol then you are correct ... ignore errors... :-) Ryan -Original Message- From: Marcus Fleige [mailto:marcus.fleige;gmx.de] Sent: Wednesday, October 30, 2002 5:05 PM To: PHP-Mailinglist Subject:

RE: [PHP-DB] Newbie-Question: What's that @?

2002-10-30 Thread Josh Johnson
It suppresses error messages and warnings when you call a function, regardless of your level of error reporting. So yeah, it is like batch programming :) -- Josh -Original Message- From: Marcus Fleige [mailto:marcus.fleige;gmx.de] Sent: Wednesday, October 30, 2002 7:05 PM To:

RE: [PHP-DB] Session variables and arrays

2002-10-30 Thread Ryan Neudorf
Here are the results: is_array(): gettype():string strlen():5 -Original Message- From: Peter Beckman [mailto:beckman;purplecow.com] Sent: Wednesday, October 30, 2002 8:57 AM To: Ryan Neudorf Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Session variables and arrays On Wed, 30

RE: [PHP-DB] Newbie-Question: What's that @?

2002-10-30 Thread Marcus Fleige
great! @ryan josh: thank you for the quick answers! :-) marcus -- ^v^ [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Multiple table select, but still returning row if no record existsin second table?

2002-10-30 Thread Leif K-Brooks
I'm using mysql. Is there any way to do a multiple-table select, but still return the results from table 1 if there are no matching rows in table 2? Something like select table1.something,table2.something as something2 from table1,table2 where table1.table2id = table2.id will only return the

RE: [PHP-DB] Multiple table select, but still returning row if no record exists in second table?

2002-10-30 Thread John W. Holmes
LEFT JOIN -Original Message- From: Leif K-Brooks [mailto:eurleif;buyer-brokerage.com] Sent: Wednesday, October 30, 2002 9:49 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Multiple table select, but still returning row if no record exists in second table? I'm using mysql. Is there

[PHP-DB] HTML Select Boxes not displaying

2002-10-30 Thread Nigel Dunn
Hi Everyone, I have encountered a problem with IE that I am unsure how to get around. I dynamically create quite a few drop down boxes to enable categories to be oredered. It works fine for me (XP box) however everyone else in my office is running ME or 98 and it doesnt work in IE for any of

RE: [PHP-DB] HTML Select Boxes not displaying

2002-10-30 Thread John W. Holmes
What do you see in the HTML source of the browser's that don't work and how does it not work? The select boxes just don't show up at all? Do other form elements show up? ---John Holmes... -Original Message- From: Nigel Dunn [mailto:nigel.dunn;strobe.net.nz] Sent: Wednesday, October

[PHP-DB] global vars

2002-10-30 Thread Tomas Kubis
Hello, I have big problem. I upgraded PHP from 4.1.2 to 4.2.3 and my scripts with doesn´t work. Please help me! in php.info register globals=On For example I have one script: first.php ? global $a; $a=150; Header(Location: second.php); ? second.php ? echo $a; echo $GLOBALS['a']; echo END; ?

Re: [PHP-DB] global vars

2002-10-30 Thread David Smith
When you redirect, you lose your variables. This means that you must send them in some form to the other script. If you change your redirect command to the following, you will see that $a gets transferred and echoed in the second script as well as the first: Header(Location: second.php?a=$a);

RE: [PHP-DB] Session variables and arrays

2002-10-30 Thread Peter Beckman
After a little more research I found out strlen will return 5 for a real array too, so throw that out. However, since gettype prints a string not an array, I just don't know. print_r prints the array, but you can iterate through it. Do you do this before your loop?