Any PHP Gurus (MSSQL Specific Query)

[Brettles1986]

Anyone on here good with PHP?

I'm trying to return the results of a query from an array but it's not playing ball and giving me now results all the time. When run in MSSQL Query analyser the results are displayed so its not the query

[0x90]

Originally Posted by Brettles1986

Anyone on here good with PHP?

I'm trying to return the results of a query from an array but it's not playing ball and giving me now results all the time. When run in MSSQL Query analyser the results are displayed so its not the query

Show us the bit of code that you're having trouble with.

[Brettles1986]

<?php

//connect to a DSN
$conn = odbc_connect('CS_CRM','','');

$Firstname = 'Brett';
$Surname = 'England';

$sql = "SELECT Person_No, Active, Firstname, Surname, nvarusergroup FROM People WHERE Firstname = $Firstname and Surname = $Surname and Organisation_no is not null";

$result=odbc_exec($conn, $sql);

echo "<table id=\"results\">
<tr><th>Person_No</th><th>Active</th><th>Firstname</th><th>Surname</th><th>Usergroup</th>";

while ($row = mssql_fetch_array($result))
{
echo "<tr>";
echo "<td><b>" . $row['Person_No'] . "</b></td>";
echo "<td>" . $row['Active'] . "</td>";
echo "<td>" . $row['Firstname'] . "</td>";
echo "<td>" . $row['Surname'] . "</td>";
echo "<td>" . $row['Usergroup'] . "</td>";
echo "<td><a href=\"edit.php?Person_nO=$row[Person_No]\">Edit</a></td>";
echo "<td><a href=\"delete.php?Person_No=$row[Person_No]\">Delete</a></td>";
}
echo "</tr></table>";



odbc_free_result ($result);
?>

[Brettles1986]

Fairly sure I know the issue, the function mssql_fetch_array needs to be replaced with odbc_fetch_array but the version of PHP im using does not have it as a defined function so I need to define the function manually.

[0x90]

Originally Posted by Brettles1986

Fairly sure I know the issue, the function mssql_fetch_array needs to be replaced with odbc_fetch_array but the version of PHP im using does not have it as a defined function so I need to define the function manually.

Not entirely sure on that one; try using just mssql functions instead of odbc if odbc_fetch_array isn't available in your version of PHP.

[Brettles1986]

Originally Posted by 0x90

Not entirely sure on that one; try using just mssql functions instead of odbc if odbc_fetch_array isn't available in your version of PHP.

I've already coded one page to use ODBC and it makes sense to do it that way rather than storing user details in the actual contents of the PHP pages.

I'll try and find an answer to this and if no avail then will change over to mssql methods.

[0x90]

Originally Posted by Brettles1986

I've already coded one page to use ODBC and it makes sense to do it that way rather than storing user details in the actual contents of the PHP pages.

I'll try and find an answer to this and if no avail then will change over to mssql methods.

Alright then, fair enough.
Did you try what you suggested in the first place about adding your own odbc_fetch_array? There's a function that someone has already written on the PHP manual page for it.