Изкарване на клипчета

M

Martowe

Registered
Как може да се направи да искарва само 5 или 10 клипа не повече :?
това е кода

Код: 
<?php
include"conf.php";
$pp = "5";
//eeei?aoa ia no?aieoa
$table = "clips";

$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table "),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);


echo"<table align=\"center\" border=\"0\">";

$i="0";
$nared="5";
$query="SELECT * FROM $table ORDER BY id";
$result=mysql_query($query);
while ( $r = mysql_fetch_array( $result )){
$i++;
$width=ceil(100/$nared);
$ime=$r[ime];
$pic=$r[pic];
$klik=$r[klik];
if (strlen($ime)>16)
{$t='...';}
$ime = substr($ime,0,16);
echo"<td width=\"130\" align=\"center\" border=\"1\" background=\"images/b.gif\">
<a href=\"view.php?id=$r[id]\" onmouseover=\"return overlib('$r[ime]')\" onmouseout=\"return nd();\"><img src=\"$pic\" border=\"0\" width=\"50\" height=\"50\"></div><br><b>$ime$t</a>";
if ($i==$nared)
{
echo "</tr>
<tr>";
$i=0;
}
}
echo"</table>"; ?>
 
Martowe каза:
Как може да се направи да искарва само 5 или 10 клипа не повече :?
това е кода

Код: 
<?php
include"conf.php";
$pp = "5";
//eeei?aoa ia no?aieoa
$table = "clips";

$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table "),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);


echo"<table align="center" border="0">";

$i="0";
$nared="5";
$query="SELECT * FROM $table ORDER BY id [b]LIMIT 10[/b]";
$result=mysql_query($query);
while ( $r = mysql_fetch_array( $result )){
$i++;
$width=ceil(100/$nared);
$ime=$r[ime];
$pic=$r[pic];
$klik=$r[klik];
if (strlen($ime)>16)
{$t='...';}
$ime = substr($ime,0,16);
echo"<td width="130" align="center" border="1" background="images/b.gif">
<a href="view.php?id=$r[id]" onmouseover="return overlib('$r[ime]')" onmouseout="return nd();"><img src="$pic" border="0" width="50" height="50"></div><br><b>$ime$t</a>";
if ($i==$nared)
{
echo "</tr>
<tr>";
$i=0;
}
}
echo"</table>"; ?>
Увеличете...
 
Dizasterr каза:
Martowe каза:
Как може да се направи да искарва само 5 или 10 клипа не повече :?
това е кода

Код: 
<?php
include"conf.php";
$pp = "5";
//eeei?aoa ia no?aieoa
$table = "clips";

$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table "),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);


echo"<table align="center" border="0">";

$i="0";
$nared="5";
$query="SELECT * FROM $table ORDER BY id [b]LIMIT 10[/b]";
$result=mysql_query($query);
while ( $r = mysql_fetch_array( $result )){
$i++;
$width=ceil(100/$nared);
$ime=$r[ime];
$pic=$r[pic];
$klik=$r[klik];
if (strlen($ime)>16)
{$t='...';}
$ime = substr($ime,0,16);
echo"<td width="130" align="center" border="1" background="images/b.gif">
<a href="view.php?id=$r[id]" onmouseover="return overlib('$r[ime]')" onmouseout="return nd();"><img src="$pic" border="0" width="50" height="50"></div><br><b>$ime$t</a>";
if ($i==$nared)
{
echo "</tr>
<tr>";
$i=0;
}
}
echo"</table>"; ?>
Увеличете...
Увеличете...


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\Program Files\VertrigoServ\www\index.php on line 175
 
Martowe каза:
Dizasterr каза:
Martowe каза:
Как може да се направи да искарва само 5 или 10 клипа не повече :?
това е кода

Код: 
<?php
include"conf.php";
$pp = "5";
//eeei?aoa ia no?aieoa
$table = "clips";

$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table "),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);


echo"<table align="center" border="0">";

$i="0";
$nared="5";
$query="SELECT * FROM $table ORDER BY id LIMIT 10";
$result=mysql_query($query);
while ( $r = mysql_fetch_array( $result )){
$i++;
$width=ceil(100/$nared);
$ime=$r[ime];
$pic=$r[pic];
$klik=$r[klik];
if (strlen($ime)>16)
{$t='...';}
$ime = substr($ime,0,16);
echo"<td width="130" align="center" border="1" background="images/b.gif">
<a href="view.php?id=$r[id]" onmouseover="return overlib('$r[ime]')" onmouseout="return nd();"><img src="$pic" border="0" width="50" height="50"></div><br><b>$ime$t</a>";
if ($i==$nared)
{
echo "</tr>
<tr>";
$i=0;
}
}
echo"</table>"; ?>
Увеличете...
Увеличете...


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\Program Files\VertrigoServ\www\index.php on line 175
Увеличете...
Я пробвай сега.
 
Код: 
	<?php
include"conf.php";
$pp = "10";
//eeei?aoa ia no?aieoa
$table = "clips";

$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table "),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);


echo"<table align=\"center\" border=\"0\">";

$i="0";
$nared="10";
$query="SELECT * FROM $table ORDER BY id LIMIT 10";
$result=mysql_query($query);
while ( $r = mysql_fetch_array( $result )){
$i++;
$width=ceil(100/$nared);
$ime=$r[ime];
$pic=$r[pic];
$klik=$r[klik];
if (strlen($ime)>16)
{$t='...';}
$ime = substr($ime,0,16);
echo"<td width=\"130\" align=\"center\" border=\"1\" background=\"images/b.gif\">
<a href=\"view.php?id=$r[id]\" onmouseover=\"return overlib('$r[ime]')\" onmouseout=\"return nd();\"><img src=\"$pic\" border=\"0\" width=\"50\" height=\"50\"></div><br><b>$ime$t</a>";
if ($i==$nared)
{
echo "</tr>
<tr>";
$i=0;
}
}
echo"</table>"; ?>
Заповядай :)
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе