Solved

Printing PHP value on page

Posted on 2013-01-25
5
218 Views
Last Modified: 2013-01-25
Hi all,

This is simple question but I think using the PHPfox it might be causing some issues.

I am using this SQL statement to get a value (it will be either no value or 1 value) from the DB:

	$query = mysql_query("SELECT question FROM cometchat_question WHERE userid = '$username' ");

Open in new window


I want to print this on a form on the page. How do I do this?

Thanks,

D
0
Comment
Question by:TLN_CANADA
  • 3
  • 2
5 Comments
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 38821011
$query in that statement will only be a resource identifier, not the data you are looking for.  You still need to use mysql_fetch_array() or one of the other methods to get the actual data, even if it is only one item.  http://us2.php.net/manual/en/function.mysql-fetch-array.php
0
 

Author Comment

by:TLN_CANADA
ID: 38821026
Here is what I have but it's giving an error:

$query = mysql_query("SELECT question FROM cometchat_question WHERE userid = '$username' ");
	$row = mysql_fetch_array($query)
	echo $row ;

Open in new window


Parse error: syntax error, unexpected T_ECHO in /home/clear555/public_html/dyadmenu.php on line 48
0
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 38821050
You need a semi-colon ';' at the end of the second line.  Like...
$row = mysql_fetch_array($query);

Open in new window

0
 

Author Comment

by:TLN_CANADA
ID: 38821075
Thanks, it's strange when I run the sql statement in the db it returns the result correct but when I print the array like this on the page it comes up blank. The username prints correct so it is connecting to the DB.

It would be a varchar format the question field that I am trying to fetch.

In this case the correct result from the db would be "Hello World"

$username = Phpfox::getUserBy('user_id'); 
	echo $username ;
	
	// Check for question
	$query = mysql_query("SELECT question FROM cometchat_question WHERE userid = '$username' ");
	$row = mysql_fetch_array($query) ;
	echo $row ;

Open in new window

0
 
LVL 82

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 38821173
$row is an array in this case.  Your last line needs to be:
echo $row['question'];

Open in new window

0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Generating table dynamically is the most common issue faced by php developers.... So it seems there is a need of an article that explains the basic concept of generating tables dynamically. It just requires a basic knowledge of html and little maths…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now