Help!!!!!

[ugg]

Hello i would be grateful if someone could help me, I have a php file with an
embedded html form which allows the user to add a record into a access database. The problem is that one of the fields is numeric but the html tag (<Input type="">) does not have an numeric tag. When i try to add the record there is a data type mismatch error.

How to I extract the numeric value from the text field into a new
variable which i can then pass into the sql insert/update query

Can anyone help?

[ugg]

$x= $_GET["x"]; // at the moment a string

$data = floatval($x); // then extracts the int

$rs=odbc_exec($conn, "UPDATE h Dat = '$data',
WHERE Dat = '$data' ");

This is the cut down code? any one help?

[maxpup979]

try this:

$rs=odbc_exec($conn, "UPDATE h set Dat = $data,
WHERE Dat = $data ");

[ugg]

Thanks for the help I have just read your post I figured it out yesterday after staring at the code for ages!

Do you know how to use rollback in php as i have being trying but it doesnt seem to do anything.

for example

$rs=odbc_exec($conn, "UPDATE h set Dat = $data,
WHERE Dat = $data ");

if($rs==false){

// I want to use rollback here
}

Thanks

ugg