PHP Access Database Auto Number Issue

Hello All-

I need help on a Select statement. I have this...

When I run the page I get this...

What am I doing wrong? I have printed the Select statement and it does get a value like so...

Do I have to wrap a convert function around the requested id? I'm not really a PHP person, I concentrate mainly on ASP so I'm a little confused. Do I have the syntax correct? Any help would be great.

Also, as far as the Access Database goes the "id" field is set as "Autonumber" to increment and is the primary key of the table.

re: PHP Access Database Auto Number Issue

Hi,

Try the following code:

[php]
<?php

$conn=odbc_connect('databasename','','');
if (!$conn)
{exit("Connection Failed: " . $conn);}

$lnID = $_REQUEST['id'] ;
$sql="SELECT * FROM tablename where id = $lnID";

echo "$sql";
$rs=odbc_exec($conn,$sql);
?>
[/php]
That works for me in MySQL and I beleive it should work in Access also.

Cheers
nathj

re: PHP Access Database Auto Number Issue

Works Great, thanks! But why do I have to create a variable? Why can't I put the "$_Request("whatever")" right in the select.

Thanks

re: PHP Access Database Auto Number Issue

Did you try the SQL statement without the single quotes?

re: PHP Access Database Auto Number Issue

Hi,

First of all I'm gald that it worked for you.

Second the reason I suggested the variable was two fold; first I like to have a copy of the information so that if it changes I still have the original for comparison. This may not be relevant in your case but for me I've found it useful. Second, and proibably more significant is that I have never tried it the way you suggest so it might work just fine.

Third, I notice you use $_REQUEST[]. At the risk of sticking my nose in where it's not wanted I would recommend not using this array. The data in there comes from $_POST or $_GET. So I think it always better to be explicit in the code as it make it easier to debug later. You will always know where the information came from just be reading that line.

Anyway, all the best with the rest of your project.

Cheers
nathj