I have php setup on the following platform:

Web Server: Win2k IIS
DB Server: MSSQL 2000

I'm having a problem when running a view that acesses a user defined
function.  The function outputs a converted date to varchar + a varchar
string.  The problem is that when I loop through the recordset I get strange
results.  The data currently has one field from the view with data and a

The code I use to retreive the values is this:

        $sql = "Select LastPost From vwSubTopicDetails";

        $result = mssql_query($sql);

        while ($rs = mssql_fetch_array($result)) {
                echo $rs["LastPost"] . "<br><br>";

The data that gets echo'd back is this:

12/05/2001 shane


Can anyone tell me why I'm getting the phantom date in the second row of the
recordset?  This seems to be PHP specific, as I've tried running the query
in query analyser and in an ASP page without incident.

Thanks in advance,

Shane Peery

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to