Results 1 to 16 of 16

Thread: [RESOLVED] my first php page

Hybrid View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2007
    Posts
    261

    Re: my first php page

    hi kows
    its work thanks.
    how do i add more coloms so it looks like
    picture | video number | video title
    programming pc: laptop. running xp pro and vb.net..
    media centre xp pc: dual core 6000,4gb memory, 1tb harddrive
    mainserver: server 2008, 8gb memory, amd e-350 dual core, 6tb harddrive and local web host
    atomvault 1: server 2008, atom 330 with 4 gb memory, 35TB hardrive space for videos and music..
    backup pc : xp, 4gb, atom 330, 10tb harddrive(web, pictures, music, databases)
    2 x video backup: atom 330, 2gb, 18tb harddrive
    everything on remote login..
    check out my builds http://AtomVaults.yolasite.com

    learning vb.net and php + mysql - got most of the basics now.

    I WISH THERE WAS MORE TIME IN THE DAY

  2. #2

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2007
    Posts
    261

    Re: my first php page

    hi
    ive got the picture to load with video title next to it by using value i just cant get any of the of coloms ie age video number to put next the the picture
    PHP Code:
    $result = mysql_query( "SELECT videotitle, age, Runningtime FROM videolist WHERE vidnumber LIKE '".mysql_real_escape_string($id)."'")


    or die("SELECT Error: ".mysql_error());
    $num_rows = mysql_num_rows($result);
    // print "There are $num_rows records.<P>";
    print "<table width=300 border=1>\n";
    while ($get_info = mysql_fetch_row($result)){ 
    // <?php while ($get_info mysql_fetch_assoc($result)){ ?>
      <tr>
      <?php
      
    //get the names of your table columns into an array:
         
    foreach($get_info as $key => $value){
        
    ?><td><?php
        
    //if you find the name of the image column, output an img tag,
        //otherwise just output the field data:
        
    if($key == "imgName"){
          
    ?><img border=0 src="/vidpics/<?php echo $value;?>web.jpg" width=60 height=60><?php 
        
    echo "</td><td>"
        echo 
    $value;
        echo 
    "</td><td>";
     
    // im wanting to add video title and video number here
    // value is the video title but i cant get anything else 
        
    echo $value;

        }else{
         
    //  echo $value;
        
    }

        
    ?></td><?php
      
    }
      
    ?></tr><?php
    }
    ?>
    programming pc: laptop. running xp pro and vb.net..
    media centre xp pc: dual core 6000,4gb memory, 1tb harddrive
    mainserver: server 2008, 8gb memory, amd e-350 dual core, 6tb harddrive and local web host
    atomvault 1: server 2008, atom 330 with 4 gb memory, 35TB hardrive space for videos and music..
    backup pc : xp, 4gb, atom 330, 10tb harddrive(web, pictures, music, databases)
    2 x video backup: atom 330, 2gb, 18tb harddrive
    everything on remote login..
    check out my builds http://AtomVaults.yolasite.com

    learning vb.net and php + mysql - got most of the basics now.

    I WISH THERE WAS MORE TIME IN THE DAY

Posting Permissions

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



Click Here to Expand Forum to Full Width