Major Parse Error = Reward To Whoever Fixes It...

[Rakim]

Hey everyone i have made a login script using php which is working fine,

but now i have got this

<?php
//INCLUDE THE CONFIGURATION SCRIPT
include("config.php");
$username = $_SESSION['username'];
//CONNECT TO DATABASE
$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database");
//SET QUERY
$query = "SELECT * FROM core_users WHERE username=$username";
#or: $query = "SELECT * FROM cats WHERE info LIKE '%$abrv%'";
#this depends on your database structure

//EXECUTE QUERY
$result = mysql_query($query);

//SHOW QUERY RESULTS
while($r=mysql_fetch_array($result))
{
$id=$r["id"];
$username=$r["username"];
$password=$r["password"];
$first_name=$r["first_name"];
$last_name=$r["last_name"];
$email=$r["email"];
$domain=$r["domain"];
$package=$r["package"];

echo "<font face='Verdana' size='1'><b>Package Information:<br>
        </b>Package: $package<br>
        Domain: $domain</font><p><font face='Verdana' size='1'><b>Personal
        Information:<br>
        </b>First Name: $first_name<br>
        Last Name: $last_name<br>
        Email: $email</font></p>
        <p><font face='Verdana' size='1'><b>Account Information:<br>
        </b>Username: $username<br>
        Password: &lt;&lt;hidden&gt;&gt;</font><p><font face='Verdana' size='1'>
        <b>Notices:<br>
        </b>If any of the information above is incorrect please email our
        support team at <a href='mailto:[e-mail]'>
        [email][e-mail][/email]</a> immediately so that we can change the account
        information to prevent you being re-billed or possibly suspended.</font>";
}

//CLOSE DATABASE CONNECTION
mysql_close($db);

?>

i am trying to display a users information via a php script from the database (but it must only work for the username that is currently logged in hence the (WHERE username=$username) so that hopefully it would work.

You can view what i have done so far http://www.nominet.biz/client_info.php it doesnt seem to be working at all yet, if you know how todo this can you please post a working code (not just tell me what todo because i am kinda dumb at seek'n'repair.

Thanks anyone who does it is entitled to a free hosting package @ www.eHostBox.com

[peppeto]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/nominet/domains/nominet.biz/public_html/client_info.php on line 17

It seems you got problems with your tables try to echo the query or mysql_err() and see what you have I can help you further if you tell more about your project

[devinemke]

<?php 
include('config.php');
$username = $_SESSION['username'];
$db = mysql_connect($db_host, $db_user, $db_pass) or die ('Cannot connect to database');
$select = mysql_select_db($db_name) or die ('Cannot select database');
$query = "SELECT * FROM core_users WHERE username = '$username'";
$result = mysql_query($query);

while ($r = mysql_fetch_array($result))
{ 
	$id = $r['id']; 
	$username = $r['username'];
	$password = $r['password'];
	$first_name = $r['first_name'];
	$last_name = $r['last_name'];
	$email = $r['email'];
	$domain = $r['domain'];
	$package = $r['package'];

echo '
<font face="Verdana" size="1">
<p>
<b>Package Information:</b><br>
Package: ' . $package . '<br>
Domain: ' . $domain . '
</p>
<p>
<b>Personal Information:</b><br>
First Name: ' . $first_name . '<br>
Last Name: ' . $last_name . '<br>
Email: ' . $email . '
</p>
<p>
<b>Account Information:</b><br>
Username: ' . $username . '<br>
Password: &lt;&lt;hidden&gt;&gt;
</p>
<p>
<b>Notices:</b><br>
If any of the information above is incorrect please email our support team at <a href="mailto:[e-mail]">[e-mail]</a> immediately so that we can change the account information to prevent you being re-billed or possibly suspended.
</p>
</font>
';
} 
mysql_close($db); 
?>