Originally posted by arquint
I've a big question!
- Question:
Can I upload more than one image at the same time in a MySQL database? Like an uploadarray or some thing like that.
- Question:
I've a script to get images out from a MySQL database. But, I like to format the output in a spezial way and i don't know how.
I'd like to view 10 images for the first line and the next 10 images for the secound line and so far...
I've tried somthing with a DO...WHILE and FOR but it doesn't work.
Please help!
Andy [/B]
I don't understand quest 1.
but #2 use the LIMIT option in your select statement
eg:
$q=mysql_query("SELECT FROM table LIMIT $top,10");
This limits each view to 10 & you can change $top with a previos,next,jump, etc....
I like using :
<?php
Begining of script somewhere
if ($action =='Previuos') {
$top=($pg>0) ? $pg-10; 1;
}
if ($action =='Next') {
$top=($pg<$NUMITEMS1) ? $pg+10; 1;
}
$q=mysql_query("SELECT FROM table LIMIT $top,10");
Blah ......
?>
<!-- Somewhere in code.... -->
<INPUT TYPE="SUBMIT" NAME="action" Value="Previous">
