What is wrong???

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
ericburnard
Forum Contributor
Posts: 104
Joined: Wed Jun 15, 2005 5:11 pm
Location: Chesterfield, UK

What is wrong???

Post by ericburnard »

what is wrong with this code i dnt no :s i get this error

Code: Select all

Parse error: parse error, unexpected $ in /home/madashat/public_html/eric/login.php on line 68

Code: Select all

<?php
session_start();
$dbun="madashat_eric";
$dbpw="*******"
$database2="madashat_users";
mysql_connect(localhost,$dbun,$dbpw);
@mysql_select_db($database2) or die( "Unable to select database");

$username = $_POST['username'];
$password = $_POST['password'];

$query = "SELECT * FROM users WHERE username = '$username' AND password = '$password'";

$result = mysql_query($query);

if (mysql_numrows($result) != 1) {
$error = "Bad Login";
include "header.inc";
include "login.html";

} else {

include('http://eric.madashatters.com/header.inc');

$query2="SELECT * FROM users WHERE username = '$username'";
$result2=mysql_query($query2);
$num=mysql_numrows($result2);

$username = mysql_result($result2,0,"username");
$name = mysql_result($result2,0,"name");
$age = mysql_result($result2,0,"age");
$website = mysql_result($result2,0,"website");
$password = mysql_result($result2,0,"password");
$email = mysql_result($result2,0,"email");
  
echo "<center><table align='center' cell padding=3>
<tr><td><div class='white'><center>
Welcome back $username. <BR>
You can upload your photos below, but remember that you can only upload<br> .jpg and .png.<BR><BR><a href='http://eric.madashatters.com/menu.php?page=photos&gallery=$username'>View Your Gallery Here</a><BR><BR>
</td></tr>
"; // etc

$dbun="madashat_eric";
$dbpw="******";
$database3="madashat_mail";
mysql_connect(localhost,$dbun,$dbpw);
@mysql_select_db($database3) or die( "Unable to select database");

$query2="SELECT * FROM pm WHERE user_name = '$username'";
$result2=mysql_query($query2);
$num=mysql_numrows($result2);

for($i=0;$i;$i++){ 
$user_name = mysql_result($result2,$i,"user_name");
$id = mysql_result($result2,$i,"id");
$subject = mysql_result($result2,$i,"subject");
$message = mysql_result($result2,$i,"message");
$sender = mysql_result($result2,$i,"sender");
$sent = mysql_result($result2,$i,"sent");
$new = mysql_result($result2,$i,"new");
$date = mysql_result($result2,$i,"date");
  
echo "<center><table align='center' cell padding=3>
<tr><td><div class='white'><center>
Welcome back $username. <BR></td></tr> $id<br>$user_name<br>$subject<br>$message<br>$sender<br>$new<br>$sent<br>$date</tr></td></table>"; 
}
?>
Thanks
Eric
imstupid
Forum Commoner
Posts: 84
Joined: Fri Feb 18, 2005 1:24 pm

Post by imstupid »

missing curly bracket
User avatar
ericburnard
Forum Contributor
Posts: 104
Joined: Wed Jun 15, 2005 5:11 pm
Location: Chesterfield, UK

Post by ericburnard »

Ahhhh i found a rouge { in the code :D but it still dosnt want to display all of the resuklts in the tables that have there username the same as user_name

thanks
eric#
Post Reply