0

Morning,afternoon,evening and av a great night to all,

solution needed plaese.

secnario.

players eneter log on screen and enter name ,password, (id is index on base)
then go to check_logon.php if happy end up at logon_success.php

this run ok :)

am now trying to display players id number on logon_success.php.

check_logon.php

$sql="SELECT * FROM $tbl_name WHERE name='$myusername' and password='$mypassword'";
$result=mysql_query($sql);



// Mysql_num_row is counting table row                                                   t.l
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}


ob_end_flush();
?></HEAD><BODY>

login_success.php

$sql="SELECT * FROM members ";
$result2=mysql_query($sql);
                                            

// store the record of the "example" table into $row
$row = mysql_fetch_assoc( $result2 );
// Print out the contents of the entry 

echo "Name: ".$row['name'];
echo " id: ".$row['id'];

mysql_close();

have been trying to get the header to read{ header("location:login_success.php. '$id'");}
also have been thinking along the lines

$sql="SELECT * FROM members $A";
where $A = 'id' or 'myusername'

any points would be greatley apreachetted :)
thanks.

2
Contributors
3
Replies
4
Views
6 Years
Discussion Span
Last Post by debasisdas
0

forget about PHP.

Post the SQL part of the code where you have any issue.

thanks for your time debasisdas , all sortted now .

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.