mission.rubix
New member
I'm literally pulling my hair out over this one! I have a problem in that the database I'm working on stores the a certain variable in another table... (pretty stupid I know). This means that I have this:
new_players: name etc.
p_app: appid, is (is is either 1 for current or 2 for rejected)
This is so difficult to explain, basically I need to do this: an HTML table listing all current applications and one to list all rejected with two queries I think. This is what I've got so far:
$sql = "SELECT * FROM `p_app` LIMIT 0, 30 ";
$ssql = mysql_query($sql);
while($rowk = mysql_fetch_array($ssql)) {
$asdf = $rowk['appid'];
$asdffdsa = $rowk['is'];
if($asdffdsa == "1") {
$currentapplication = $asdf;
} else {
$failedapplication = $asdf; }
}
$queryNEWAPPS = mysql_query("SELECT id, name, namei, email FROM new_players WHERE id = '$currentapplication'");
while(list($appid, $name, $nameii, $email) = mysql_fetch_row($queryNEWAPPS)){
(etc.)
It lists only ONE of all the current applications though ARGH! Help me please before I have a mental breakdown!
Bustin98 has given me one of the most concise and informative answers I've ever received from Yahoo Answers and will of course get the Best Answer when that option becomes available. In short I have resolved the problem and no longer require answers! Thanks Bustin.
new_players: name etc.
p_app: appid, is (is is either 1 for current or 2 for rejected)
This is so difficult to explain, basically I need to do this: an HTML table listing all current applications and one to list all rejected with two queries I think. This is what I've got so far:
$sql = "SELECT * FROM `p_app` LIMIT 0, 30 ";
$ssql = mysql_query($sql);
while($rowk = mysql_fetch_array($ssql)) {
$asdf = $rowk['appid'];
$asdffdsa = $rowk['is'];
if($asdffdsa == "1") {
$currentapplication = $asdf;
} else {
$failedapplication = $asdf; }
}
$queryNEWAPPS = mysql_query("SELECT id, name, namei, email FROM new_players WHERE id = '$currentapplication'");
while(list($appid, $name, $nameii, $email) = mysql_fetch_row($queryNEWAPPS)){
(etc.)
It lists only ONE of all the current applications though ARGH! Help me please before I have a mental breakdown!
Bustin98 has given me one of the most concise and informative answers I've ever received from Yahoo Answers and will of course get the Best Answer when that option becomes available. In short I have resolved the problem and no longer require answers! Thanks Bustin.