Code: Select all
while ($x = mysql_fetch_array($query)
{
$blah = $xї"blah"]
}
їcode]
or should is use:
їcode]
while ($x = mysql_fetch_row($query)
{
$blah = $xї"blah"]
}Moderator: General Moderators
Code: Select all
while ($x = mysql_fetch_array($query)
{
$blah = $xї"blah"]
}
їcode]
or should is use:
їcode]
while ($x = mysql_fetch_row($query)
{
$blah = $xї"blah"]
}Code: Select all
$row = mysql_fetch_assoc(mysql_query($sql));Code: Select all
list($a,$b,$c) = mysql_fetch_assoc($result);Code: Select all
/* connect to db and execute memberLoginQuery */
$connection = mysql_connect($db_host, $db_user, $db_pass) or die ("Unable to connect!
" .mysql_error());
$memberLoginQuery = "SELECT * FROM testLogin WHERE memberUserName = '$memberUserName' AND memberPasswd = password('$memberPasswd')";
$memberLoginResult = mysql_db_query("adv", $memberLoginQuery, $connection) or die ("Error in query:
$query.
" . mysql_error());
/* if row exists - login/pass is correct */
if (mysql_num_rows($memberLoginResult) == 1)
{
/* initiate a session */
session_start();
/* make variables from sql data */
while ($memberLoginRow = mysql_fetch_assoc($memberLoginResult))
{
$memberID = $memberLoginRowї"memberID"];
$memberUserName = $memberLoginRowї"memberUserName"];
$memberPasswd = $memberLoginRowї"memberPasswd"];
$memberEmail = $memberLoginRowї"memberEmail"];
}
/* query db for profile information */
$memberProfileQuery = "SELECT * FROM testProfile WHERE memberUserName = '$memberUserName'";
$memberProfileResult = mysql_query($memberProfileQuery);
while ($memberProfileRow = mysql_fetch_assoc($memberProfileResult))
{
$memberFirstName = $memberProfileRowї"memberFirstName"];
$memberLastName = $memberProfileRowї"memberLastName"];
$memberCity = $memberProfileRowї"memberCity"];
$memberCategory = $memberProfileRowї"memberCategory"];
$memberAge = $memberProfileRowї"memberAge"];
$memberGender = $memberProfileRowї"memberGender"];
$memberImage = $memberProfileRowї"memberImage"];
$memberStatus = $memberProfileRowї"memberStatus"];
$memberReferredBy = $memberProfileRowї"memberReferredBy"];
$memberDescr = $memberProfileRowї"memberDescr"];
$memberDescrWord1 = $memberProfileRowї"memberDescrWord1"];
$memberDescrWord2 = $memberProfileRowї"memberDescrWord2"];
$memberDescrWord3 = $memberProfileRowї"memberDescrWord3"];
}
/* qury db again to get values based on id numbers in the profile table */
$memberProfileQuery2 = "SELECT statusDescr,categoryName,genderValue FROM memberStatus,memberCategory,memberGender WHERE statusID='$memberStatus' AND categoryID='$memberCategory' AND genderID='$memberGender';";
$memberProfileResult2 = mysql_query($memberProfileQuery2);
while ($memberProfileRow2 = mysql_fetch_assoc($memberProfileResult2))
{
$memberStatus = $memberProfileRow2ї"statusDescr"];
$memberCategory = $memberProfileRow2ї"categoryName"];
$memberGender = $memberProfileRow2ї"genderValue"];
}
/* get descriptive words */
$memberDescrWord1Query = "SELECT descrWord FROM memberDescrWords,testProfile WHERE memberDescrWords.wordID=testProfile.memberDescrWord1 AND testProfile.memberUserName LIKE '$memberUserName'";
$memberDescrWord1Result = mysql_query($memberDescrWord1Query);
while ($memberDescrRow1 = mysql_fetch_assoc($memberDescrWord1Result))
{
$memberDescrWord1 = $memberDescrRow1ї"descrWord"];
}
/* get descriptive words */
$memberDescrWord2Query = "SELECT descrWord FROM memberDescrWords,testProfile WHERE memberDescrWords.wordID=testProfile.memberDescrWord2 AND testProfile.memberUserName LIKE '$memberUserName'";
$memberDescrWord2Result = mysql_query($memberDescrWord2Query);
while ($memberDescrRow2 = mysql_fetch_assoc($memberDescrWord2Result))
{
$memberDescrWord2 = $memberDescrRow2ї"descrWord"];
}
/* get descriptive words */
$memberDescrWord3Query = "SELECT descrWord FROM memberDescrWords,testProfile WHERE memberDescrWords.wordID=testProfile.memberDescrWord3 AND testProfile.memberUserName LIKE '$memberUserName'";
$memberDescrWord3Result = mysql_query($memberDescrWord3Query);
while ($memberDescrRow3 = mysql_fetch_assoc($memberDescrWord3Result))
{
$memberDescrWord3 = $memberDescrRow3ї"descrWord"];
}
/* register session variables */
session_register("memberID","memberUserName","memberFirstName","memberLastName","memberPasswd","memberEmail","memberCategory","memberDescr","memberReferredBy","memberImage","memberAge","memberGender","memberDescrWord1","memberDescrWord2","memberDescrWord3","memberStatus","memberCity");
/* Redirect to members section */
header("Location: ../../pages/members/index.phtml");
/* Free the query */
mysql_free_result($memberLoginResult);
mysql_free_result($memberProfileResult);
mysql_free_result($memberProfileResult2);
mysql_free_result($memberDescrWord1Result);
mysql_free_result($memberDescrWord2Result);
mysql_free_result($memberDescrWord3Result);
/* close connection */
mysql_close($connection);
}
else
/* login/pass check failed */
{
/* Free the query */
mysql_free_result ($memberLoginResult);
/* close connection */
mysql_close($connection);
/* redirect to Login page */
Header("Location: ../../index.phtml?error=1");
exit;
}
}Code: Select all
SELECT * FROM users WHERE id = (SELECT * FROM <tablename> WHERE <something> = <something_else>");