[PHP-DB] SQL DB Select Question/Issue From: Kip O'Shaughnessy (kip <email protected>)
Date: 11/30/00

To Anyone:

I am trying to select from a db table containing 22 columns containing data
ranging from 10-200 characters in size for each column.

When I use this below, it works fine and script ends successfully:

        $result=mssql_query("select
fieldname,displayname,fieldtype,fieldtype2,fieldtype3,specialsnippet,fieldle
ngth,linkingtable,linktablefields,orderby,ordertype,defaultvalue,validityid
from wu_def where tablename='$table' order by taborder",$id);

However if I use this to select all columns (22), my script outputs
properly, however script still runs, then timeouts and generates an
application error on my WinNT box:

        $result=mssql_query("select * from wu_def where tablename='$table'
order by taborder",$id);

Anybody have any input on why this might be happening? Please email me back
at kip <email protected> <mailto:kip <email protected>> . Thank you very much!

Kip O'Shaughnessy
Senior Webmaster

Chamerlik/CompuLogic
http://www.designtech1.com/ <http://www.designtech1.com/>

P: 847.679.5030 - F: 847.933.9413 

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