ankit.pandeyc012 Posted April 11, 2011 Share Posted April 11, 2011 <html> <title>Micro Elite Brigade - Participated Events</title><LINK REL="SHORTCUT ICON" HREF="images/favicon.png"><?php require_once('upper.php'); if($_COOKIE['LoginIdCookie']){ require_once('database.php'); require_once('LoginStatement.php'); $LoginId=$_COOKIE['LoginIdCookie']; $query="select * from participation where LoginId='$LoginId'"; $result=mysqli_query($dbc,$query) or die ('Not Connected'); //echo "<div class='search_output_data'> echo "<table border='0' cellspacing='0' cellpadding='0'>"; echo "<tr><th align='left' valign='top' width='100' height='20'>Event Title</th> <th align='right' valign='top' width='250' height='30'>Date of Participation</th> </tr>"; while($row=mysqli_fetch_array($result)) { echo " <tr><td colspan='4' align='left' valign='top' ><table align='left' border='0' cellspacing='0' cellpadding='0'><tr><td align='left' valign='top' width='200' height='20'>".$row['Title']."</td> <td width='50'> </td> <td align='left' valign='top' width='130'>".$row['Date']."</td> </tr></table> </td></tr>"; } echo "</table>";} else{ echo 'Sorry, You must have to login.';} require_once('lower.php'); ?> HI friends..... I have a table named events in which I have a "Title" column. When I print the value of Title column, it not displayed not more than 40 characters.... Where is the problem ??? Anyone?????? Quote Link to comment https://forums.phpfreaks.com/topic/233341-how-to-fetch-all-data-from-database-of-a-column/ Share on other sites More sharing options...
spiderwell Posted April 11, 2011 Share Posted April 11, 2011 have you checked that the column in the database isnt limited to 40 characters? try echoing out the title without any formating? Quote Link to comment https://forums.phpfreaks.com/topic/233341-how-to-fetch-all-data-from-database-of-a-column/#findComment-1199949 Share on other sites More sharing options...
raindropz12 Posted April 11, 2011 Share Posted April 11, 2011 can you post the db structure? Quote Link to comment https://forums.phpfreaks.com/topic/233341-how-to-fetch-all-data-from-database-of-a-column/#findComment-1199952 Share on other sites More sharing options...
ankit.pandeyc012 Posted April 13, 2011 Author Share Posted April 13, 2011 I take title column as LongText and length is not defined. So, I think there is no problem with it...... Quote Link to comment https://forums.phpfreaks.com/topic/233341-how-to-fetch-all-data-from-database-of-a-column/#findComment-1200971 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.