Answer to my own question

I've got the answer to my own question. The previous function opened a connection to the MSSQL DB. Because I'm new to this, I noticed that I forgot to do select a table. I just assumed that that was covered in the @mssql_query($sys_dbname,$qstring); call, which apparently it wasn't. Thanks to everyone that helped. >Has anyone here been successful in getting PHP to work with Microsoft SQL >server 7.0? I've got a pretty basic and reasonably simple question about >it, but I'm stymied from lack of Red Bull in my diet. > >Why is mssql_query() not working? I'm using it for an insert, and it's >not returning anything - the SQL comes out correctly, but the fuction >isn't returning anything. > >I'm using the following: > >function db_query($qstring) { > global $sys_dbname; > return @mssql_query($sys_dbname,$qstring); >} > >where $sys_dbname is the name of the database and $qstring is the name of >the query string. > >I have got freeTDS installed and pointed to... do I need more/am I going >completely down the wrong path? > >I'm sure it's obvious, I'm new at this. I know this has been covered >before, but none of the answers answer the question, they just say >"install freetds" which is done, but my INSERTS still don't happen. > >Followup question: >Is there a web archive of this list that I haven't found yet? > >-Jonathan Swerdloff, >http://www.swerdloff.com/ > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net =--=--=--=--=--=--=--=--= Jonathan Swerdloff http://www.swerdloff.com/