"Undefined Variable" when trying to echo an array fetched via mysql_fetch_array

Question

Below is my code:

session_start();
include_once "config.inc.php";
$tbl_name="members";

 $username=$_SESSION['username'];
$sql = "SELECT quiz1mark, quiz2mark, quiz3mark FROM $tbl_name WHERE username='$username'";
$query = mysql_query($sql);
$data = mysql_fetch_array($query, MYSQL_ASSOC);

Then, further down the page:

<p><?php echo $data; ?></p>

This generates a notice: Notice: Undefined variable: data in F:\xampp\htdocs\quiz_home.php on line 35

I've clearly defined the variable though, and am unsure as to what's causing this problem.

***Contents of config.inc.php***:

$host="localhost";
$username="root";
$password="";   //the default installation of xampp does not include a mysql password
$db_name="bda";
//connect to the database using the above information (variables)
mysql_connect("$host", "$username", "$password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select database");

$tbl_name isn't a user submitted value, is it? Or $username? — HappyTimeGopher
– HappyTimeGopher, Commented Aug 9, 2012 at 0:43
Chucked everything there; must of the other stuff between 1 and 36 is just commenting relating to stuff like to-do lists and dating. — snoble
– snoble, Commented Aug 9, 2012 at 0:47
Are you unset()'ing $data between the mysql_fetch_array and the echo? For example, looping over $data then resetting in mid-loop? — HappyTimeGopher
– HappyTimeGopher, Commented Aug 9, 2012 at 0:47

Maykonn · Accepted Answer · 2012-08-09 00:53:39Z

3

What is the result when you try?:

var_dump($data);

answered Aug 9, 2012 at 0:53

Maykonn

2,9687 gold badges35 silver badges53 bronze badges

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

5 Comments

snoble Over a year ago

Notice: Undefined variable: data in F:\xampp\htdocs\quiz_home.php on line 35 NULL - just throws a NULL onto the end of what I was already getting :/

Maykonn Over a year ago

Just a test, try var_dump($query); Maybe $query is false then some unexpected behavior may be occurring after that.

snoble Over a year ago

Notice: Undefined variable: query in F:\xampp\htdocs\quiz_home.php on line 36 NULL That doesn't work either :S

Maykonn Over a year ago

So, if there is something between the lines $data = mysql_fetch_array ($query, MYSQL_ASSOC) and <?php echo $ data;?> show us. Then try putting <?php echo $ data;?> after $data = mysql_fetch_array ($ query, MYSQL_ASSOC)

snoble Over a year ago

Ended up fixing it strangely, just by merging all the code before echo $data into one <?php ~~ ?> block.

Collectives™ on Stack Overflow

"Undefined Variable" when trying to echo an array fetched via mysql_fetch_array

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related