[PHP-DB] Using checkbox in php problem

2002-02-23 Thread Killer Angel Clark
I add a checkbox in my page and will use the check result on another page. If it is checked, it has no problem. However, if it is not checked, it will have the checkbox unknown error. I read from an article that I can add a hidden field with the same name of the checkbox and put a value on this

Re: [PHP-DB] Using checkbox in php problem

2002-02-23 Thread Bogdan Stancescu
This is only part of the solution, but you should be aware that == is a comparison operator whereas = is the assignment operator. Bogdan Killer Angel Clark wrote: I add a checkbox in my page and will use the check result on another page. If it is checked, it has no problem. However, if it is

[PHP-DB] Getting the ID of the last inserted record possible?

2002-02-23 Thread Andy
Hi there, I would like to name pictures I uploaded after the belonging ID in the db. Is there a way to find out the ID of the last record. I thought it might be a good idea to create the record, get the ID and copy the image with the ID as name to the server. Can anybody give me a hint on

Re: [PHP-DB] Getting the ID of the last inserted record possible?

2002-02-23 Thread Andrey Hristov
mysql_insert_id() Regards Andrey - Original Message - From: Andy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 23, 2002 3:32 PM Subject: [PHP-DB] Getting the ID of the last inserted record possible? Hi there, I would like to name pictures I uploaded after the

Re: [PHP-DB] Using checkbox in php problem

2002-02-23 Thread Killer Angel Clark
Oh!! That is my careless mistake! I would uncheck the box when the box is checked for example. That solution cannot work on the javascript. Bogdan Stancescu [EMAIL PROTECTED] ¼¶¼g©ó¶l¥ó [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... This is only part of the solution, but you should be aware that

[PHP-DB] Re: Getting the ID of the last inserted record possible?

2002-02-23 Thread John Lim
What database are you talking about? Andy [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi there, I would like to name pictures I uploaded after the belonging ID in the db. Is there a way to find out the ID of the last record. I thought it might be a good

[PHP-DB] PHP IDE

2002-02-23 Thread Aron Pilhofer
After spending two frustrating hours tracking down a bug yesterday - only to discover it was a misplaced quote mark. I've had it. I am looking for suggestions out there for a good IDE for PHP development, preferably one that doesn't cost an arm and a leg. I tried PHP4EE studio, but it is

[PHP-DB] Re: MySQL problem

2002-02-23 Thread Aron Pilhofer
It means there is a problem with your query. I'm not familiar with the die(1) and die (2) syntax. I'm not sure what that does, but you might try echoing your error message from the query to see what message you get. Hope that helps. Caleb Walker [EMAIL PROTECTED] wrote in message [EMAIL

[PHP-DB] Instest of add, subtract.

2002-02-23 Thread Jennifer Downey
Hi, Instead of helping with my other question maybe you can tell me why this wont work? Is it not valid ? Can you not use strings in a query like this? $deposit=set bank_points + $user_deposit; $deposit .=set points - $user_deposit; $query = (UPDATE wt_users $deposit WHERE uid={$session[uid]}

[PHP-DB] Re: PHP IDE

2002-02-23 Thread robert janeczek
After spending two frustrating hours tracking down a bug yesterday - only to discover it was a misplaced quote mark. I've had it. I am looking for suggestions out there for a good IDE for PHP development, preferably one that doesn't cost an arm and a leg. I tried PHP4EE studio, but it

[PHP-DB] DB question

2002-02-23 Thread Morten Nielsen
Hi, I am about to make a homepage where people can sign up. It is then possible for the user to enter a lot of different data about them self. Is it normal to make a database for each user or should I make one big one? If I make a big one am I going to get problems if I has 1000+ users and

Re: [PHP-DB] Re: PHP IDE

2002-02-23 Thread ACEAlex
I use homesite just to tag the functions in different colors - Original Message - From: robert janeczek [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 23, 2002 8:59 PM Subject: [PHP-DB] Re: PHP IDE After spending two frustrating hours tracking down a bug yesterday -

Re: [PHP-DB] DB question

2002-02-23 Thread Bogdan Stancescu
No, at 1000+ you shouldn't have problems, almost no matter what database/data you're using. You may start getting slowdowns at 100,000+ users if you have a lot of data and probably 500,000+ if you have the reasonable data usually required. Anyway, using a different database for each user

Re: [PHP-DB] Instest of add, subtract.

2002-02-23 Thread Bogdan Stancescu
Well, there are quite some differences difference between the results these two pieces of code yield. Let's see what your sql query would be for the first version, replacing $deposit in $query: UPDATE wt_users set bank_points + $user_depositset points - $user_deposit WHERE uid={$session[uid]}

[PHP-DB] RC4 encryption with PHP

2002-02-23 Thread Troy A. Delagardelle
I am trying to encrypt a credit card number using rc4 and php and then dump it into a mySql database. Does anyone have any sample code that allows me to do this?? I found the Class.RC4Crypt algorithm and would like to use that. When I include the class.rc4crypt.php the page dies... Here is my

[PHP-DB] Re:Instest of add, subtract

2002-02-23 Thread Frank Flynn
I (too often) find that odd behavior like this is because one of the variables is set incorrectly (not what I expected) even if it sometimes works. A very useful debugging technique is to print out $query just before you send it to the DB. You might be surprised at what you're sending.

Re: [PHP-DB] Re: PHP IDE

2002-02-23 Thread Neil Thomson
i use PHP CODER PR2 the newer version of it i think suks. so if u want it ask. I like it tons. Neil - Original Message - From: ACEAlex [EMAIL PROTECTED] To: php-db [EMAIL PROTECTED] Sent: Sunday, February 24, 2002 8:38 AM Subject: Re: [PHP-DB] Re: PHP IDE I use homesite just to tag

[PHP-DB] PHP or Perl?

2002-02-23 Thread Logan Scott
I'm doing a bioinformatics project, which of course involves large databases. I will be using MS SQL Server and Visual Basic. A scripting language is also needed. Perl is very popular for bioinformatics. Should I use VBScript, PHP, or Perl? Thanks, Logan. -- PHP Database Mailing List

[PHP-DB] Performance Improvements

2002-02-23 Thread Lee Leahu
Hello, Currently the following section of code is taking over 30 seconds to complete. It basically returns from a database 30,000 records. What changes do any of you recommend that would speed of the following code? Thank you , lee leahu [EMAIL PROTECTED] snip while ($row =

Re: [PHP-DB] Performance Improvements

2002-02-23 Thread Bogdan Stancescu
My first suggestion: replace all split() calls with explode() calls. Bogdan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Performance Improvements

2002-02-23 Thread Bogdan Stancescu
Also, do you really need all those trim()'s? Maybe at least you could replace them with ltrim()'s or rtrim()'s - I don't know what your data is, but maybe you can pre-parse it? (i.e. keep the data trimmed in the db). All of the if ($something 0) can generally be changed to if ($something) -

Re: [PHP-DB] PHP IDE

2002-02-23 Thread Billy S Halsey
Aron Pilhofer wrote: After spending two frustrating hours tracking down a bug yesterday - only to discover it was a misplaced quote mark. I've had it. I am looking for suggestions out there for a good IDE for PHP development, preferably one that doesn't cost an arm and a leg. I tried