I have a MySQL database that I often have to edit. I have created a script for editing but when I use it, I get only some of the information. For ex. i have a page that has <input type=text name=operating_system value=$operating_system>. the values that are usally in it are. Windows 98 or what ever operating system that they are using. but when i pull it up to edit it. The input box displays only Windows. It left off the 98. I dont know if it is because of the spaces or what. I have this problem in other catagory's that have spaces. Could it be that I use varchar. I dont know. If anyone knows please help.
How big is the column?
The columns are varchar(30)
you need double quotes around items with spaces or special chars in html tags.
<input type=text name="operating_system" value="$operating_system">
Put quotes around the value
Its important because this works:
value="Windows 98"
but if you specify just
value=Windows 98
Then it will read it as just "Windows"
Eric
Isn't this it?
echo" <input type=text name=operating_system value=/"$operating_system/">";
Or Print("<input type=text name=operating_system value='$operating_system'>");
