SQL DB Select Question/Issue
| From: | Kip O'Shaughnessy | 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