If/else statements - help.

[Chris]

Sorry to post so much code all at once but I'm banging my head against
the wall trying to get this to work!

Does anyone have any idea where I'm going wrong?

Thanks in advance and sorry again for adding so much code...


<TABLE border="1" bordercolor="#000000" cellspacing="0">
<TR>
<TD>

<?php

include("misc.inc");

$connection = mysql_connect($host,$user,$password)
or die ("Couldn't connect to the server");

$db = mysql_select_db($database,$connection)
or die ("Couldn't select the database");


/* based upon the selection from the drop-down list, select the
player's basic details and format his
birthdate to the english format */

$query = "SELECT *, DATE_FORMAT(birthdate, '%d/%m/%y') AS birth FROM
player WHERE playerid='{$_POST['interest']}'";
$result = mysql_query($query)
or die ("Couldn't execute query");

$row = mysql_fetch_array($result);


/* again, based upon the selection from the drop-down list, select
all the player's historical details from
the playerhistory table ensuring the date joined is in the english
format */

$query2 = "SELECT *, DATE_FORMAT(joined, '%d/%m/%Y') AS joined FROM
playerhistory WHERE playerid='{$_POST['interest']}'";
$result2 = mysql_query($query2)
or die ("Couldn't execute query2");

$row2 = mysql_fetch_array($result2);



/* This selects all records from player appearances table and links
with playerhistory table

$query3 = "SELECT * FROM playerapps LEFT JOIN playerhistory ON
playerapps.playerhistid = playerhistory.playerhistid";
$result3 = mysql_query($query3)
or die ("Couldn't execute query3");

$rows3 = mysql_fetch_array($result3);
$nrows3 = mysql_num_rows($result3);


/* display the results in a table */

print "<TABLE border='1' bordercolor='#000000' width='800'
class='table'>\n";



print "<tr valign='top'>\n";
printf ("<td width='90'><b>%s</b>\n",$row['forename']);
printf ("<b>%s</b></td>\n",$row["surname"]);
print "<td width='70'></td>\n";
print "<td width='70'></td>\n";
print "<td width='70'></td>\n";
print "<td width='70'></td>\n";
print "<td width='70'></td>\n";
print "<td width='70'></td>\n";
print "</tr>\n";

print "<tr>\n";
print "<td>BIRTHDATE:</td>\n";
printf ("<td>%s</td>\n",$row["birth"]);
print "</tr>\n";

print "<tr>\n";
print "<td>BIRTHPLACE:</td>\n";
printf ("<td>%s</td>\n",$row['birthplace']);
print "</tr>\n";

print "<tr>\n";
print "<td>NATIONALITY:</td>\n";
printf ("<td>%s</td>\n",$row['nationality']);
print "<tr>\n";

print "<tr>\n";
print "<td>POSITION:</td>\n";
printf ("<td>%s</td>\n",$row['position']);
print "</tr>\n";
print "</TABLE>\n";

print "<TABLE border='1' bordercolor='#000000' width='700'
class='table'>\n";
print "<tr align='center' class='heading'>\n";
print "<td bgcolor='#000066' width='70'>JOINED</td>\n";
print "<td bgcolor='#000066' width='70'>FROM</td>\n";
print "<td bgcolor='#000066' width='70'>TO</td>\n";
print "<td bgcolor='#000066' width='70'>VALUE</td>\n";

print "<td bgcolor='#000066' width='70'>FULL APPS</td>\n";
print "<td bgcolor='#000066' width='70'>SUB APPS</td>\n";
print "<td bgcolor='#000066' width='70'>GOALS</td>\n";
print "<td bgcolor='#000066' width='70'>RED CARDS</td>\n";
print "<td bgcolor='#000066' width='70'>YELLOW CARDS</td>\n";
print "</tr>\n";

while ($rows3 = mysql_fetch_array($result3))

{

print "<tr align='center'>\n";
printf ("<td width='70'>%s</td>\n",$row2['joined']);
printf ("<td width='70'>%s</td>\n",$row2['goals']);
printf ("<td width='70'>%s</td>\n",$row2['toclub']);
printf ("<td width='70'>%s</td>\n",$row2['boughtfor']);
print "</tr>\n";

if ($nrows3 == 1)

{
printf ("<td width='70'>%s</td>\n",$rows3['apps']);
printf ("<td width='70'>%s</td>\n",$rows3['subapps']);
printf ("<td width='70'>%s</td>\n",$rows3['goals']);
printf ("<td width='70'>%s</td>\n",$rows3['redcards']);
printf ("<td width='70'>%s</td>\n",$rows3['yellowcards']);
print "</tr>\n";
}
else
{
while ($rows3 = mysql_fetch_array($result3))
{
printf ("<td width='70'>%s</td>\n",$rows3['apps']);
printf ("<td width='70'>%s</td>\n",$rows3['subapps']);
printf ("<td width='70'>%s</td>\n",$rows3['goals']);
printf ("<td width='70'>%s</td>\n",$rows3['redcards']);
printf ("<td width='70'>%s</td>\n",$rows3['yellowcards']);
print "</tr>\n";
print "<tr>\n";
print "<td></td>\n";
print "<td></td>\n";
print "<td></td>\n";
print "<td></td>\n";
}

}

}



print "</TABLE>\n";


?>

</TD>
</TR>
</TABLE>

[Andy Hassall]

On 28 Jun 2003 06:24:13 -0700, [email]hsirhc@hotmail.com[/email] (Chris) wrote:

>Sorry to post so much code all at once but I'm banging my head against
>the wall trying to get this to work!
>
>Does anyone have any idea where I'm going wrong?
>
>Thanks in advance and sorry again for adding so much code...

This not a good way to ask a question - you've sent 160 lines of code, but
you've not said anything about:

- What's going wrong
- What errors you get, if any
- What output you get, if any
- What you were expecting
- What you've tried to fix the code
- And you haven't tried to cut down the code to the minimum required to show
your (unstated) problem.

The only clue is in your subject line, that it's something to do with an
if/else.

[big snip]

> $query3 = "SELECT * FROM playerapps LEFT JOIN playerhistory ON
>playerapps.playerhistid = playerhistory.playerhistid";
> $result3 = mysql_query($query3)
> or die ("Couldn't execute query3");
>
> $rows3 = mysql_fetch_array($result3);
> $nrows3 = mysql_num_rows($result3);
>

[another big snip]

>
>while ($rows3 = mysql_fetch_array($result3))

You've fetched one row from $result3 here.

[snip]

>if ($nrows3 == 1)

If there is one row then...

> {

[snip print of $rows3]

You print this row.

> }
> else
> {
> while ($rows3 = mysql_fetch_array($result3))

Else, you start a loop by fetching another row - but you've not yet printed
out the $row3 you fetched the first time you fetched from $result3 above, so
you've lost that row now.

> {

[snip print of $rows3]

> }
>
> }
>
>}

[another snip]

So you're missing some data, but is that the problem you were asking about?
You've not said what you wanted, so no idea if that's what's missing.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) ([url]http://www.andyh.co.uk[/url])
Space: disk usage analysis tool ([url]http://www.andyhsoftware.co.uk/space[/url])