Gary B 0 Posted November 8, 2019 Report Share Posted November 8, 2019 I have the following columns in a MySQL database table: StoryHeadline [varchar] StoryByline [varchar] StoryText [text] In the database, the text appears correctly. In a previous page, when I use row["StoryHeadline"] the output appears correctly. However, on my new page, where I'm using the ID from the previous page to pull just one specific row's data, I get the letter 'r' for output of all three of these fields. Here's the code: Setting the variables: $Headline = row["StoryHeadline"]; $ByLine = row["StoryByline"]; $StoryText = row["StoryText"]; Assembling the overall output: $StoryRecap = $Headline . '<br />by' . $ByLine . ' ' . $TimeLine . '<br /><br />' . $StoryText; Then when printing to the page: <?php echo $StoryRecap; ?> What I actually end up seeing: Quote rby r Tue Jul 02, 1:01 amr How do I get my correct data to display? Thanks! Quote Link to post Share on other sites
niche 139 Posted November 8, 2019 Report Share Posted November 8, 2019 What's actually in your results array when you dump it? Quote Link to post Share on other sites
Gary B 0 Posted November 8, 2019 Author Report Share Posted November 8, 2019 @niche when I try to just echo row["StoryHeadline"], I also get an 'r' but when I run the query directly on the database, the text appears correctly. Quote Link to post Share on other sites
niche 139 Posted November 8, 2019 Report Share Posted November 8, 2019 Looks to me like 'r' is being returned by your query. Please post your query. Quote Link to post Share on other sites
Ingolme 1,022 Posted November 10, 2019 Report Share Posted November 10, 2019 $row is clearly a string that begins with "r". You will have to show the code that is assigning a value to $row. Quote Link to post Share on other sites
niche 139 Posted November 10, 2019 Report Share Posted November 10, 2019 Check $row["StoryHeadline"] instead of row["StoryHeadline"] Quote Link to post Share on other sites
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.