printing a single value from MySQL database

[c70236]

I have come accross a script for login credentials,

however I am new to MySQL

 

SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'

 

I added a third detail to the database, a class for each user under the column I named 'class'

 

how can I retrieve this detail from the database? I don't know how to retrieve this...

 

It looks like the answer I seek has been put into a variable called $result

 

$result=mysql_query($sql);

 

[Jessica]

That's just the result object, you need to then fetch a row.

Which your script is probably already doing. Find the next time $result is used.

[c70236]

its only used here:

 

$count=mysql_num_rows($result);

[Jessica]

mysql_fetch_assoc

 

That script you found probably isn't very good, there's not much point in selecting a row you do nothing with other than the count, you would just do a COUNT() in the query then.