PHP / ODBC / MYSQL

[rbvcbr]

When I run this I can write "userid"
where you see Welcome,

But it is not working with my sql statement.
Need code help please. Can somebody fix this.

I tried GET and POST, no luck.

Thank you,

----------------------------------------

Welcome <?php echo $_REQUEST["userid"]; ?>.<br />

<?php
$conn = odbc_connect("dsnname", "username", "password");
if (!$conn)
{
exit("Connection Failed: " . $conn);
}
$sql="SELECT * FROM usersNew where userid =$_REQUEST[userid]";
$rs=odbc_exec($conn,$sql);
if (!$rs)
{
exit("Error in SQL");
}
?>

 

[rbvcbr]

Repeating request.
Any help on originally posted question.
Thank you,

 

[GrazBurya]

Try this for your sql statement:

$sql="SELECT * FROM usersNew where userid =" .$_REQUEST[userid];

 

[GrazBurya]

By the way, you're also missing quotes in your $_REQUEST statement...you have $_REQUEST[userid]...this should be $_REQUEST["userid"]...I copied yours and realized afterwards that it had no quotes...if you use my sql statement, you will also need to add quotes.