PHP not displaying data

Question

Any ideas why this simple php code won't display results when trying to echo the data.

<?php
        {
            mysql_connect("localhost" , "" , "") or die (mysql_error());
            mysql_select_db("") or die(mysql_error());


            $pid=intval($_SESSION["User_id"]); 
            $query = "SELECT `car`, `details`, `price` FROM `Car``";

            //executes query on the database
            $result = mysql_query ($query) or die ("didn't query");

            //this selects the results as rows
            $num = mysql_num_rows ($result);    


            while($row=mysql_fetch_assoc($result))
            {

                $_SESSION['car'] = $row['car'];
                $_SESSION['details'] = $row['details'];
                $_SESSION['price'] = $row['price'];
            }
        }
        ?>  

        <?php echo $_SESSION['car']; ?>
        <?php echo $_SESSION['details']; ?>
        <?php echo $_SESSION['price']; ?>

Just testing at the moment to see if the car, price and details display from the database and they don't seem to.

You shouldn't be using mysql_ functions because they are deprecated. Use pdo instead. — Lemon Drop
– Lemon Drop, Commented Apr 9, 2013 at 2:05
Are the quotes inside the query going the correct direction? Looks like they are copy/paste characters that are not quotes — Jay Rizzi
– Jay Rizzi, Commented Apr 9, 2013 at 2:07
Oh, there may be some issue with $_SESSION not showing immediately the values, some reason i recall having proba with that a while ago...is the only problem that the session doesnt store the values, or that the query just wont return, like if you changed the rows to just echo rather than session storage, are you getting results? — Jay Rizzi
– Jay Rizzi, Commented Apr 9, 2013 at 2:14
@JayRizzi, the query won't return. It just displays login. I have used $_SESSION on other application, can't figure out why it won't work on here — user2236990
– user2236990, Commented Apr 9, 2013 at 2:16

Yogesh Suthar · Accepted Answer · 2013-04-09 02:06:40Z

2

You missed session_start(); at start of page and change

$query = "SELECT `car`, `details`, `price` FROM `Car``";
                                                     ^

to

$query = "SELECT `car`, `details`, `price` FROM `Car`";

answered Apr 9, 2013 at 2:06

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

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

5 Comments

user2236990 Over a year ago

Tried that. It just displays login

user2236990 Over a year ago

And i have got session start at the top

Yogesh Suthar Over a year ago

@user2236990 Can you describe It just displays login?

user2236990 Over a year ago

Yeah, basically when i visit that specific php page (car.php) it simply displays login in the middle of the page instead of car details

Yogesh Suthar Over a year ago

@user2236990 Show your full code. Whatever you have posted it's impossible to know where is problem. In your posted code we have solved your errors.

zeflex · Accepted Answer · 2013-04-09 02:26:25Z

0

Are you expecting one or many results for this query ?
If many results, you are saving the last entry in the session.
If only one, just do : $row=mysql_fetch_assoc($result) instead of this while.

answered Apr 9, 2013 at 2:26

zeflex

1,5372 gold badges14 silver badges30 bronze badges

Comments

UserProg · Accepted Answer · 2013-04-09 03:28:23Z

0

Check the query.Try to echo it, copy, paste in MySQL and run it. But you have $pid, have you put it in the query?

$query = "SELECT car, details, price FROM Car WHERE id = $pid ";

answered Apr 9, 2013 at 3:28

UserProg

6391 gold badge9 silver badges23 bronze badges

Comments

Skinny Pipes · Accepted Answer · 2013-04-09 02:07:57Z

-1

I rather remove all backticks since non of those identifiers are reserved keywords.

$query = "SELECT car, details, price FROM Car";

answered Apr 9, 2013 at 2:07

Skinny Pipes

1,0356 silver badges14 bronze badges

Collectives™ on Stack Overflow

PHP not displaying data

4 Answers 4

5 Comments

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

Comments

Comments

Comments

Related