Php Mysql Datasets Image Files

[dduron]

I can not get turbine to display images via the automovieclip working with datasets as returns from queries with SQL database. Are there any examples to this specifically. I have seen the ones that work with text files. Those have not helped. I have tried even the simplest examples to try and figure out where I am going wrong and can not.

<AutoImage dataSet="IMAGEONE"
defaultSrc=""
dx="default_horizontal_move"
dy="default_vertical_move"
defaultPlacePoint="place_point"
cols="column_number">




<?
# create the turbine object
$turbine = new FlashTurbine();

//$turbine->generateHTMLFirst();
//$turbine->generateHTMLFirst();

# which .swt template file to use:
$turbine->template("../../flash/tfeatPics.swt");

# load the dataset_import.php library
require_once("dataset_import.php");


$query = "SELECT THUMB_LOC FROM PROPERTY_GRAPHICS WHERE PGRAPHIC_ID LIKE 1";

$recordSet = mysql_query($query, $conn);

// import the query results as a Turbine DataSet:
loadDataSetMySQL($turbine, $recordSet, "IMAGEONE");

$turbine->generateFlash();
?>


David.

[jdiogo]

The problem is probably that you're not correctly setting the dx, dy, defaultPlacePoint and cols parameters - you've probably copy&pasted from the command entry on the manual, but the values should be filled - to start, try the following instead:
<AutoImage dataSet="IMAGEONE" dx="100">

You can then expand the command with other parameters as needed. Take care to use the correct columns on the IMAGEONE DataSet, as described on the AutoImage documentation:
docs/datasets.htm#autoimage