php data entry question - Tech Support Forums

VHockey86 · August 16th, 2004, 08:47 PM

Well, I have yet to get around to learning java/php so I was wondering if anyone here could lead me in the right direction.

Basically heres the general premesis of what I'm trying to accomplish.
I designed a website for a friend's halo clan that competes in matches with other clans and stuff. I was thinking it would be cool to add some sort of "recent matches" display on the site, however I dont really want to have to update it myself manually all the time.
So I came up with another idea but am not really sure how to code/impliment it.
Perhaps what I am thinking of isnt possible, but it didnt seem too hard in theory.

Create a form that the other members can goto on the page. The form would be a basic html form and contain boxes for like a date, a game type, the opposing clan, score, win/lose. There sorta thing.

I would like to make it so that this imformation was processed by perhaps a php file, and stored in a file/database.

Then on the main page, a box would read the submitted information and show it in a corresponding table.

In short, a form to submit information into an information box on the web page.

If this doesnt really make any sense let me know. If its really simple and someone wouldnt mind coding it I'd really appreciate it, otherwise perhaps some instructions on what I'd actualy need to do would be helpful (like what functions or something).

Not that it particularily matters, but heres a link to the site:
http://s90390266.onlinehome.us/newclan/
I have access to a mysql database too if that helps any.

Thx,
Vhockey86

VHockey86 · August 17th, 2004, 02:03 AM

Well after finding this guide,
http://dev.mysql.com/tech-resources/...s/ddws/20.html
and about 2 hours of reading/interpreting/editing code I managed to sort of get something working

Submission form:
http://s90390266.onlinehome.us/newclan/test.htm
Results form mysql database:
http://s90390266.onlinehome.us/newclan/viewmatches.php

Now my problem is..... new entries are added AFTER the other one (makes sense of course), but since its a "recent" matches list, I want the most recent entry to be display BEFORE the other.
Anyone know what I need to do to change this?
Heres how I have my submission file coded:

Code:

 <?php // Connect to the database server
    $dbcnx = @mysql_connect("removed", "removed", "removed");
    if (!$dbcnx) {
      echo( "<P>Unable to connect to the " .
            "database server at this time.</P>" );
      exit();
    }

    // Select the database
    if (! @mysql_select_db("db106426321") ) {
      echo( "<P>Unable to locate the joke " .
            "database at this time.</P>" );
      exit();
    }

    // add it to the database.
      $sql = "INSERT INTO matches SET " .
             "opponet='$opponet', " .
			 "members='$members', " .
			 "level='$level', " .
			 "gametype='$gametype', " .
			 "outcome='$outcome', " .
             "date=CURDATE()";
      if (mysql_query($sql)) {
        echo("<P>Your entry has been added.</P>");
      } else {
        echo("<P>Error adding submitted entry: " .
             mysql_error() . "</P>");
      }
 ?>

And heres the file that views from the database

Code:

<body>
<?php $dbcnx = @mysql_connect("removed", "removed", "removed");
if (!$dbcnx) {
  echo( "<P>Unable to connect to the " .
        "database server at this time.</P>" );
  exit();
}
if (! @mysql_select_db("db106426321") ) {
  echo( "<P>Unable to locate the joke " .
        "database at this time.</P>" );
  exit();
}
  
 
?>
<table border="1" bordercolor="#00CCFF" cellpadding="3" cellspacing="3">
  <tr>
    <td>Date</td>
    <td>Opponet (Clan) </td>
    <td>TU Members </td>
    <td>Level</td>
    <td>Game Type </td>
    <td>Outcome (win/lose) </td>
  </tr>
  <tr><td>
<?php
 // Request the text of all Dates
  $result = mysql_query(
            "SELECT date FROM matches");
  if (!$result) {
    echo("<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }
  while ( $row = mysql_fetch_array($result) ) {
    echo($row["date"] . "<br>");
  }
?>
</td><td>
<?php
$result = mysql_query(
            "SELECT opponet FROM matches");
  if (!$result) {
    echo("<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }
  while ( $row = mysql_fetch_array($result) ) {
    echo($row["opponet"] . "<br>");
  }
?>
</td><td>
<?php
$result = mysql_query(
            "SELECT members FROM matches");
  if (!$result) {
    echo("<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }
  while ( $row = mysql_fetch_array($result) ) {
    echo($row["members"] . "<br>");
  }
?>
</td><td>
<?php
$result = mysql_query(
            "SELECT level FROM matches");
  if (!$result) {
    echo("<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }
  while ( $row = mysql_fetch_array($result) ) {
    echo($row["level"] . "<br>");
  }
?>
</td><td>
<?php
$result = mysql_query(
            "SELECT gametype FROM matches");
  if (!$result) {
    echo("<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }
  while ( $row = mysql_fetch_array($result) ) {
    echo($row["gametype"] . "<br>");
  }
?>
</td><td>
<?php
$result = mysql_query(
            "SELECT outcome FROM matches");
  if (!$result) {
    echo("<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }
  while ( $row = mysql_fetch_array($result) ) {
    echo($row["outcome"] . "<br>");
  }
?>
</td></tr></table>

</body>

Any help appreciated, sorry for the really long post

RNA411 · September 8th, 2004, 03:01 PM

If it were me, I would just run one loop and pull all the info from the table ordered by date. Then you can step through and output a table of the ordered matches.

-Dana