visualazza Posted April 20, 2010 Share Posted April 20, 2010 hi, i have some code but sometimes it only displays the first word of the returned value from my mysql db. <input type=text name=title value=".$row1['title']." size=50> i am connected to more than one table in the same db thanks Quote Link to comment https://forums.phpfreaks.com/topic/199189-full-value-of-mysql-not-showing/ Share on other sites More sharing options...
jcbones Posted April 20, 2010 Share Posted April 20, 2010 Are the tables column size sufficient to carry the data you are trying to retrieve? Or, is the title longer than 50 characters? Quote Link to comment https://forums.phpfreaks.com/topic/199189-full-value-of-mysql-not-showing/#findComment-1045446 Share on other sites More sharing options...
visualazza Posted April 21, 2010 Author Share Posted April 21, 2010 it full row is in the db but it just displays the first word Quote Link to comment https://forums.phpfreaks.com/topic/199189-full-value-of-mysql-not-showing/#findComment-1045845 Share on other sites More sharing options...
Ken2k7 Posted April 21, 2010 Share Posted April 21, 2010 Learn HTML before PHP please. <input type=text name=title value='".$row1['title']."' size=50> Quote Link to comment https://forums.phpfreaks.com/topic/199189-full-value-of-mysql-not-showing/#findComment-1045847 Share on other sites More sharing options...
visualazza Posted April 21, 2010 Author Share Posted April 21, 2010 sorry, what do you mean. I do know html. If its the lack of single quotes then it was 1am here when i typed that as an example. Quote Link to comment https://forums.phpfreaks.com/topic/199189-full-value-of-mysql-not-showing/#findComment-1045856 Share on other sites More sharing options...
seventheyejosh Posted April 21, 2010 Share Posted April 21, 2010 The value attribute must be enclosed in quotes, or it'll truncate at the first space... very basic html. Quote Link to comment https://forums.phpfreaks.com/topic/199189-full-value-of-mysql-not-showing/#findComment-1045858 Share on other sites More sharing options...
visualazza Posted April 21, 2010 Author Share Posted April 21, 2010 i have quotes in the actual code, but it still doesnt work. As i said before, it was 1am and i didnt copy and paste as its on a different machine Quote Link to comment https://forums.phpfreaks.com/topic/199189-full-value-of-mysql-not-showing/#findComment-1045860 Share on other sites More sharing options...
visualazza Posted April 21, 2010 Author Share Posted April 21, 2010 <input type='text' name='title' value='".$row1['title']."' size='50'><input type='hidden' name='oldtitle' value='".$row1['title']."'> is as the line of code appears Quote Link to comment https://forums.phpfreaks.com/topic/199189-full-value-of-mysql-not-showing/#findComment-1045862 Share on other sites More sharing options...
PFMaBiSmAd Posted April 21, 2010 Share Posted April 21, 2010 And what is the actual data that is in $row1['title'] that is not working (i.e. we need to see the code and data responsible for the symptom in order to be able to help you with what your code and data is doing) because it is likely that it contains some html special characters that is breaking the html. Quote Link to comment https://forums.phpfreaks.com/topic/199189-full-value-of-mysql-not-showing/#findComment-1045867 Share on other sites More sharing options...
visualazza Posted April 21, 2010 Author Share Posted April 21, 2010 its just plain text one of the titles is Piano Mess, but it only displays Piano Quote Link to comment https://forums.phpfreaks.com/topic/199189-full-value-of-mysql-not-showing/#findComment-1045869 Share on other sites More sharing options...
PFMaBiSmAd Posted April 21, 2010 Share Posted April 21, 2010 Have you done a 'view source' of the resulting html in your browser so that you know what it really contains? If it still is not working, then you likely have some other broken html before that point on the page. Quote Link to comment https://forums.phpfreaks.com/topic/199189-full-value-of-mysql-not-showing/#findComment-1045871 Share on other sites More sharing options...
Ken2k7 Posted April 21, 2010 Share Posted April 21, 2010 i have quotes in the actual code, but it still doesnt work. As i said before, it was 1am and i didnt copy and paste as its on a different machine You sure you have the quotes? Can you do a View Source and check? It's not an excuse to say you posted something at 1 AM. It's really not our problem and we're just trying to help. So if you don't think you can present decent information for us to help you with your issue, then it's best to get some sleep and post when you're more attentive. Quote Link to comment https://forums.phpfreaks.com/topic/199189-full-value-of-mysql-not-showing/#findComment-1045895 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.