how to check a particular field from a query

[pouncer]

[code=php:0]
$Password = md5($Password);

mysql_query("SELECT * FROM users WHERE username='$Username' AND password='$Password'");
$login_check = mysql_num_rows($sql);

if ($login_check > 0) {
//check if activated.
}
[/code]

i need to check if the 'Activated' field of the user is 1. i.e, if the user who is logging in has actually activated their memberhsip. how do i do this?

[roopurt18]

[code]<?php
$sql = "SELECT * FROM users WHERE username='$Username' AND password='$Password'"
$q = mysql_query($sql);
if($q){
  while($row = mysql_fetch_assoc($q)){
    if($row['Activated'] == 1){
      // It is activated
    }
    break;
  }
}
?>[/code]

[pouncer]

Thanks. but what if that username or password do not exist in the database?

[roopurt18]

Then it's obviously not activated.

[code]<?php
$sql = "SELECT * FROM users WHERE username='$Username' AND password='$Password'"
$q = mysql_query($sql);
if($q){
  while($row = mysql_fetch_assoc($q)){
    if($row['Activated'] == 1){
      // It is activated
    }
    break;
  }
}else{
  // No record found
  echo 'You need to register!';
}
?>[/code]

[pouncer]

oh yeah. sorry.

Thanks, perfect.