Translate from ColdFusion to PHP

[jamessmb]

I very experience with ColdFusion and am struggling with a PHP project. In CF when I do a query, I can easily check to see if any records were returned. I can't quite figure out how to do this with PHP. I'm using Dreamweaver to code the pages, but becuase of my newness I don't understand.

Here's how I'd do it in CF:
<cfquery name="getLogin" datasource="datasource">
SELECT username, userID FROM users WHERE userID = '#URL.UID#'
</cfquery>
<cfif #getLogin.RecordCount# GTE 1>
<cfset SESSION.UID = #getLogin.UserID#>
<cflocation url="sompage.cfm">
<cfelse>
<cflocation url="login.cfm">
</cfif>

Anyone care to help me translate?
Thanks,
James

[jamessmb]

As usual, as soon as I ask for help, I figure out the answer....

if($totalRows_Recordset1 >= 1){
$SESSION['svUserID'] = $row_Recordset1['subid'];
$SESSION['svFirstName'] = $row_Recordset1['fName'];
header("Location: " . "MemberAccountDetails.php");
}else{
header("Location: " . "MemberLogin.php");
}

James

[dalecosp]

Or something like [man]mysql_num_rows/man:

$qry="select * from users where uname=$uname and pw=$pw";
$result=mysql_query($qry);
if (mysql_num_rows($result)>0) {
//login successful, etc.

[jamessmb]

oops, forgot the previous line of code:
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

James