RE: [PHP-DB] Session variables and arrays

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? reset($_SESSION['categories']

Re: [PHP-DB] global vars

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"); N

[PHP-DB] global vars

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 second.php Where I have a bug? Thank you very much Tomas Kubis -- PHP Database Mailing List (http://w

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

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

[PHP-DB] HTML Select Boxes not displaying

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 the

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

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

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

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 th

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

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

RE: [PHP-DB] Session variables and arrays

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

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

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: PHP-Mail

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

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:

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

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 Databa

Re: [PHP-DB] Problems with ODBC connectivity

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 th

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

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

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

I'm no expert, but here's what I did in the same situation. $enterdate = date('Ymd'); --- this gives me the current date. then when entering the information from the form into my database I just entered the variable into a field called evdt When using the date I wanted it in a more user friendly

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

> 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

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

it looks like you have defined $ADDDATE and it is not a posted variable. what happens if you just have: Jeff David Jackson

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

Howdy -- 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: TIA, David Jackson -- client_add.php $ADDDATE=date("Y-m-d");

[PHP-DB] posted my problem online

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 ha

RE: [PHP-DB] Session variables and arrays

On Wed, 30 Oct 2002, Ryan Neudorf wrote: > Ok. The categories are coming from checkboxes, e.g.: > Accountant > > Which then are handled by a $cgi class dealy and handed to the > $_SESSION['categories'] variable before being forwarded to the next > step. I was thinking that the problem might be wit

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

Hello John, Thanks, I've modified my code, and the solution is very simple function get_dbfield_data(){ $conn=dbconn(); // mysql connection function $result=mysql_query("SELECT Field1,Field2 FROM table_name WHERE Condition); $row=mysql_fetch_array($result); return $row; } // End function

RE: [PHP-DB] Decimal places.

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 a

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

- 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 l

RE: [PHP-DB] losing my session variables

> -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 befo

[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, *just one row*, but it contains more than 1 columns: +++ | Field1 | Field2 | +++ | Data1 | Data2 | +++ I want the output will be: Dat

[PHP-DB] Re: Decimal places.

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;

RE: [PHP-DB] Interbase BLOB problem

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 Actually my problem was that I have 2 machines - Windows (development and testing) and Linux (Server). The site was initia