hessie
-
Posts
4 -
Joined
-
Last visited
Never
Posts posted by hessie
-
-
just try it with \'\':
update item set number2=\'$string2\' where
...
Thanks.... But i tried it with \'\".$string2.\"\' and \'$string2\' etc....
Unfort. no dice.
Field is a VARCHAR of 16 of length.
Any other ideas?
THANKS!
I found it....
when i use this CHAR(\'$string2\') for every field, it works.
I still have an issue, that my data is not being updated....
When I find a solution, i also post it here.... When someone has a solution, i hope you can reply this mesage.
Thanks in advance....
-
just try it with \'\':
update item set number2=\'$string2\' where
...
Thanks.... But i tried it with \'\".$string2.\"\' and \'$string2\' etc....
Unfort. no dice.
Field is a VARCHAR of 16 of length.
Any other ideas?
THANKS!
-
Hi all,
when I read a table, edit a value and want to write that back to the table in another field, there goes something wrong when the selected field contains \"123456789AB\". However \"123456\" goes alright.
$data_res = db_query("SELECT number, number2 FROM item") or db_die(); while ($data_row = db_fetch_row($data_res)) { $string2 = $data_row[0]; $string2 = str_replace(".", "", $string2); $result=db_query("update item set number2=$string2 where number=$data_row[0]") or db_die(); if ($result) {echo "Article $data_row[0] with new $string2 is updated";} else {echo "-- > Article $data_row[0] with new $string2 is not updated";} echo "<BR>"; }
I fetch the value \"1234.5678AA\", this result in $string2 as \"12345678AA\" but MySql gives an error \"There is something wring in the used syntax at \'AA\' in row 1\". :?
When I fetch a value of \"1234.5678\", $string2 will result with \"12345678\" and the update goes fine.
The details of \'number2\' field is text.
Please HELP!!!!
thanks,
Henk.
Update problem with numbers and text
in MySQL Help
Posted
Weird.... Now your solution works... finally. THANKS!
I found out, that CHAR() and ASCII() returns the sum of char values.... logical...I had to remember that when i developed in C years ago...
It works!!!! Thanks for the help!