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 ^ 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? 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 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" Link to comment https://forums.phpfreaks.com/topic/99105-query-using-varchar/#findComment-507424 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.