Re: [PHP-DB] Re - Direct a User after a completed Form

2002-04-01 Thread wesley grubbs:.
header is the appropriate one you're looking for: header( Location: thanks.php ); what i do is use the page that processes all the data to also validate the data. if the data does not pass through, it stays on this page with all the errors listed in the body. if it goes through.. then the

[PHP-DB] Pop up are you sure...

2002-04-01 Thread Dave Carrera
Hi All How do you do this? On click of button to delete a record make a popup yes / no box appear. On yes then do it else stop. Is it possible to do with out using JS? Thanks for any pointers or code in advance. Dave Carrera Php Developer http://davecarrera.freelancers.net

Re: [PHP-DB] Problem with PHP connectivity with mySQL (RedHat package)

2002-04-01 Thread CK Raju
If that works fine, check out for the php-xxx rpms including the php-mysql- one. CK Raju ** Message from InterScan E-Mail VirusWall NT ** ** No virus found in attached file noname.htm This is a virus free message scanned by Zyberway * End of message

[PHP-DB] locking a record

2002-04-01 Thread Natividad Castro
Hi to all, I have a MySQL DB, and I'm retrieving the data using PHP. There will be about 10 users that will work in a form at the same time. My question is how do I lock the a record? for example user 1 access record 1; I don't want user 2 be able to have access to the same record. Is it possible

RE: [PHP-DB] int or tinyint

2002-04-01 Thread Jonathan Hilgeman
Hi Jennifer, In most cases, it's best to use int. The difference between the two is simply the range of numbers they can show. Tinyint is fine for cases where you know you'll never need more than 127 (or 255 if you tell MySQL that it is an UNSIGNED tinyint, which just means that it can't have

RE: [PHP-DB] Pop up are you sure...

2002-04-01 Thread Jonathan Hilgeman
You're so negative, Jason. :) Long answer, Dave, it wouldn't be wise to do this via Javascript. Javascript can be turned off and also varies from browser to browser (like any client-side language/scripting), so this raises an issue of reliability. You may be able to do it if you're working on an

Re: [PHP-DB] Pop up are you sure...

2002-04-01 Thread Jason Wong
On Tuesday 02 April 2002 01:30, Jonathan Hilgeman wrote: You're so negative, Jason. :) No, my answer was just short and to the point ;-) Long answer, Dave, it wouldn't be wise to do this via Javascript. My long answer was going to be: it's possible to do it in PHP, but then it would not

RE: [PHP-DB] Pop up are you sure...

2002-04-01 Thread Jonathan Hilgeman
shrug I was close. :) -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 10:53 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Pop up are you sure... On Tuesday 02 April 2002 01:30, Jonathan Hilgeman wrote: You're so negative, Jason. :) No, my

Re: [PHP-DB] Pop up are you sure...

2002-04-01 Thread Dan Brunner
Hello!! What I was able to do was this On every form page I have, I have a checkbox that is labeled Ok To Save, that the user would check or not.. I would then pass that variable to the next page and check to see if the value was true or not... If it is true then it would continue

[PHP-DB] Using MyODBC V 2.50.39.00

2002-04-01 Thread Peter J. Krawetzky
I found a note on the MySQL website that MyODBC has a limitation in the number of columns that it returns. Is this true? I am successfully connecting to a MySQL database but I keep getting the error: Warning: Field index is larger than the number of fields in (program-name) on line 78.

[PHP-DB] Grouping menu items

2002-04-01 Thread Kim Kohen
Hello All, I have a MySql database which has a 'sections' column which includes values such as Real Estate, Sport, Letters etc. The 'News' section is divided into 4 parts to indicate a priority for any given story; News, News2, News3 and News4. We are using: $getlist1 = mysql_query(SELECT

[PHP-DB] Re: Grouping menu items

2002-04-01 Thread Kim Kohen
Hello All Forget my previous post - I will simply run an update on the table to alter all the various News variations back to 'News' cheers kim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] autoincrement

2002-04-01 Thread Daniel Broome
I am trying to add auto increment to a table I have already created in phpMyAdmin but I keeps coming up with an error. what can I do to fix this? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: autoincrement

2002-04-01 Thread Glenn Holden
What's the error? Do you already have an auto-inc field? Have you tried it with another interface? Ie: directly in the MySQL command line util. Glenn Notes from MySQL.com: There can be only one AUTO_INCREMENT column per table, and it must be indexed. When you add an AUTO_INCREMENT column,

[PHP-DB] Re: Pop up are you sure...

2002-04-01 Thread Adam Royle
Dave, Javascript is client side. PHP is server side. Obviously the limitations imposed by each of the languages is evident. PHP can't do anything once the output is sent to the browser. JavaScript can't do anything before it gets sent to the browser. But, each is important as the other. Learn

Re: [PHP-DB] Pop up are you sure...

2002-04-01 Thread Dave Carrera
Hi all, Thank you all for you advice. I am aware of the two ways of achieving the required result ie: JS and extra button built into my script. But wouldn't it be nice to have a class or function we could all use built in to php that would let us do this. C,C++,Delphi and JS allow

Re: [PHP-DB] Pop up are you sure...

2002-04-01 Thread php3
Addressed to: Dave Carrera [EMAIL PROTECTED] [EMAIL PROTECTED] ** Reply to note from Dave Carrera [EMAIL PROTECTED] Tue, 2 Apr 2002 07:23:43 +0100 But wouldn't it be nice to have a class or function we could all use built in to php that would let us do this. C,C++,Delphi