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. Quote 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. Quote 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! Quote Link to comment https://forums.phpfreaks.com/topic/148772-inserting-data-with-spaces/#findComment-781185 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.