[RESOLVED] odbc connect

[Newladder]

Hi,

I have Just tried one simple code mentioned below but no result

<?
$conn = odbc_connect('server','user','password'); 
$userid = $_POST['userid'];
$password = $_POST['password'];
$select = "SELECT * FROM plus_signup WHERE userid='$userid' AND password = '$password'";
echo "Select : $select";
$result = odbc_exec($conn, $select);
while ($row = odbc_fetch_array($result))
{
    $rowid = $row['userid']; 
    $pwd = $row['password'];
}
echo "Row id :".$rowid;
echo "password : ".$pwd;
?>

i get this result
Select : SELECT * FROM plus_signup WHERE userid='name' AND password = 'pointer'
Row id :
password :

[bradgrafelman]

1. Have you set display_errors to On and error_reporting to E_ALL ?

2. Does the _coonect() call even succed? Whichever call fails first, what is the ODBC-related error message? (HINT: [man]odbc_errormsg/man just might help in this situation!)

[Newladder]

Hi bradgrafelman,

There are no errors when using odbc errormsg().
when i jsut tried with only one condition in where statement it works.
i.e.

<?
$conn = odbc_connect('server-1','user','password'); 
$userid = $_POST['userid'];
$password = $_POST['password'];
//echo $userid;
//echo $password;
$select = "SELECT * FROM plus_signup where userid = '$userid' "; 
echo "Select : $select"; 
$result = odbc_exec($conn, $select); 
while ($row = odbc_fetch_array($result)) 
{ 
    //write out all the rows from the table
    echo "<br>".$row['userid'];
    echo "<br>".$row['password'] . '<br/>'; 
} 
?>

Below is my output.

Select : SELECT * FROM plus_signup where userid = 'tester' 
tester 
testing 

[Newladder]

Hi Friends,

Finally I could able to get connected and retrive records.. Its working now.
Thanks for the precious help.

Warm Regards

[bradgrafelman]

Don't forget to mark this thread resolved.

Also... in case someone else is having this same problem, you might consider explaining what finally made it work.