Problems fetching mysql data with PHP

Question

I am trying to fetch some data from my sql table, I've already done it but now it wont work with the same code. Here it is:

$cat = "";
$res = "";
$date = "";

$sql2 = "SELECT category, result, date FROM results WHERE user='" . $_SESSION['login_user'] . "'";
$result2 = mysql_query($sql);

$count2 = mysql_num_rows($result2);

if($count2 == 1)
{
    $row2 = mysql_fetch_assoc($result2);

    $cat = $row2["category"];
    $res = $row2["result"];
    $date = $row2["date"];


}

I keep getting the following error:

Notice: Undefined index: category in C:\xampp\htdocs\Own\RiskCarePHP\profile.php on line 59

Notice: Undefined index: result in C:\xampp\htdocs\Own\RiskCarePHP\profile.php on line 60

Notice: Undefined index: date in C:\xampp\htdocs\Own\RiskCarePHP\profile.php on line 61

Whats wrong with it?

Use mysqli or PDO and start your session by session_start(); — Yash Mehta, Oct 14 '16 at 03:10
Is this `$result2 = mysql_query($sql);` correct? Maybe it should be $sql2? — Nurjan, Oct 14 '16 at 03:11
It'll be also a great help to peoples if you provide your ```profile.php``` file source code. — Suresh, Oct 14 '16 at 03:17

score 0 · Answer 1 · answered Oct 14 '16 at 03:14

0

There is an error in your syntax.

It should be

$result2 = mysql_query($sql2);

Please check with this

answered Oct 14 '16 at 03:14

Amrinder

69
6

1

I asked the same question in the comment. – Nurjan Oct 14 '16 at 04:06
Yeah just checked.. Didnt know about that time... probably we answered at same time – Amrinder Oct 14 '16 at 04:09

score 0 · Answer 2 · answered Oct 14 '16 at 03:21

You are missing out the fact that when you do mysql_fetch_assoc(), it returns the array with index hence the result from mysql_query() has to be looped with while(). You are trying to directly access the associative array which is indexed and you are missing the index values to point to the keys like "category", "result" and "date".

<?php 
$cat = "";
$res = "";
$date = "";

$sql2 = "SELECT category, result, date FROM results WHERE user='" . $_SESSION['login_user'] . "'";
$result2 = mysql_query($sql);

$count2 = mysql_num_rows($result2);

if($count2 == 1)
{
    while ($row2 = mysql_fetch_assoc($result2)) {
       $cat = $row2["category"];
       $res = $row2["result"];
       $date = $row2["date"];
    }
}
?>

This will definitely work for you. Cheers!

Problems fetching mysql data with PHP

2 Answers2