Image alignment from db

kekke

Hi!

I´m wondering if it´s possible to display a tablelayout depending on alignment of an image.

I will try to explain this in a simple way.

I have a page where I can post items to a page.
I can post with an image.
For the image i can set a sort of value, like "left" or "right".

Is it possible to to make the displaypage output one tablelayout if the image has the value "left" and another tablelayout if it has the value "right"? Some sort of "if else"..

bradgrafelman

You mean, you're storing a "sort" value along with the image?

$query = 'SELECT sort FROM image_table'; // your query here, obviously
$exec = mysql_query($query) or die('MySQL error: ' . mysql_error() );
$sort = mysql_result($exec, 0); // depending on your query, you might have to change this

if($sort == 'left') {

 echo 'your table stuff here...';

} elseif($sort == 'right') {

echo 'your other table stuff here...';

}

kekke

Here is the code for the displaypage.

	<?php

//Koppling till db
		$db = mysql_connect("localhost", "user", "pass");
		mysql_select_db(my_db,$db);

//Ange $path till mappen där bilderna sparas
		$path = "http://www.domain.com/images/";
		$filename = $_FILES['userfile1']['name'];
		$imagelocation = $path.$filename;
//Här anges vad som ska hämtas från db
		$sql = "select * FROM mytable ORDER BY sortorder ASC";
		$result = mysql_query($sql)or die("Technical error, ".mysql_error());
		while ($myrow = mysql_fetch_array($result)) 
{
	printf("<table><tr><td colspan=\"2\"><table><tr><td><B>%s</B></table></td></tr>", $myrow["titel"]);
	if (!empty($myrow['imagelocation'])) {
	printf("<tr><td><img src = '%s'></td>", $myrow["imagelocation"]);
}
	printf("<td><table><tr><td>%s</td>", $myrow["text"]);
	printf("</table></td></tr></table>");
}
?>

kekke

Now I´m out out of ideas. Have tried several things but with no luck.

Anyone?

Rodney_H_

Where are you specifying if the image should align left or align right? Does it have a separate column in your table?

If so, you could easily add a CSS class that would use the attribute assigned to the image to float the image left or right as needed.

for example

echo '<img src="' . $row['img_src'] . " style="float:' . $row['img_float'] . ';" />';

or,

echo '<img src="' . $row['img_src'] . " class="' . $row['img_class'] . '" />';

OR,

echo '<img src="' . $row['img_src'] . " algin="' . $row['img_alignment] . '" />';

But I need to know how you are and what you are storing in your table...

(Basically, this is stating what Brad suggested in another way that you might understand better perhaps... ?)