Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

Re: [PHP-DB] Limits From: Daniel Rezny (dr <email protected>)
Date: 12/01/00

Hello Shannon,

Thursday, November 30, 2000, 11:46:36 PM, you wrote:

SD> Hi people,

SD> is there a limit to the number of fields that can be updated in a mysql
SD> database at one time? ie can we update as many field with the one query as
SD> we like, or is there a maximum number of fields that can be changed.?

SD> The reason that I ask is that I have a large number of fields that need to
SD> be entered into a database on a form submit that I have decided to split
SD> over a few pages. The first page submits the data into the database no
SD> problem, the second page uses an update query and that works, but from then
SD> on the following 3 or 4 pages do not update the database with the data
SD> entered.

SD> Any ideas as to why this would be happening, I've done this before and never
SD> had the trouble, however this time I do have a lot of fields in the d'base
SD> and each query is quite large itself.

SD> Kind regards,

SD> Shannon

 I don't know about any limit with fields. When I have this problem in
 my scripts I always have a problem in sql query.
 So check query again, and try to write it to brovser it must work.

 hope it helps. 

-- 
Best regards,
 Daniel                            mailto:dr <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>