urgent help!!

susi

im newbie a this so bear with me..

im creating a football site which when a person registers.. they pick user/pass and get 2 pick 11 players.. this goes to my database.

when i log in using user/pass it goes to the members area.

i want it to display the 11 players on that page for that member!
im using sessions

i have the following query in my members page

$qstr = "SELECT player1 from members2 where username = [$SESSION_UNAME]";
$result = mysql_query($qstr);

is that right??

but then how do i call it??

get the name of the player1 to appear on the members area etc..

thank you in advance

lurchblake

I think you could really do with reading a bit of back ground, and I know an excellent place to start. Have a read of the webmonkey php/mysql tutorial at:

http://hotwired.lycos.com/webmonkey/99/21/index2a.html

Just follow the tutorial and you should be in a position to answer your previous question, and loads more, within about half an hour!

mogster

The code:

## Query compilation  ##
$qstr = "SELECT player1 from members2 where username = [$SESSION_UNAME]"; 
## Query execution ##
$result = mysql_query($qstr);
## Query detail specification ##
$row = mysql_fetch_array($result);
## The player will be accessible as ##
echo $row['player1'];

knutm 😉

susi

i did that and i got this error..
not sure what to do

Warning: Supplied argument is not a valid MySQL result resource in /users/cais3/shicke-cais3/public_html/Footie/Php4/MembersArea.php on line 19

any ideas??

buck2bcr

Have you established a link to your database earlier in your code?

the mysql_query actually takes two variables:

mysql_query($your_query, $link_to_database)

If you leave the second one off php uses the last open connection that you had, so if you haven't made a link you cannot query the database. So in your code before you make a query you need to establish a link:

// link to database and select database to use
$dbhost = "localhost";
$dbuname = "username";
$dbpass = "password";
$db = "db_name";
$link = mysql_connect($dbhost,$dbuname,$dbpass) or die ("Couldn't connect to server. ");
mysql_select_db($db, $link) or die("Couldn't select database.");

//Query compilation
$qstr = "SELECT player1 from members2 where username = [$SESSION_UNAME]"; 

// Query execution 
$result = mysql_query($qstr, $link);

// Query detail specification 
$row = mysql_fetch_array($result);
// The player will be accessible as 
echo $row['player1'];

I usually put the database connection stuff in and include file so I don't have to edit a bunch of pages in case something changes.

HTH

Buck

susi

🙂 thank you so much! it works now!!

buck2bcr

Your more than welcome. I'm glad it works. 🙂

Buck