retrieve field entry

[darknuke]

how do i retrieve a single variable MySQL table like this

Username|Password| UC|
george what 5
fred blah 2
matt 345 8

how can i retrieve the UC value from a single member?

[Weedpacket]

Huh? You mean how do you "SELECT UC FROM thetable WHERE username='something'"?

[darknuke]

yes: how to DISPLAY the VALUE of uc????

[darknuke]

my script:
<?
$un = 'dk';
$pw = 'mp';
$hostname = 'localhost';
$dbname = 'darknuke';
$tablename = "rm2kusers";
$link = MYSQL_CONNECT("$hostname", "$un", "$pw");
mysql_select_db("$dbname", $link);
$Query = mysql_query("SELECT FROM $tablename WHERE Username='$user'");
$Query2 = mysql_query("SELECT FROM $tablename WHERE Password='$passwd'");
$Query3 = mysql_query("SELECT * FROM $tablename WHERE Username='$user'");
$therows = mysql_num_rows($Query);
$therows2 = mysql_num_rows($Query2);
$therows3 = mysql_num_rows($Query3);

print "$therows3";
?>

i always get one as the value of $therows3 !!! whats wrong?!!?!?

[skodman]

mysql_num_rows returns number of rows that your query will give you. so you have to use:

$result=mysql_fetch_assoc($queryname)

which will give you $result array like this:

$result["fieldname1"]
$result["fieldname2"]
.
.
$result["fieldnamen"]

and after that you can use echo to display the value of field you want (in this case $result["UC"]... be carefull how you gona write name of fields inside ["...."] . it has to be same as in queryotherwise it will not work (small or capital letters);

skodman

[skodman]

or ypou can use

mysql_result()

or mysql_fetchrow()

there are so many functions for mysql so you just have to find out which one to use to get exact data from your db, and which one is most suitable for use in your scripts.