|
-
May 26th, 2010, 10:31 AM
#1
Thread Starter
Hyperactive Member
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  
-
May 26th, 2010, 11:43 AM
#2
Thread Starter
Hyperactive Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|