Re: [PHP] HELP PLEASE!

heinisch Thu, 28 Mar 2002 00:28:17 -0800

At 27.03.2002  21:20, you wrote:
Even if I didn´t read your code exactly, the fault is
the do while loop
replace it with something like this
while ($row = mysql_fetch_array($result))
{
         for($i=0,$i < count($row);$i++)
         { // add something to make it fancy like a table or so
                 echo $row[$i];
         }
}
in php4* there is something like foreach, which I do not exactly know
HTH Oliver
>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>&nbsp;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>&nbsp;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>&nbsp;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>&nbsp;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>&nbsp;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>&nbsp;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>&nbsp;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>&nbsp;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>&nbsp;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>&nbsp;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>&nbsp;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>&nbsp;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>&nbsp;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
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] HELP PLEASE!

Reply via email to