SQL DB Select Question/Issue

From: Date: Thu, 30 Nov 2000 18:17:01 +0000
Subject: SQL DB Select Question/Issue
Groups: php.db 
Request: Send a blank email to php-db+get-4898@lists.php.net to get a copy of this message
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@designtech1.com <mailto:kip@designtech1.com> . 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

« previous php.db (#4898) next »