Re: HELP PLEASE!

From:	heinisch at creaction dot de	Date:	Thu, 28 Mar 2002 08:33:28 +0000
Subject:	Re: HELP PLEASE!
References:	1	Groups:	php.general
Request:	Send a blank email to php-general+get-90492@lists.php.net to get a copy of this message

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"> " face="<?=$fontface?>"><a href="index.php? topic=addprofile">Add your profile</a> <hr width="475" align="left" noshade> <table border="0" cellspacing="0" cellpadding="0"> <tr> <td>" face="<?=$fontface?>"> First Name:</td> <td>" 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)); } ?></td> </tr> <tr> <td>" face="<?=$fontface?>"> Last Name:</td> <td>" 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)); } ?></td> </tr> <tr> <td>" face="<?=$fontface? "> D.O.B:</td> <td>" 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)); } ?></td> </tr> <tr> <td>" face="<?=$fontface? "> City:</td> <td>" 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)); } ?></td> </tr> <tr> <td>" face="<?=$fontface? "> State:</td> <td>" 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)); } ?></td> </tr> <tr> <td>" face="<?=$fontface?>"> E- mail:</td> <td>" 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></td> </tr> <tr> <td>" face="<?=$fontface?>"> Dirt Bike:</td> <td>" 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)); } ?></td> </tr> <tr> <td>" face="<?=$fontface? "> Class:</td> <td>" 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)); } ?></td> </tr> <tr> <td>" face="<?=$fontface?>"> Years Riding:</td> <td>" 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)); } ?></td> </tr> <tr> <td>" face="<?=$fontface?>"> Favorite Track:</td> <td>" 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)); } ?></td> </tr> <tr> <td>" face="<?=$fontface? "> Sponsors:</td> <td>" 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)); } ?></td> </tr> <tr> <td>" face="<?=$fontface? "> Injuries:</td> <td>" 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)); } ?></td> </tr> <tr> <td>" face="<?=$fontface? "> Comments:</td> <td>" 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)); } ?></td> </tr> <tr> <td colspan="2"><hr width="475" align="left" noshade></td> </tr> </table> " face="<?=$fontface?>"><a href="index.php? topic=addprofile" style="font-size : 10pt;">Add your profile</a> </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