Trying to create Photobook

Anon

Hi,

I am tryin to create a Photobook with MSSQL and PHP.

I can get the information out of the database using the following script, but Photo, is displayed as an URL and not as the pricture itself.
Also everything is dislpayed on 1 long line (multiple with Word Wrap). But how can i make it look really nice?

Some help would be really usefull!

Regards,

Arnoud.

[script]:

<head>
    <title>Test</title>
</head>
<body>

<?php
$hostname = "localhost";
$username = "root";
$password = "root";
$dbName = "Intranet";

// Maak verbinding met server
MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO RESPOND.");

// Selecteer database
mssql_select_db($dbName) or DIE ("Table unavailable");

$sql = "SELECT * FROM Photobook";
$query = mssql_query($sql);
for ($i = 0; $i < mssql_num_rows($query); $i++) {

$list = mssql_fetch_assoc($query);

echo $list['recordno'];
echo $list['First Name'];
echo $list['Surname'];
echo $list['Position'];
echo $list['Team_Disc'];
echo $list['Office'];
echo $list['Email'];
echo $list['Street'];
echo $list['Zipcode_Residence'];
echo $list['Country'];
echo $list['Home Telephone'];
echo $list['Mobile Phone'];
echo $list['DOB'];
echo $list['Private Email'];
echo $list['Private Website'];
echo $list['Photo'];
}
?>

</body>

stuartc1

First to diaplay the image you need to use:

Second if you want to add a space between each entry, you need to ech it like this:

echo $list['Something']."<BR>";

You may be better creating a static page first with the look you want and just adding the dynamic bit to that.

:->

jayrod_84

Some example code

    if(!isset($imagepointer)){$imagepointer = 1;}
    $query = "select * from album  where img_id = '$imagepointer'";
    $result = mysql_query($query) or die("query farked");
    $row = mysql_fetch_array($result, MYSQL_ASSOC);

basically create a table with file names of the images and then go through the DB with an index to display the pics.

I also have an example script that I used to read the contents of a dir and update a DB.

I updated 180 pictures at once this way