php/mysql column limit?

[dreams4000]

Hi all,

I have a dynamic table that may get into the 40x40 range and each cell in it will have data.:\ So I need to know, does mysql have a column limit that can be used in a particular table? and does php have a limit to the amount it can display out? like in the range of 1600-2000 columns?🙂 thanks all

[Weedpacket]

http://dev.mysql.com/doc/mysql/en/Table_size.html
Somewhere down in the user notes.

PHP doesn't care. Depends on how much memory your machine can supply.