pulling data from mysql database

Cuban

hi,
ive got a login script that searches a database for the username and passwod. if this works then the user is redircted to another page. i would like this page to contain a piece of information from the information from the database without the user having to enter in but am having trouble getting this to work.
This is my current script:

<?php
	if((!$username) or (!password))
	{header("Location:$HTTP_REFERER"); exit();}

$conn=@mysql_connect("localhost","login","password")
			or die("Error:Connect");

$rs=@mysql_select_db("database",$conn)
			or die("Error:Database Selection");

$sql="select * from auth where username=(\"$username\") and 

password=(\"$password\")";


$rs=mysql_query($sql,$conn)
			or die("Error:Query");

$num=mysql_numrows($rs);

if($num !=0)
{$msg="Welcome $username";}
else
	{header("Location:$HTTP_REFERER"); exit();}
?>
<html>
<body bgcolor="#c8d4E3" text="#778899" alink="#778899" vlink="#778899" link="#778899">
<h2><?php echo($msg); ?></h2>

notionlogic

if this works then the user is redircted to another page

I can't see where this redirects on a successful login 😕

From my reading of this it simply displays the Welcome message

Cuban

sorry, the open new window script is in the login page

notionlogic

Assuming the problem is that you can't display things like "username" on that new page...

The query you're running on the page quoted does not actually return any data, just the number of rows found so you won't be able to use any DB information

Cuban

yeah, but thats the only way i know how to do it. so how do i make a query that pulls data from the database

rIkLuNd

see [man]mysql_fetch_array[/man] and [man]mysql_fetch_assoc[/man]

Cuban

thank you, that helps alot 🙂