[RESOLVED] displaying data in a webpage.

**rgyankees23** · Apr 3rd, 2007, 02:17 PM

Hey guys,

I am learning to use mysql but what I lack is the knowledge of php. I am purchasing some books as to how to learn it so I can avoid asking you guys for help for the simpliest things.

Currently this is the page that I have.

I want to transfer all the pitchers and catchers, infielders and outfielders into an mysql database. For that code this is what I have:

Code:

<?
$dbh=mysql_connect ("localhost", "rgross_rgross", "mlg1984") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("rgross_40manrosternyy2007");
?>
<html>
<head>
<title>2007 NYY 40-Man Roster</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="roster.css" type="text/css" />
</head>
<body>
<div id="header">The 2007 NY Yankees 40-Man Roster</div>
<p>&nbsp;</p>
<table align="center" id="pitchers">
  <tr class="title">
    <td>NO.</td>
    <td>First Name</td>
	<td>Last Name</td>
    <td>BAT</td>
    <td>THW</td>
    <td>HT</td>
    <td>WT</td>
    <td>DOB</td>
  </tr>
  <?
$get_teamdata = mysql_query("SELECT * FROM `pitchers` ORDER BY `id` ASC"); ?>
<tr class="info">
    <td><?=$td['No.']; ?></td>
    <td><?=$td['FName']; ?></td>
	<td><?=$td['LName']; ?></td>
    <td><?=$td['BAT']; ?></td>
    <td><?=$td['THW']; ?></td>
    <td><?=$td['HT']; ?></td>
    <td><?=$td['WT']; ?></td>
    <td><?=$td['DOB']; ?></td>
  </tr>
</table>
</body>
</html>

Now I want the the actual rows to be #999999.

Any help? Thanks

Thread: [RESOLVED] displaying data in a webpage.

Thread Tools

Display

Threaded View

[RESOLVED] displaying data in a webpage.

Posting Permissions