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> 1 4064
On 28 Jun 2003 06:24:13 -0700, hs****@hotmail.com (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 (an**@andyh.co.uk) icq(5747695) ( http://www.andyh.co.uk)
Space: disk usage analysis tool ( http://www.andyhsoftware.co.uk/space) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: dmbkiwi |
last post by:
I am new to this group, and relatively new to python programming, however,
have encountered a problem I just cannot solve through reading the
documentation, and searching this group on google.
I...
|
by: Diez B. Roggisch |
last post by:
Hi,
today I rummaged through the language spec to see whats in the for ... else:
for me. I was sort of disappointed to learn that the else clauses simply
gets executed after the loop-body -...
|
by: Bart Nessux |
last post by:
Should an if statement have a corresponding else statement? Or, is it OK
to have an if statement by itself. For completeness, it seems the two
should be together, but from experience I know that a...
|
by: Patrice |
last post by:
Hi,
I need to do multi-conditional statements like below, but this error is
displayed :
Expected 'End'
/myFilepath, line x
else response.write(arrCorpo(sparam,sdiv)) end if
I don't...
|
by: Amy |
last post by:
Hi,
I have 6 If Then Else statements I was supposed to write. I did so but I
know that they have to be wrong because they all look the same. Could
someone take a look at them and point me in the...
|
by: Brie_Manakul |
last post by:
I need to set up an if else to show different weather scripts based on
the city selection they choose. Any help on this would be great.
Thanks!
<%@ page language="java" import="java.util.*,...
|
by: cj |
last post by:
Another wish of mine. I wish there was a way in the Try Catch structure
to say if there wasn't an error to do something. Like an else
statement. Try Catch Else Finally.
Also because I...
|
by: sam_cit |
last post by:
Hi Everyone,
I read somewhere that there are some compile time operations behind
switch-case, which is why it can work for cases which evaluates to an
integer or character and not strings and...
|
by: pradeep.thekkottil |
last post by:
I'm setting up an auction website using PHP and MySQL. There in the
section where logged in members can put up new auction in a form, I
want to run a form validation where I used if else statements...
|
by: bearophileHUGS |
last post by:
So far in Python I've almost hated the 'else' of the 'for' loops:
- I have problems to remember its meaning;
- It gives me little problems when I later want to translate Python
code to other...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |