CREATE TABLE ab_photo (
id int(10) unsigned NOT NULL auto_increment,
cat varchar(21) default '0',
url varchar(20) default NULL,
source varchar(255) NOT NULL default '',
author varchar(255) default '',
date varchar(255) default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
<?php
mysql_connect('localhost', 'gmarik', 'Photoshop7');
mysql_select_db('art110_appl');
$image_path = "photo/thumbJPG/";
$sql = "SELECT * FROM ab_photo WHERE Cat='photoTheatre' LIMIT 0,16";
$result = mysql_query($sql);
?>
<?
while($row = mysql_fetch_array($result)) {
?>
<body>
<table width="80%" border="0">
<tr>
<td>
<? $row = mysql_fetch_array($result) ?>
<a href="big_photo.php?id=<? echo $row['id'] ?>">
<img src="<? echo $image_path . $row['url'] ?>"> </a>
</td>
<td>
<? $row = mysql_fetch_array($result) ?>
<a href="big_photo.php?id=<? echo $row['id'] ?>">
<img src="<? echo $image_path . $row['url'] ?>"> </a>
</td>
Белый экран. за что - я лишь хотел в каждой ячейке другую фотку из категории photoTheatre?!