fallenangel1983 Posted April 2, 2008 Share Posted April 2, 2008 if i want to amend a row in a table by inserting a letter can it be done? e.g. $sql="UPDATE table SET letter ='Y' WHERE ID= '1'"; ^ do i need special syntax here ^ Quote Link to comment https://forums.phpfreaks.com/topic/99105-query-using-varchar/ Share on other sites More sharing options...
fenway Posted April 2, 2008 Share Posted April 2, 2008 Amend how? Quote Link to comment https://forums.phpfreaks.com/topic/99105-query-using-varchar/#findComment-507094 Share on other sites More sharing options...
fallenangel1983 Posted April 2, 2008 Author Share Posted April 2, 2008 the row is urrently set to the letter N. i want to amend or update the row so it now states the letter Y. but i think my syntax is wrong Quote Link to comment https://forums.phpfreaks.com/topic/99105-query-using-varchar/#findComment-507105 Share on other sites More sharing options...
aschk Posted April 2, 2008 Share Posted April 2, 2008 Nope that looks fine, assuming that your column can accept the character 'Y' of course, and the column is called "letter" Quote Link to comment https://forums.phpfreaks.com/topic/99105-query-using-varchar/#findComment-507424 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.