Blank output problem

[master82]

What is wrong with this code?

[code]<?php
include("database.php");
$userstable = mysql_query("SELECT * FROM users WHERE userid = '1'");
if (!$userstable) {
  echo 'Could not run users query: ' . mysql_error();
  exit;
}
$user = mysql_fetch_row($userstable);

//testing
echo $user[userid];
echo $user[username];
?> [/code]

When I run it I donr get any errors, just a blank page ???

[zawadi]

try this:

[quote]<?php
include("database.php");
$userstable = mysql_query("SELECT * FROM users WHERE userid = '1'");
if (!$userstable) {
  echo 'Could not run users query: ' . mysql_error();
  exit;
}
$user = mysql_fetch_row($userstable);

//testing
echo $user[0];
echo $user[1];
?> [/quote]

you may need to edit the numbers to match the colum number.
Also RTFM [url=http://uk.php.net/manual/en/function.mysql-fetch-row.php]http://uk.php.net/manual/en/function.mysql-fetch-row.php[/url]

[master82]

That works great!

But is there a way I can assign the values using their fieldnames rather than a number?

eg

$user[username] (would show the username)

rather than

$user[1]

is it possible?

[Unknown User]

Err, i'm sure i do that.

Add [quote]seesion_start();[/quote] at the top.

Then, if you want their username for example.

[quote]$_SESSION['username'][/quote]

[zawadi]

[quote]Description
array mysql_fetch_row ( resource result )

Returns a numerical array that corresponds to the fetched row and moves the internal data pointer ahead.
[/quote]

to use mysql_fetch_object

then use $user->username;