Станициране!

users_i · 22 Февруари 2010

Някой ще направи ли това чудо да се страницира знам че е просто но аз не мога

<?php
$sql = mysql_query('SELECT * FROM pic');
while($row = mysql_fetch_assoc($sql))
{
echo '<h3><a href="pic_view.php?id='.$row['pic_id'].'">'.$row['desc'].'</a>';
}

?>

renegat96 · 22 Февруари 2010

http://web-tourist.net/login/login/newsearch.php?wtsearch=n&newsearch=%F1%F2%F0%E0%ED%E8%F6%E8%F0%E0%ED%E5&x=0&y=0
Избери си

users_i · 22 Февруари 2010

Моля те направи го

върху този код

niki_noki · 22 Февруари 2010

Код:

<?php 

$page = (int) $_GET['page']; 

$max= "10"; 

$end = $page+$max;

$sql = mysql_query('SELECT * FROM pic'); 

$run = mysql_query( $sql ); 

while( $row=mysql_fetch_array( $run ) ) 

{ 

echo $row[’field’] ."<br>"; 

} 

$next = $end+1; 

$prev = $page-10; 

while($row = mysql_fetch_assoc($sql)) 
{ 
echo '<h3><a href="pic_view.php?id='.$row['pic_id'].'">'.$row['desc'].'</a>'; 
} 

?>

ТакА?

users_i · 22 Февруари 2010

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\sestrimo\galery.php on line 45

RIP · 22 Февруари 2010

Дай си целия код за да видим къде вади грешка

users_i · 22 Февруари 2010

<?php
session_start();
ob_start();
include 'include/config.php';
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Сестримо - Галерия</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div class="cqlo">
<div id="panels">
<div id="left">
</div>
<div id="r">
<center><img src="images/header.jpg" alt="logo" width="692px" /></center>
</div>
<div name="left">
<div class="left_parvo"></div>
<div class="left_vtoro">
<div class="left1"><a href="index.php"><b>Начало</b></a></div>
<div class="left2"><a href="news.php"><b>Новини</b></a></div>
<div class="left2"><a href="istoriq.php"><b>История</b></a></div>
<div class="left2"><a href="galery.php"><b>Галерия</b></a></div>
<div class="left2"><a href="contact.php"><b>Контакти</b></a></div>
</div></div>
<div class="galery">
<center><a href="sightseeing.php">Забележителности</a> | <a href="geografiq.php">География</a> | <a href="neshty.php">Нещо</a>
<hr color="#ccc"></hr>
<?php
$page = (int) $_GET['page'];

$max= "10";

$end = $page+$max;
$sql = mysql_query("SELECT * FROM pic limit $page,$end"

;
while($row = mysql_fetch_assoc($sql))
{
echo '<h3><a href="pic_view.php?id='.$row['pic_id'].'">'.$row['desc'].'</a>';

$run = mysql_query( $sql );

while( $row=mysql_fetch_array( $run ) )

{

echo $row[`field’] ."<br>";

}

$next = $end+1;

$prev = $page-10;

echo "<a href=\"index.php?page=".$next."\">следваща</a>";
echo "<a href=\"index.php?page=".$prev."\">предишна</a>";

?>
}

?>
</center>
</div>
</div>
<div name="pics">
<div class="pics1"></div>
<div class="pics2">
</div>
</div>
<div class="footer">
</div>
</div>
</body>
</html>

niki_noki · 22 Февруари 2010

Код:

<?php 
session_start(); 
ob_start(); 
include 'include/config.php'; 
?> 
<html xmlns="http://www.w3.org/1999/xhtml"> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 
<title>Сестримо - Галерия</title> 
<link href="style.css" rel="stylesheet" type="text/css" /> 
</head> 
<body> 
<div class="cqlo"> 
<div id="panels"> 
<div id="left"> 
</div> 
<div id="r"> 
<center><img src="images/header.jpg" alt="logo" width="692px" /></center> 
</div> 
<div name="left"> 
<div class="left_parvo"></div> 
<div class="left_vtoro"> 
<div class="left1"><a href="index.php"><b>Начало</b></a></div> 
<div class="left2"><a href="news.php"><b>Новини</b></a></div> 
<div class="left2"><a href="istoriq.php"><b>История</b></a></div> 
<div class="left2"><a href="galery.php"><b>Галерия</b></a></div> 
<div class="left2"><a href="contact.php"><b>Контакти</b></a></div> 
</div></div> 
<div class="galery"> 
<center><a href="sightseeing.php">Забележителности</a> | <a href="geografiq.php">География</a> | <a href="neshty.php">Нещо</a> 
<hr color="#ccc"></hr> 
<?php 
$page = (int) $_GET['page']; 

$max= "10"; 

$end = $page+$max; 
$sql = mysql_query("SELECT * FROM pic limit $page,$end"; 
while($row = mysql_fetch_assoc($sql)) 
{ 
echo '<h3><a href="pic_view.php?id='.$row['pic_id'].'">'.$row['desc'].'</a>'; 

$run = mysql_query( $sql ); 

while( $row=mysql_fetch_array( $run ) ) 

{ 

echo $row['field'] ."<br>"; 

} 

$next = $end+1; 

$prev = $page-10; 

echo "<a href=\"index.php?page=".$next."\">следваща</a>"; 
echo "<a href=\"index.php?page=".$prev."\">предишна</a>"; 

?> 
<?php
} 

?> 
</center> 
</div> 
</div> 
<div name="pics"> 
<div class="pics1"></div> 
<div class="pics2"> 
</div> 
</div> 
<div class="footer"> 
</div> 
</div> 
</body> 
</html>

DeathGuard_ · 22 Февруари 2010

RIP каза:
Дай си целия код за да видим къде вади грешка

За какво ти е целият код още на първо четене се вижда грешка:

<?php

$page = (int) $_GET['page'];

$max= "10";

$end = $page+$max;

$sql = mysql_query('SELECT * FROM pic');

$run = mysql_query( $sql );

while( $row=mysql_fetch_array( $run ) )

{

echo $row[’field’] ."<br>";

}

$next = $end+1;

$prev = $page-10;

while($row = mysql_fetch_assoc($sql))
{
echo '<h3><a href="pic_view.php?id='.$row['pic_id'].'">'.$row['desc'].'</a>';
}

?>

Пробвай така:

Код:

<?php

$page = (int) $_GET['page'];

$max= "10";

$end = $page+$max;

$run = mysql_query('SELECT * FROM pic') or die(mysql_error());

while( $row=mysql_fetch_array( $run ) )

{

echo $row[’field’] ."<br>";

}

$next = $end+1;

$prev = $page-10;

while($row = mysql_fetch_assoc($sql))
{
echo '<h3><a href="pic_view.php?id='.$row['pic_id'].'">'.$row['desc'].'</a>';
}

?>

Станициране!

users_i

Registered

renegat96

Registered

users_i

Registered

niki_noki

Registered

users_i

Registered

RIP

Registered

users_i

Registered

niki_noki

Registered

DeathGuard_

Registered