PHP/MySQL - Geting a row from a DB

Question

Can someone help me with my script? It's supposed to read the user's session's member_id, find the corresponding row and echo it out. But when it runs, it outputs nothing.

<?php

//Start session
session_start();

//Make sure user is logged in
require_once('auth.php');

//Include database connection details
require_once('config.php');

//Connect to DB
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
die("Unable to select database");
}

//Create Querys
$query = "SELECT * FROM stats WHERE member_id='" . $_SESSION['SESS_MEMBER_ID'] . "' "; 
$result = mysql_query($query);

//Gather the whole row into an array
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) 
{
    echo $row;     
} 

?>

Will A · Accepted Answer · 2010-08-27 23:04:04Z

3

Drop a echo mysql_num_rows($result); immediately after the mysql_query line, and see if you've any results returned from the query - I suspect you'll find you haven't, in which case the SESS_MEMBER_ID is not present in the stats table.

answered Aug 27, 2010 at 23:04

Will A

25k5 gold badges54 silver badges61 bronze badges

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

1 Comment

user377419 Over a year ago

Opps, I figured it out. Stupid mistake.

Crozin · Accepted Answer · 2010-08-27 23:13:06Z

1

Use PDO instead of mysql_*() functions
$row is an array so echoing it is pointless: PHP arrays, var_dump()
Make sure that SQL query returns anything. Maybe $_SESSION['SESS_MEMBER_ID'] has got some unexpected value?
Do the basic debugging whenever something goes wrong - dump everything:
```
var_dump($query); 
var_dump($result);
var_dump($_SESSION);
```
Or even better: use a real debugger.
Make sure that every possible error is displayed - PHP is a very strange language that accepts tones of errors and still can work:
```
error_reporting(-1);
ini_set('display_errors', 'on');
```

btw: What's the point of SESS_ prefix for session variables?

answered Aug 27, 2010 at 23:13

Crozin

44.5k13 gold badges92 silver badges136 bronze badges

Collectives™ on Stack Overflow

PHP/MySQL - Geting a row from a DB

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related