• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

Printing PHP value on page

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
TLN_CANADA
Asked:
TLN_CANADA
  • 3
  • 2
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
$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
 
TLN_CANADAAuthor Commented:
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
 
Dave BaldwinFixer of ProblemsCommented:
You need a semi-colon ';' at the end of the second line.  Like...
$row = mysql_fetch_array($query);

Open in new window

0
 
TLN_CANADAAuthor Commented:
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
 
Dave BaldwinFixer of ProblemsCommented:
$row is an array in this case.  Your last line needs to be:
echo $row['question'];

Open in new window

0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now