Select SQL question

[Techissue2008]

I have 2 tables:

Usertable
Userid, username, mobile, status
1, Alan, 123456, 1

Status
Statusid, status
1, invalid
2, valid

$query = "SELECT userid, username, mobile, status from usertable”;
$result = mysql_query($query);
<?php
while(list($userid, $username,, $mobile, $status) = mysql_fetch_array($result))
{
?>
<table>
<tr align="left">
<td width="140">
<?php echo $username;?>
</td>
<td width="100">
<?php echo $mobile;?>
</td>
<td width="50">
<?php echo $status;?>
</td>
</table>
<?php } ?>

How can I change the select SQL to show the status value?
If it is 1, then show invalid in the row
If it is 2, then display valid in the row
But not just show the number 1 or 2.

[rulian]

using JOINS

$query="SELECT `t1`.`userid`, `t1`.`username`, `t1`.`mobile`,`t1`. `status`, `t2`.`status` AS `status_string` from `usertable` AS `t1`
LEFT JOIN `status` AS `t2` on `t1`.`status` = `t2`.`Statusid`"; 

and then 

while(list($userid, $username, $mobile, $status_id, $status_str) = mysql_fetch_ASSOC($result))

...
<td width="50">
<?php echo $status_str;?>
</td>
that way you avoid getting repeat information since fetch_array returns both numerical and relative indexes

[Techissue2008]

Hi

$query="SELECT t1.userid, t1.username, t1.mobile,t1. status, t2.status AS status_str from usertable AS t1
LEFT JOIN status AS t2 on t1.status = t2.Statusid";

while(list($userid, $username, $mobile, $statusid, $status_str) = mysql_fetch_ASSOC($result))
<?php echo $status_str;?>

What is $status_id? do you mean t2's statusid?
Do you mean $status_str = $status_string?

If so, it does not show any data in the row.

But I can execute the SQL and show results.

How can I fix it?