variable result from sql query not showing

Question

Is there anything wrong in this scenario? the result isn't showing. maybe i'm getting the syntax wrong?

    // fetch the latest tweet
$lastTweet = '';
$q2 = "SELECT tweet FROM timel ORDER BY id DESC LIMIT 1";
list($lastTweet) = $conn->get_results($q2);



if(!$lastTweet){  
$lastTweet = "You don't have any tweets yet!";
}
var_dump($lastTweet);

and this on the html body:

<span class="latest"><strong>Latest: </strong><span id="lastTweet"><?.=$lastTweet?></span></span>

In <?.=$lastTweet?>, you have a . between ? and =. Remove it. — gen_Eric
– gen_Eric, Commented Feb 20, 2013 at 21:14
Didn't you forget to execute your query before getting the result? — peterm
– peterm, Commented Feb 20, 2013 at 21:17
to all: removing the dot still doesn't work though. maybe there is a another way to do this? peterm: the results are fine since i am using a class for executing queries. it works, just that i can't display the results on the html body. assuming i have no tweets yet. — asleighna
– asleighna, Commented Feb 20, 2013 at 21:21

Tommy Adey · Accepted Answer · 2013-02-20 21:46:58Z

2

If you changed your first line to

$lastTweet = array();

And your third line to

$lastTweet = $conn->get_results($q2);

Then you would be able to use

<?php var_dump($lastTweet); ?>

But in your case lastTweet contains a string of text, hence you need to use echo to print it's content.

<?php echo $lastTweet ?>

Nb: i'm not sure about your project details but i'm guessing you'd need to also get the date, maybe id and user_id of the tweet, if that's the case, you might want to make lastTweet an empty array()

answered Feb 20, 2013 at 21:46

Tommy Adey

8166 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hackerman · Accepted Answer · 2013-02-20 21:17:51Z

1

Use this:

<span class="latest"><strong>Latest: </strong><span id="lastTweet">
<?php echo $lastTweet; ?></span>    </span>

Saludos ;)

answered Feb 20, 2013 at 21:17

Hackerman

12.3k2 gold badges37 silver badges47 bronze badges

1 Comment

asleighna Over a year ago

okidoki. this did the trick! hmmm. so i still do have to use $echo function. thanks a bunch, Robert Rozas. and thank you for the replies, everyone. :)

Collectives™ on Stack Overflow

variable result from sql query not showing

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related