[SOLVED] $sql = 'SELECT ['id', 'imgpath'] FROM thumb';

[y2yang]

Is this correct?

 

$sql = 'SELECT ['id', 'imgpath'] FROM thumb';

 

How do you select id and imgpath from mysql?

[Maq]

$sql = "SELECT id, imgpath FROM thumb";

 

 

EDIT: Are you referring to using an array in your query?  Or are 'id' and 'imgpath' fields in your DB?  This is also assuming you are using MySQL.

[law]

Unless you are trying to make a real fancy gallery you could always just dump all the pictures into one directory and increment the names of the photos. (fotosizer does a great job of that set it to photo%n not images%n. I have seen a bug that adds random spaces on images%n and makes it impossible to call from php.)

 

<code>

<?php

$thumbs = "./gallery/thumbs/"

$images = "./gallery/images/"

$num_img = 52;

for ($i=0,$i <= $num_img, $i++){

?>

<img src="<?php echo $thumbs."photo".$i;?>" alt = ""/>

<img src="<?php echo $images."photo".$i;?>" alt = ""/>

<?php

}

?>

</code>

 

*disclaimer: I wrote this in the quick reply box. I have not ran this or debugged it. I just was throwing out another option. You can also implement pagination on something like this script to create several galleries from the same code.*

[Maq]

Please use

tags, not with .