[bayside]

Iam new to PHP and SQL so forgive my ignorance - have to start somewhere!

Iam experimenting with a script that can be used on an art gallery site. I can pull specific thumbnails based on artist from the database, but can not configure HTML to show results using colspan.

Effectively I need to output 3 columns, 5 deep - here is what I have that spits out one vertical column!

Any reference to a good source for HTML presentation of PHP would really help!

Dave
--------------------------------------------------------------------

<?PHP
if(mysql_connect('localhost', 'root', 'password' )){
print("Welcome To Syd Entel Galleries");
}else{
print("connection failed");
}



if (! @mysql_select_db( 'SydEntelArtwork' ) ) {
die( '<p>Unable to locate the Artwork ' .
'Database at this time.</p>' );
}

?>

<p> Here are works by Anton Arkhipov</p>

<?php

$result = @mysql_query(
'SELECT ArtThumb
FROM Artwork
WHERE AID=1' );

if (!$result) {
die( '<p>Error performing query: ' . mysql_error() .
'</p>' );
}
while ( $row = mysql_fetch_array($result) ) {
echo( '<p>' . $row[ 'ArtThumb' ] . '</p>' );
}

?>

[Lost]

Are you trying to output the art gallery in an HTML table?

[bayside]

Originally Posted by Lost

Are you trying to output the art gallery in an HTML table?

Yes, and place the results in the following configuration:

<table>
<tr>
<td colspan=4 align=center valign=bottom>
[rresult 1]</td>
<td>[result 2]</td>
<td>[result 3]</td>
<td>[result 4]</td></tr>
<tr>

<---This should repeat the above until all pix are shown--->

The other way I could display would be in 4 columns if that would be easier to configure.

Thanks for any help you can provide!

[Lost]

Try this...


<?php

$dbhost = "localhost";
$dbuser = "dbuser";
$dbpass = "dbpass";
$dbname = "dbname";

mysql_connect($dbhost,$dbuser,$dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());

echo "Welcome To Syd Entel Galleries<br><p>Here are works by Anton Arkhipov</p>";

$artthumbs = mysql_query("select ArtThumb from Artwork where aid='1'") or die(mysql_error());

$i = 0;
echo "<table><tr>";
while($thumb=mysql_fetch_array($artthumbs))
{
$i++;
echo "<td>$thumb[ArtThumb]</td>";
if($i%4 == 0)
{
echo "</tr><tr>";
}
}
echo "</tr></table>";

?>

[bayside]

[QUOTE=Lost]Try this...

That worked great!
All I need to do is mess around with the table widths and spacing within this, but otherwise it worked!

Many thanks! Do you know of anywhere I can find html contend structure like this for PHP??

Dave

[bayside]

[QUOTE=Lost]Try this...


Here's what I have managed to produce thus far:

http://sydentelgalleries.com/test.php

Now the big question!! How do I add a name for each image and create a link for it as well?????

In HTML, here is what it shoud be.

http://sydentelgalleries.com/arkhipov.html

[Lost]

Hmmm...do you have a table in your database to store the artists? Or are you just remembering which 'aid' number goes to which artist?