HELP PLEASE!
| From: | GENESiS DESiGNS | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | HELP PLEASE! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-90468@lists.php.net to get a copy of this message | ||
Hello,
My problem is I have a form that submits it info to a mysql table, well then I
have a page that calls it from the mysql table and displays whatever is in the
mysql table. So, what script do I use to make it display multiple entrys?? Here
is the code:
---------------------------------------------------------------------------
<?php
$title = "Powder Basin Motocross, INC. | | Rider Profiles";
include('header.php');
$conn = @mysql_connect ("host", "un", "pw")
or die("Coudn't connect to the MySQL server.");
mysql_select_db (pbmi_riderprofiles)
or die("Couldn't the select MySQL database.");
?>
<table border="0" cellspacing="0" cellpadding="0"><tr>
<td class="mainheader" width="475" align="center"
bgcolor="#666666">:: Rider
Profiles ::</td>
</tr>
<tr>
<td valign="top" align="left">
<font size="<?=$fontsize?>" face="<?=$fontface?>"><a
href="index.php?
topic=addprofile">Add your profile</a></font>
<hr width="475" align="left" noshade>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><b> First
Name:</b></font></td>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><?php $result =
mysql_query ("SELECT * FROM riderprofiles first_name"); if ($row =
mysql_fetch_array($result)) { do { echo $row["first_name"]; } while ($row =
mysql_fetch_array($result)); } ?></font></td>
</tr>
<tr>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><b> Last
Name:</b></font></td>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><?php $result =
mysql_query ("SELECT * FROM riderprofiles last_name"); if ($row =
mysql_fetch_array($result)) { do { echo $row["last_name"]; } while ($row =
mysql_fetch_array($result)); } ?></font></td>
</tr>
<tr>
<td><font size="<?=$fontsize?>" face="<?=$fontface?
>"><b> D.O.B:</b></font></td>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><?php $result =
mysql_query ("SELECT * FROM riderprofiles dob"); if ($row = mysql_fetch_array
($result)) { do { echo $row["dob"]; } while ($row = mysql_fetch_array
($result)); } ?></font></td>
</tr>
<tr>
<td><font size="<?=$fontsize?>" face="<?=$fontface?
>"><b> City:</b></font></td>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><?php $result =
mysql_query ("SELECT * FROM riderprofiles city"); if ($row = mysql_fetch_array
($result)) { do { echo $row["city"]; } while ($row = mysql_fetch_array
($result)); } ?></font></td>
</tr>
<tr>
<td><font size="<?=$fontsize?>" face="<?=$fontface?
>"><b> State:</b></font></td>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><?php $result =
mysql_query ("SELECT * FROM riderprofiles state"); if ($row = mysql_fetch_array
($result)) { do { echo $row["state"]; } while ($row = mysql_fetch_array
($result)); } ?></font></td>
</tr>
<tr>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><b> E-
mail:</b></font></td>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><a href="mailto:<?
=$riderfile[$i + 5]?>"><?php $result = mysql_query ("SELECT * FROM
riderprofiles email"); if ($row = mysql_fetch_array($result)) { do { echo $row
["email"]; } while ($row = mysql_fetch_array($result)); }
?></a></font></td>
</tr>
<tr>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><b> Dirt
Bike:</b></font></td>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><?php $result =
mysql_query ("SELECT * FROM riderprofiles dirt_bike"); if ($row =
mysql_fetch_array($result)) { do { echo $row["dirt_bike"]; } while ($row =
mysql_fetch_array($result)); } ?></font></td>
</tr>
<tr>
<td><font size="<?=$fontsize?>" face="<?=$fontface?
>"><b> Class:</b></font></td>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><?php $result =
mysql_query ("SELECT * FROM riderprofiles race_class"); if ($row =
mysql_fetch_array($result)) { do { echo $row["race_class"]; } while ($row =
mysql_fetch_array($result)); } ?></font></td>
</tr>
<tr>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><b> Years
Riding:</b></font></td>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><?php $result =
mysql_query ("SELECT * FROM riderprofiles yr"); if ($row = mysql_fetch_array
($result)) { do { echo $row["yr"]; } while ($row = mysql_fetch_array
($result)); } ?></font></td>
</tr>
<tr>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><b> Favorite
Track:</b></font></td>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><?php $result =
mysql_query ("SELECT * FROM riderprofiles favorite_track"); if ($row =
mysql_fetch_array($result)) { do { echo $row["favorite_track"]; } while ($row =
mysql_fetch_array($result)); } ?></font></td>
</tr>
<tr>
<td><font size="<?=$fontsize?>" face="<?=$fontface?
>"><b> Sponsors:</b></font></td>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><?php $result =
mysql_query ("SELECT * FROM riderprofiles sponsors"); if ($row =
mysql_fetch_array($result)) { do { echo $row["sponsors"]; } while ($row =
mysql_fetch_array($result)); } ?></font></td>
</tr>
<tr>
<td><font size="<?=$fontsize?>" face="<?=$fontface?
>"><b> Injuries:</b></font></td>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><?php $result =
mysql_query ("SELECT * FROM riderprofiles injuries"); if ($row =
mysql_fetch_array($result)) { do { echo $row["injuries"]; } while ($row =
mysql_fetch_array($result)); } ?></font></td>
</tr>
<tr>
<td><font size="<?=$fontsize?>" face="<?=$fontface?
>"><b> Comments:</b></font></td>
<td><font size="<?=$fontsize?>"
face="<?=$fontface?>"><?php $result =
mysql_query ("SELECT * FROM riderprofiles comments"); if ($row =
mysql_fetch_array($result)) { do { echo $row["comments"]; } while ($row =
mysql_fetch_array($result)); } ?></font></td>
</tr>
<tr>
<td colspan="2"><hr width="475" align="left"
noshade></td>
</tr>
</table>
<font size="<?=$fontsize?>" face="<?=$fontface?>"><a
href="index.php?
topic=addprofile" style="font-size : 10pt;">Add your
profile</a></font>
</td>
</tr>
</table>
<?php
include('footer.php');
?>
---------------------------------------------------------------------------
That will only display one entry... how do i make it display all the entrys??
Thanks!!!!!!!!!!
-Sean
Kennedy