Skip to Content.
Sympa Menu

freetds - MSSQL Queries not working?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Gonzalez, Zara E" <gonzalze AT mail.slh.wisc.edu>
  • To: 'TDS Development Group' <freetds AT franklin.oit.unc.edu>
  • Subject: MSSQL Queries not working?
  • Date: Wed, 9 Jan 2002 13:02:36 -0600


Hi,

I have Freetds 0.53 connecting to a MSSQL 2000 box...
I can't seem to pull information out of the database. I can insert, but not
pull
data out.

Am I using the wrong code? Here is the code that is not working. It seems to
be
failing on the $result line since when I comment that line out, I at least get
an error. If that line isn't commented then all I get is "Page cannot be
displayed".

Any Ideas or suggestions?

mssql_connect(DB_HOST, DB_USER, DB_PW) or DIE("Error: Server failed to
respond.");
mssql_select_db(DB_NAME) or DIE("Error: Could not connect to table.");
$query = "SELECT * FROM test where id = '$id'";
$result = MSSQL_QUERY($query) or DIE("Error: Could not handle Query.");
$r = MSSQL_FETCH_ARRAY($result) or DIE("Error: Could not process result.");
$data = $r["data"];

Thanks,

Zara Gonzalez




Archive powered by MHonArc 2.6.24.

Top of Page