[RESOLVED] Retrieving data from MS SQL database

[97ldave]

Hi,

I am trying to get data from a MS SQL database, this is the code i have:

<?php
// Connect MSSQL


$conn = mssql_connect('LORRO\SQLEXPRESS', 'sa', 'newcastle');
$db = mssql_select_db('CP_Auto_Metering');

$query = mssql_query("SELECT *
                      FROM [CP_Auto_Metering].[dbo].[MeasurementData]");

$result = @mssql_query($query) or die(mssql_get_last_message());

if ($result){

echo '<table>
      <tr><td>ID</td><td>MeterID</td></tr>';

while ($row = mssql_fetch_array($result, MSSQL_ASSOC)){

echo '<tr><td>' . $row['MeterID'] . '</td><td>' . $row['BatteryVoltage'] . '</td></tr>';

}

echo '</table>';

mssql_free_result($result);

}
?>

I get the folowing error: Incorrect Syntax near '#3'.

I thnk it is to do with my query, but i cant figure out why it wont work, can anyone help me?

thanks in advance for any help.

[tomhath]

#3 is the internal id of the resource returned from your first call to mssql_query that you passed to mssql_query in the second call:

$query = mssql_query("SELECT *
                      FROM [CP_Auto_Metering].[dbo].[MeasurementData]");

$result = @mssql_query($query)...

I think you really meant something like this:

$query = "SELECT * FROM [CP_Auto_Metering].[dbo].[MeasurementData]";

$result = @mssql_query($query)...

[97ldave]

Thanks tomhath, thats sorted it, cant believe it was something so simple!!