kahodges Posted March 10, 2009 Share Posted March 10, 2009 I have a problem when entering data into a field with a space in the middle, it only returns the first portion of the data. Example: I enter: any street The query returns: any I need it to return: any street Here is the code I'm using: <td colspan="2"><input name="street" type="text" id="street" <? if (!empty($street)) echo "value=$street" ?>> What else would I need to add to allow the entire data string to post to the database and be returned on the query? The mysql database field is set as varchar, (255), latin_1_swedish_ci, null set to yes, default set to null, with no extras. Thanks for your help in advance. Link to comment https://forums.phpfreaks.com/topic/148772-inserting-data-with-spaces/ Share on other sites More sharing options...
premiso Posted March 10, 2009 Share Posted March 10, 2009 You need to surround $street in quotes. <td colspan="2"><input name="street" type="text" id="street" <?php if (!empty($street)) echo "value=\"$street\""; ?>> Should fix your issue. Link to comment https://forums.phpfreaks.com/topic/148772-inserting-data-with-spaces/#findComment-781180 Share on other sites More sharing options...
kahodges Posted March 10, 2009 Author Share Posted March 10, 2009 That worked! Woohoo! Thank you! Link to comment https://forums.phpfreaks.com/topic/148772-inserting-data-with-spaces/#findComment-781185 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.