SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: Little Help

  1. #1
    SitePoint Wizard rctneil's Avatar
    Join Date
    Jun 2005
    Posts
    1,898
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Little Help

    Hi,
    Here is a bit of code from my php page. When i view the page the area for the code below is just blank on the actual webpage and nothing is shown.
    Any Thoughts?


    Query:
    PHP Code:
    $sql=@mysql_query("SELECT * FROM atm_rides, atm_areas WHERE atm_rides.id='$rideid' AND atm_rides.area=atm_areas.id"); 
    // mysql_fetch_array is an array which holds all the records field values, assign $getdata variable to this array 
    $getridedata=@mysql_fetch_array($sql); 
    Rest of PHP:
    PHP Code:
    <table border="1" align="center" cellpadding="0" cellspacing="0" width="70%"center">

    <!--###################################################################################################-->
    $getstats=mysql_data_seek($result,0);
    <?php while ($getstats mysql_fetch_array($result)) { ?>
                
            <!--First Row-->
               <tr>
               <?php if(!empty($getstats['ridename'])) { ?>
                   <td width="50%" class="col1">Name:</td>
                
                   <td width="50%"><?php echo $getstats['ridename']; ?></td>
               </tr>
               <?php ?>
            <!--End First Row-->
            
            <!--Second Row-->
               <?php if(!empty($getstats['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">Location:</td>
                   <td><?php echo $getstats['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Second Row-->
            
            <!--Third Row-->
               <?php if(!empty($getstats['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">Cost:</td>
                   <td><?php echo $getstats['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Third Row-->
            
            <!--Fourth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">First Installed</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Fourth Row-->
            
            <!--Fifth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Fifth Row-->
            
            <!--Sixth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Sixth Row-->
            
            <!--Seventh Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Seventh Row-->
            
            <!--Eighth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Eighth Row-->
            
            <!--Nineth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Nineth Row-->
            
            <!--Tenth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Tenth Row-->
            
            <!--Eleventh Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Eleventh Row-->
            
            <!--Twelfth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Twelfth Row-->
            
            <!--Thirteenth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Thirteenth Row-->
            
            <!--Fourteenth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Fourteenth Row-->
            
            <!--Fifteenth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Fifteenth Row-->
            
            <!--Sixteenth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Sixteenth Row-->
            
            <!--Seventeenth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Seventeenth Row-->
            
            <!--Eighteenth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Eighteenth Row-->
            
            <!--Nineteenth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Nineteenth Row-->
            
            <!--Twentieth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Twentieth Row-->
            
            <!--Twenty-First Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Twenty-First Row-->
            
            <!--Twenty-Second Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Twenty-Second Row-->
            
            <!--Twenty-Third Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Twenty-Third Row-->
            
            <!--Twenty-Fourth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Twenty-Fourth Row-->
            
            <!--Twenty-Fifth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Twenty-Fifth Row-->
            
            <!--Twenty-Sixth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Twenty-Sixth Row-->
            
            <!--Twenty-Seventh Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Twenty-Seventh Row-->
            
            <!--Twenty-Eighth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Twenty-Eighth Row-->
            
            <!--Twenty-Nineth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Twenty-Nineth Row-->
            
            <!--Thirtieth Row-->
               <?php if(!empty($getridedata['NAME OF A STATISTIC FIELD'])) { ?>
               <tr>
                   <td class="col1">TABLE HEADING</td>
                   <td><?php echo $getridedata['NAME OF A STATISTIC FIELD']; ?></td>
               </tr>
               <?php ?>
            <!--End Thirtieth Row-->
            
            
           <?php // end while loop ?>
        

    <!--###################################################################################################-->

    </table>
    Thanks

    Neil

  2. #2
    SitePoint Addict ghostme's Avatar
    Join Date
    Feb 2005
    Posts
    371
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    PHP Code:
    mysql_error() 
    This should tell what is wrong

  3. #3
    SitePoint Wizard rctneil's Avatar
    Join Date
    Jun 2005
    Posts
    1,898
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sorted it. No idea what the problem was but it is fixed now!

    Thanks

    Neil


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •