----- Pôvodná správa -----
Od: "Luboslav Gabal ml." <[EMAIL PROTECTED]>
Komu: "Daniel Alsén" <[EMAIL PROTECTED]>; "PHP" <[EMAIL PROTECTED]>
Odoslané: 17. zárí 2001 23:39
Predmet: RE: [PHP] Help with database queries
> > Hi,
> >
> > need some help with the code below. I am thinking of reusing this for
> > building a thumbnail gallery from a database.
> >
> > First, is the code actually good? Do i do something that will slow down
> the
> > responses?
> >
> > Second, can anyone help me with a code sample to implement that will
limit
> > how many records the query is displaying? (break the database response
> into
> > pages)
> >
> > Third, any good ideas on how to do this the easiest way is appreciated
:)
> >
> > Thanks!
> > - Daniel
> >
> >
> > $db = mysql_connect("localhost", "xxx", "xxx");
> >
> > mysql_select_db("xxx",$db);
> >
> > $result = mysql_query("SELECT * FROM film WHERE artnr LIKE '$avd'",$db);
> >
> > if ($myrow = mysql_fetch_array($result)) {
> >
> > echo "<TABLE cellSpacing=3 cellPadding=5 width=600 border=0>\n";
> > echo "<TR><TD><span class='text2'>Art.nr</span></TD>\n";
> > echo "<TD><span class='text2'>Titel</span></TD>\n";
> > echo "<TD><span class='text2'></span></TD></TR>\n";
> >
> > do {
> >
> > printf("<TR><TD bgColor=#efefef><span class='text'>%s</span></TD>
> > <TD bgColor=#efefef><span class='text'><b>%s</b></span></TD>
> > <TD bgColor=#efefef><span class='text'>%smin</span></TD>
> > </TR>\n", $myrow["artnr"], $myrow["titel"], $myrow["dur"]);
>
> use fullstops instead of commas:
>
> printf($myrow["artnr"].$myrow["titel"].$myrow["dur"]);
>
I take it back :-). My mistake ... But the rest is right (I believe :-))
> >
> > } while ($myrow = mysql_fetch_array($result));
> > echo "</table>\n";
> >
> > } else {
> > echo "<span class='text2'>No records available...</span>";
> > }
>
> If you want to limit record outputed at the page, try change mysql query:
>
> SELECT * FROM film WHERE artnr LIKE '$avd' LIMIT 0, 10
>
> where first number is row with record and second is number of getting
> records,
> or you can to use function mysql_data_seek(), which move pointer to
database
> on
> selected row:
>
> mysql_data_seek($result, 10);
>
> this move your internal result pointer to 10. line. Now, when you can
output
> ten next
> lines, you can do it so:
>
> for ($i = 0; $i < 10; $i++) {
> $row = mysql_fetch_array($result);
> echo $row["titel"]; // this outputs you "titel" from 11. row of table
> } // then will be next 9 rows outputed
>
> Luboslav Gabal
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
