[RESOLVED] PHP/Mysql - Little problem

[thatshanekid]

Well i hope im not being an idiot again.
But i briefly scanned over the code and i couldn't find any missing ; or ' so 🙂

Well what im trying to do is display a row.
Well, what im exactly trying to do is display a row from a user.

<?php
session_start();

require('connect.php');
$us = $_SESSION['user'];
$sql = "SELECT * from userfiles WHERE username='$us'";
$result = mysql_query($sql)

echo $result['username'];
?>

Now this has something wrong with the echo?
error:

Parse error: syntax error, unexpected T_ECHO in /hosted/subs/ulmb.com/t/w/****/public_html/yourfiles.php on line 9

I don't see anything wrong with the echo? Any help?

[steamPunk]

Hi

it doesn't say there's something wrong with the ECHO, just that it's unexpected

The problem is the line

$result = mysql_query($sql)

it needs a ;

[thatshanekid]

steamPunk;10931566 wrote:

Hi

it doesn't say there's something wrong with the ECHO, just that it's unexpected

The problem is the line

$result = mysql_query($sql)

it needs a ;

Odd, on my other thingo which does the same thing with a print, you don't need to put a ; there.
Hmm, anyway this time it just doesn't display anything.
Just a blank page, any help?

[steamPunk]

you need to get the array of values from the result :

$sql = "SELECT * from userfiles WHERE username='$us'";
$result = mysql_query($sql);
while($row=mysql_fetch_array($result )){
   echo $row['username'];
} 

that should work

[thatshanekid]

Thanks heeps mate!