PHP/SQL display image problem

pascal72

I have some problems with displaying a number of random images to my website. The images should be randomly taken out of a sql database and via ssi (or something else) displayed. In the database collum "image" the url's are listed. Further more i need to exlude empty cells, and some images. (http://www.yourdomain/image.jpg etc) The script seems to work fine, but does not display anything. Can someone please have a look ? I would be so gratefull

Database Definitions

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

Default Connection String

$connection = mysql_connect($dbhost, $dbuser, $dbpass) or die ("Unable to connect to MySQL server." . mysql_error());
$db = mysql_select_db($dbname, $connection) or die ("Unable to select database: " . mysql_error());

Further MySQL Info

// Name of the table you wish to get random items out of

$randtable = "image";

ATTENTION - IMPORTANT TABLE INFO

The table you use MUST have an "id" field - this is

how the generator knows how to pick a random item!

Please assign the name of the id field (usually just "id")

$idvar = "id";

If using your own table, please edit a few variables below

Make a query to draw the records from the table

$randsql_result = mysql_query("SELECT image FROM searchidx",$connection) or die ('Database Query Failed. Please
check the $randtable variable under Further MySQL Info, and make sure you have the correct table name.');
if(mysql_num_rows($randsql_result) == 0) {
print "There are no entries in the database!<br>Please insert entries so a random one can be picked!"; exit; }

Load entries into an array to select one randomly

$i = 0;
while($row = mysql_fetch_row($randsql_result)) {
$rand[$i] = $row[0];
$i++;
}
mysql_free_result($randsql_result);

Select a random entry from the assembled array

$randnum = array_rand($rand);

$rst = mysql_query("SELECT id FROM searchidx WHERE $idvar = '$rand[$randnum]' LIMIT 1", $connection) or die('Could not retrieve random entry from databse. Please check the $idvar variable under IMPORTANT TABLE INFO to make sure the id field is correct');
$q = mysql_fetch_array($rst);

You may have to EDIT these output variables if you did not use the example table above.

The text inside the brackets is the name of the COLUMN in the table you wish to display.

print "<i>$q[image]</i><br>- $q[author]";

Webmaster Camchoice.com

stolzyboy

just a thought, but have you thought of using the rand() function of mysql so you don't have to do all that other random stuff

pascal72

Donno stolz, a snippet of a script does not work for me , i am kind of a newbie, but a quick learner.
I have following now, but it doesnt work ? Anyone ?

It does not display anthing , i tried to put it here : http://www.camchoice.com/randompic.php , with no result

Database Definitions

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

Default Connection String

$cat = "image";

function get_total($cat, $db) {

  mysql_select_db($db);

  $sql = "SELECT count(*)AS total FROM searchidx WHERE cat_id = '$cat'";

if(!$result = mysql_query($sql)) {

 return("ERROR: MYSQL [QUERY] ERROR");

}

if(!$myrow = mysql_fetch_array($result)) {

 return("0");

} else {

return($myrow['total']);

}
}

if (isset($_GET['cat'])) {

$cat = $_GET['cat'];

} else { // no GET METHOD [cat] (VALUE)

// assign a default one [cat = (VALUE)]

$cat = "image";

}

$total = get_total($cat, $db);

if (preg_match("/[0-9]/", $total)) {

if ($total > 0) {

$sql = "SELECT * FROM images WHERE cat_id = '$cat' ORDER BY RAND() LIMIT 1";

if (!$result = mysql_query($sql)) {

// return a sql error or do (something else [error related])

} else { // if no sql query error was returned

// convert the results

$img = mysql_fetch_array($result);

// should use strip/add_slashes (ALWAYS)

$path = $img[img_path];

$name = $img[img_name];

$height = $img[img_height];

$size = $img[img_size];

$by = $img[img_by];

$date = $img[img_date];

// show the random image/info result!

echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"400\">\n";
echo "<tr><td class=\"title\" width=\"400\">Created By: ".$by."</td></tr>\n";
echo "<tr><td class=\"title\" width=\"400\">Date Added: ".$date."</td></tr>\n";
echo "<tr><td class=\"title\" width=\"400\">Image Size: ".$size."</td></tr>\n";
echo "<tr><td class=\"title\" width=\"400\">Image Name: ".$name."</td></tr>\n";
echo "<tr><td class=\"img\" width=\"400\">";
echo "<img src=\"".$path."/".$name."\" HEIGHT=\"".$height."\" WIDTH=\"".$width."\" TITLE=\"".$name." (SIZE: ".$size.")\"></td></tr>\n";
echo "</table>\n";
}

} else { // if total not greater than [0] (NO [DB RESULTS])

// no images found for this catagory

}

} else { // get_total() did not return a [numeric value]

// return the sql error or do (something else [error related])

}