Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Printing PHP value on page

Posted on 2013-01-25
5
228 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 83

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 83

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 83

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

809 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