PHP RSS PHP RSS

Photo pieces compiled in table

Reply

•
•
Join Date: Apr 2008
Posts: 39
Reputation: Borderline is an unknown quantity at this point 
Solved Threads: 1
Borderline Borderline is offline Offline
Light Poster

Photo pieces compiled in table

 
0
  #1
Mar 30th, 2009
I'm using PHP to piece together photos on my website. I have the pieces in the correct order, but there is white space between each photo. At the moment, the only Css I have is placing the black border around the specified outer edges of the photo - I added this after the white space problem, so I can't think that it affects it.

Could anyone suggest how to correct this issue?

PHP Syntax (Toggle Plain Text) 
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  2. "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  3. <html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
  4.  
  5. <head>
  6. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  7. <title>Equine Focus</title>
  8. <link rel="stylesheet" type="text/css" href="/style/20090330.css"/>
  9. </head>
  10.  
  11. <body>
  12.  
  13. <?php
  14.  
  15. 	// 	Connects to your Database  
  16.  
  17. 		mysql_connect("*****", "*****", "*****") or die(mysql_error());  
  18. 		mysql_select_db("*****") 
  19. 		or die ("Unable to connect to MySQL");
  20.  
  21.  
  22. 	// mysql
  23.  
  24. 		$data = mysql_query("SELECT * FROM `photos` WHERE date = '2009-03-21' AND ref ='001'") or die 
  25. 		("No data available, please contact the site admin describing where you found this error message.");  
  26. 		?>
  27.  
  28. <table align='center' border='0' padding='0' spacing='0'>
  29.  
  30. <?php
  31. 		while($info = mysql_fetch_array($data)) {  
  32.  
  33. 	// images
  34.  
  35. 		$image1='/photos/'.$info['date'].'/'.$info['ref'].$info['piece1'];
  36. 		$image2='/photos/'.$info['date'].'/'.$info['ref'].$info['piece2'];
  37. 		$image3='/photos/'.$info['date'].'/'.$info['ref'].$info['piece3'];
  38. 		$image4='/photos/'.$info['date'].'/'.$info['ref'].$info['piece4'];
  39. 		$image5='/photos/'.$info['date'].'/'.$info['ref'].$info['piece5'];
  40. 		$image6='/photos/'.$info['date'].'/'.$info['ref'].$info['piece6'];
  41. 		$image7='/photos/'.$info['date'].'/'.$info['ref'].$info['piece7'];
  42. 		$image8='/photos/'.$info['date'].'/'.$info['ref'].$info['piece8'];
  43. 		$image9='/photos/'.$info['date'].'/'.$info['ref'].$info['piece9'];
  44. 		$image10='/photos/'.$info['date'].'/'.$info['ref'].$info['piece10'];
  45. 		$image11='/photos/'.$info['date'].'/'.$info['ref'].$info['piece11'];
  46. 		$image12='/photos/'.$info['date'].'/'.$info['ref'].$info['piece12'];
  47. 		$thumb='/photos/'.$info['date'].'/thumbs/'.$info['ref'];
  48.  
  49. 	// ref
  50.  
  51. 		$ref = $info['date'].'-'.$info['ref'];
  52.  
  53. 	// write-up
  54. 		$text=$info['horse'].' ridden by '.$info['rider'];
  55.  
  56. ?>
  57.  
  58.     <tr>
  59.         <td><div id='image1'><img src="<?php echo $image1; ?>"</a></div></td>
  60.         <td><div id='image2'><img src="<?php echo $image2; ?>"</a></div></td>
  61.         <td><div id='image3'><img src="<?php echo $image3; ?>"</a></div></td>
  62.         <td><div id='image4'><img src="<?php echo $image4; ?>"</a></div></td>
  63.     </tr>
  64.  
  65.  
  66.     <tr>
  67.         <td><div id='image5'><img src="<?php echo $image5; ?>"</a></div></td>
  68.         <td><div id='image6'><img src="<?php echo $image6; ?>"</a></div></td>
  69.         <td><div id='image7'><img src="<?php echo $image7; ?>"</a></div></td>
  70.         <td><div id='image8'><img src="<?php echo $image8; ?>"</a></div></td>
  71.     </tr>
  72.  
  73.  
  74.     <tr>
  75.         <td><div id='image9'><img src="<?php echo $image9; ?>"</a></div></td>
  76.         <td><div id='image10'><img src="<?php echo $image10; ?>"</a></div></td>
  77.         <td><div id='image11'><img src="<?php echo $image11; ?>"</a></div></td>
  78.         <td><div id='image12'><img src="<?php echo $image12; ?>"</a></div></td>
  79.     </tr>
  80.  
  81. 		<tr><td><span class="refno">Photo Reference: <?php echo $ref; ?></span></td></tr>
  82. 		<tr><td><span class="infotext"><?php echo $text; ?></td></tr></span>
  83.  
  84. </table>
  85.  
  86. <?php
  87. }  
  88. ?>
  89. </table></body></html>

Problem page: http://www.equinefocus.co.uk/photos/2009-03-21/001.php
Last edited by Borderline; Mar 30th, 2009 at 7:46 am. Reason: Edited to include link to problem page
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2005
Posts: 149
Reputation: sDJh is an unknown quantity at this point 
Solved Threads: 13
sDJh sDJh is offline Offline
Junior Poster

Re: Photo pieces compiled in table

 
0
  #2
Mar 30th, 2009
Umm... not sure. You can try to set "cellspacing=0" and "cellpadding=0" in each <td>. And you have an "</a>" in each field without any opening tag.
http://www.explosive-software.de/?lang=en
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Other Threads in the PHP Forum
Thread Tools Search this Thread



.htaccess alerts apache api archive array autocomplete beginner binary broken cakephp checkbox class cms code convert cron curl database dataentry date display duplicates dynamic echo email emptydisplayvalue error execute explodefunction file files firstoptioninphpdroplist folder form forms function functions google hack href htaccess html htmlspecialchars image include insert ip javasciptvalidation javascript joomla keywords limit link login mail matching menu methods mlm multiple mysql network object oop paypal pdf php problem query radio random recursion recursive redirect remote script search securephp server sessions shot sms source space sql subscription syntax system table tutorial tutorials update upload url validator variable video web youtube
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC