Masalah Ngan Php

[niurexx 0]

salam semua.. aku ada sedikit kekliruan kat sini.. dimana aku memerlukan bantuan para otai kat sini. aku sedang develope satu projek multilevel punya website... web nih menggunakan sistem penaja. masalah aku skang.. camne aku nak select penaja kepada penaja ? contoh koding aku ada kat bawah.. coding skang nih aku telah berjaya untuk select penaja sahaja. aku dah blur camne nak select penaja kepada penaja.

if($action == "save_editreg")
    {
	$penaja = $_POST["penaja"];

$se = get_row_count("users", "WHERE penaja='$penaja'");

//komisen aras 1
if ($se < "7") {
$aras = 25;
} else 
//komisen aras 2
if ($se > "7" and $se < "49") {
$aras = 25;
} else 
//komisen aras 3
if ($se > "49" and $se < "343") {
$aras = 20;
} else 
//komisen aras 4
if ($se > "342" and $se < "16087") {
$aras = 20;
} else 
//komisen aras 5
if ($se > "18606" and $se < "117649") {
$aras = 10;
} else 
//komisen aras 6
if ($se > "117648") {
$aras = 10;
}

$w = mysql_query("SELECT wallet FROM users WHERE username='$penaja'");
if ($j=mysql_fetch_array($w)) {
do {
$wall = $j["wallet"];
} while ($j=mysql_fetch_field($w));
}

$baras = $aras * 0.25;
$barass = $aras - $baras;
$taja = 75;
$wallet = $taja + $barass;

$baras2 = $aras * 0.25;
$taja2 = 25;
$wallet2 = $taja2 + $baras2;

mysql_query("UPDATE users SET wallet=wallet + $wallet WHERE username='$penaja'");
mysql_query("UPDATE users SET klon=klon + $wallet2 WHERE username='$penaja'");
mysql_query("UPDATE users SET status='$ed_status' WHERE id=$id");

$q = mysql_query("SELECT * FROM users WHERE username='$penaja'");
if ($f=mysql_fetch_array($q)) {
do {
$users_id = $f["id"];
} while ($f=mysql_fetch_field($q));
}

$laporan2 = "Masuk RM".$wallet."";
mysql_query("INSERT INTO log_wallet (date, user_id, masuk, keluar, laporan) VALUES (now(), '$users_id', '$wallet', '', '$laporan2')");

show_error_msg("Updated", "<br><br><center><b>Updated Completed</b><BR><BR><a href='admincp.php?action=confirmreg'>Click here</a> to go back.</center>");

command ni aku gunakan untuk select penaja... tp camne plak kalau nak select penaja kepada penaja..?

$q = mysql_query("SELECT * FROM users WHERE username='$penaja'");

aku minatk tolong sangat2 kat korang semua... aku dah puas pikir dah nih..

Edited April 23, 2008 by niurexx

[cyberfly 1]

try ni.kalo salah sori la

$q = mysql_query("SELECT * FROM users WHERE username='$penaja'");

$dataq = mysql_fetch_array($q);

$penajaq = mysql_query("SELECT * FROM penaja WHERE anaktaja='".$dataq['idUsers']."'");

$datapenajaq = mysql_fetch_array($penajaq);

$bapakpenaja = $datapenajaq['namaPenaja'];

Edited April 24, 2008 by cyberfly