Textbox with a database field

raviram80

hii

I have to set the default value of the textbox to a value using a database field in a PHP script. It is probably not refernecing the value correctly and not showing the integer vaue. The following is the code can anyone point out the error

<html>

<body>

<?php

$db=odbc_connect("TestDB"," "," ") or die ("Could not connect");

$stmt = odbc_prepare($db,"select query1.MRN, query1.no from query1 where query1.no=12");

$exe_id = odbc_execute($stmt);

$no = odbc_result($stmt,2);

#echo "$no";

echo '<input type="text" value= $no name="thebox" align="top" maxlength="25" size="40"><br>';

odbc_close($db);

</body>

</html>

Thanks so much

Ravi

bad76

Hi,

i think the problem is

"$no = odbc_result($stmt,2); "

the $stmt is wrong variable.

Use instead "$exe_id"...

see you

raviram80

hii this is not the problem

so plss someone tell me the solution to this

thanks

bad76

🙁 Rigth,

the only problem is the echo string.
I've tried with this:

echo '<input type="text" value="'.$no.'" name="thebox" align="top" maxlength="25" size="40"><br>';

and all work fine...

see you.

raviram80

Hii,

This has worked for me and thanks a lot for your help

bye

ravi