Проблем със заяка и странициране.

sentenello

Registered
Здравейте.
В момента заявката ми си работи нормално, но когато сложа в тази заявка.
Код:
$max_results = 20;
$from = (($page * $max_results) - $max_results);
$get = mysql_query("SELECT * from pmessages where touser = '$pmsesusername' order by id desc");
Това.
Код:
 LIMIT $from, $max_results

и кода по надоло ми дава грешка на Num_rows-a

ето тук.
Код:
$nummessages = mysql_num_rows($get);
if ($nummessages == 0)
{
echo ("<center>Нямате съобщения в пощенската кутия!");
}

Давами че няма съобщения и същетвременно, грешка в преброяването на редовете (think)
Някакви препоръки ?
 
значи моята препоръка е такава специално аз след мойте
Код:
		$pp = "5"; 

		$page = $_GET['page'];

	if(!$_GET['page'])
		{ 
		$page = "1"; 
		} 

		$limit = ($pp*$page)-$pp;

		$redove = mysql_query("SELECT * FROM favorites"); 

		$max = mysql_num_rows($redove);
		$total = ceil($max/$pp);
		
		$db = mysql_query("SELECT * FROM users WHERE username='$username'"); 
		while ($r = mysql_fetch_array($db)) {

съм си сложил

още 1

Код:
$id = $r['id']; 
		$usr = $r['username'];
		} 
		$sql = mysql_query("SELECT * FROM favorites WHERE user='$usr' ORDER BY id DESC LIMIT $limit,$pp"); 
		$lesson = mysql_num_rows($sql); 
	if ($lesson > 0) { 
		while ($r = mysql_fetch_array($sql)) { 
		$lesson = $r['lesson']; 
		$sql2 = mysql_query("SELECT * FROM tutorials WHERE id='$lesson' AND active='1'"); 
		while ($r2 = mysql_fetch_array($sql2)) {
 
Оуууукей :)
Ето го и него.

Код:
if(!isset($_GET['page']))
{
$page = 1;
}
else {
$page = intval($_GET['page']);
}
$max_results = 20;
$from = (($page * $max_results) - $max_results);
$get = mysql_query("SELECT * from pmessages where touser = '$pmsesusername' order by id desc LIMIT $from, $max_results");
echo ("
<table bgcolor='#000000' width='100%' align='center'>
<tr>
<td class='inmenu' align='center'width='220px' style='border-right:1px solid #FDD017;'>Заглавие</td>
<td class='inmenu' align='center' width='100px' style='border-right:1px solid #FDD017;'>От</td>
<td class='inmenu' align='center' width='130px' style='border-right:1px solid #FDD017;'>Дата</td>
<td class='inmenu' width='45px' align='center'>Избери</td></tr></table>");
$nummessages = mysql_num_rows($get);
if ($nummessages == 0)
{
echo ("<center>Нямате съобщения в пощенската кутия!");
}
else{
echo("<table class='msgbox' width='100%' align='center'>");
while ($messages = mysql_fetch_array($get))
{...//tuka prodyljava nadolo koeto si raboti ;)
 
if(!isset($_GET['page']))
{
$page = 1;
}
else {
$page = intval($_GET['page']);
}
$max_results = 20;
$from = (($page * $max_results) - $max_results);
$get = mysql_query("SELECT * from pmessages where touser = '$pmsesusername'");
$sql = mysql_query("SELECT *FROM pmessages WHERE touser='$pmsesusername' order by id desc LIMIT $from, $max_results");
echo ("
<table bgcolor='#000000' width='100%' align='center'>
<tr>
<td class='inmenu' align='center'width='220px' style='border-right:1px solid #FDD017;'>Заглавие</td>
<td class='inmenu' align='center' width='100px' style='border-right:1px solid #FDD017;'>От</td>
<td class='inmenu' align='center' width='130px' style='border-right:1px solid #FDD017;'>Дата</td>
<td class='inmenu' width='45px' align='center'>Избери</td></tr></table>");
$nummessages = mysql_num_rows($get);
if ($nummessages == 0)
{
echo ("<center>Нямате съобщения в пощенската кутия!");
}
else{
echo("<table class='msgbox' width='100%' align='center'>");
while ($messages = mysql_fetch_array($get))
{...//tuka prodyljava nadolo koeto si raboti ;)

Така ?
 
Няма да го давам целия, защото ще се оплашиш :)
Ще дам само CASE inbox

Код:
case 'inbox':

$get = mysql_query("SELECT * from pmessages where touser = '$pmsesusername' order by id desc");
echo ("
<table bgcolor='#000000' width='100%' align='center'>
<tr>
<td class='inmenu' align='center'width='220px' style='border-right:1px solid #FDD017;'>Заглавие</td>
<td class='inmenu' align='center' width='100px' style='border-right:1px solid #FDD017;'>От</td>
<td class='inmenu' align='center' width='130px' style='border-right:1px solid #FDD017;'>Дата</td>
<td class='inmenu' width='45px' align='center'>Избери</td></tr></table>");
$nummessages = mysql_num_rows($get);
if ($nummessages == 0)
{
echo ("<center>Нямате съобщения в пощенската кутия!");
}
else{
echo("<form method='POST' style='margin: 0px;'><table class='msgbox' width='100%' align='center'>");
while ($messages = mysql_fetch_array($get))
{
$date = $messages['date'];
	 $date = explode("-", $date);
$date[0] = substr($date[0], 2);
$date = array_reverse($date);
$date = implode(".", $date); 
$messages['time'] = substr( $messages['time'], 0, -3);
$procheteno = $messages['unread'];
if ($procheteno == 'unread'){
$read = bold;
$mailpic = unread;
}else {
$read = normal;
$mailpic = read;
}
echo ("<tr><td width='220px' ><img src='http://www.prognozite.com/game/$mailpic.png' valign='bottom'>  <a href='?page=view&msgid=$messages[id]' style=\"font-weight:$read;\">");
if ($messages[reply] == yes)
{
echo ("Re: ");
}
echo ("$messages[title]</a></td>
<td width='100px' align='center'>$messages[from]</td>
<td width='130px' align='center'><font size=\"1\">$date в $messages[time]</font></td>
<td width='45px' align='center'><input type='checkbox' name='delmsg[".$messages['id']."]'></td>
</tr>");
}
echo ("</table>
<table width='100%'>
<tr>
<td align='right'><input type='submit' name='delmsga' value='Изтрии'>
</td>
</tr>
</table></form>");
}
break;
 
Код:
<?php
case 'inbox': 
	
		$pp = "5"; 

		$page = $_GET['page'];

	if(!$_GET['page'])
		{ 
		$page = "1"; 
		} 

		$limit = ($pp*$page)-$pp;

		$redove = mysql_query("SELECT * FROM pmessages"); 

		$max = mysql_num_rows($redove);
		$total = ceil($max/$pp);

$get = mysql_query("SELECT * from pmessages where touser = '$pmsesusername' order by id desc LIMIT $limit, $pp"); 
echo (" 
<table bgcolor='#000000' width='100%' align='center'> 
<tr> 
<td class='inmenu' align='center'width='220px' style='border-right:1px solid #FDD017;'>Заглавие</td> 
<td class='inmenu' align='center' width='100px' style='border-right:1px solid #FDD017;'>От</td> 
<td class='inmenu' align='center' width='130px' style='border-right:1px solid #FDD017;'>Дата</td> 
<td class='inmenu' width='45px' align='center'>Избери</td></tr></table>"); 
$nummessages = mysql_num_rows($get); 
if ($nummessages == 0) 
{ 
echo ("<center>Нямате съобщения в пощенската кутия!"); 
} 
else{ 
echo("<form method='POST' style='margin: 0px;'><table class='msgbox' width='100%' align='center'>"); 
while ($messages = mysql_fetch_array($get)) 
{ 
$date = $messages['date']; 
    $date = explode("-", $date); 
$date[0] = substr($date[0], 2); 
$date = array_reverse($date); 
$date = implode(".", $date); 
$messages['time'] = substr( $messages['time'], 0, -3); 
$procheteno = $messages['unread']; 
if ($procheteno == 'unread'){ 
$read = bold; 
$mailpic = unread; 
}else { 
$read = normal; 
$mailpic = read; 
} 
echo ("<tr><td width='220px' ><img src='http://www.prognozite.com/game/$mailpic.png' valign='bottom'>  <a href='?page=view&msgid=$messages[id]' style=\"font-weight:$read;\">"); 
if ($messages[reply] == yes) 
{ 
echo ("Re: "); 
} 
echo ("$messages[title]</a></td> 
<td width='100px' align='center'>$messages[from]</td> 
<td width='130px' align='center'><font size=\"1\">$date в $messages[time]</font></td> 
<td width='45px' align='center'><input type='checkbox' name='delmsg[".$messages['id']."]'></td> 
</tr>"); 
} 
echo ("</table> 
<table width='100%'> 
<tr> 
<td align='right'><input type='submit' name='delmsga' value='Изтрии'> 
</td> 
</tr> 
</table></form>"); 
} 
break;
?>

Така ? опитвам се ама ... :D
 
Същата работа като при мойте опити.
Код:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/progn0zi/public_html/game/messages.php on line 100
 
още 1 пат ще се обитам :)

Код:
<?php
case 'inbox': 
	
		$pp = "5"; 

		$page = $_GET['page'];

	if(!$_GET['page'])
		{ 
		$page = "1"; 
		} 

		$limit = ($pp*$page)-$pp;

		$redove = mysql_query("SELECT * FROM pmessages"); 

		$max = mysql_num_rows($redove);
		$total = ceil($max/$pp);

$get = mysql_query("SELECT * from pmessages where touser = '$pmsesusername' order by id desc LIMIT $limit, $pp"); 
$sql = mysql_query("SELECT * FROM pmessages where tousr = '$pmsesusername'");
echo (" 
<table bgcolor='#000000' width='100%' align='center'> 
<tr> 
<td class='inmenu' align='center'width='220px' style='border-right:1px solid #FDD017;'>Заглавие</td> 
<td class='inmenu' align='center' width='100px' style='border-right:1px solid #FDD017;'>От</td> 
<td class='inmenu' align='center' width='130px' style='border-right:1px solid #FDD017;'>Дата</td> 
<td class='inmenu' width='45px' align='center'>Избери</td></tr></table>"); 
$nummessages = mysql_num_rows($sql); 
if ($nummessages == 0) 
{ 
echo ("<center>Нямате съобщения в пощенската кутия!"); 
} 
else{ 
echo("<form method='POST' style='margin: 0px;'><table class='msgbox' width='100%' align='center'>"); 
while ($messages = mysql_fetch_array($get)) 
{ 
$date = $messages['date']; 
    $date = explode("-", $date); 
$date[0] = substr($date[0], 2); 
$date = array_reverse($date); 
$date = implode(".", $date); 
$messages['time'] = substr( $messages['time'], 0, -3); 
$procheteno = $messages['unread']; 
if ($procheteno == 'unread'){ 
$read = bold; 
$mailpic = unread; 
}else { 
$read = normal; 
$mailpic = read; 
} 
echo ("<tr><td width='220px' ><img src='http://www.prognozite.com/game/$mailpic.png' valign='bottom'>  <a href='?page=view&msgid=$messages[id]' style=\"font-weight:$read;\">"); 
if ($messages[reply] == yes) 
{ 
echo ("Re: "); 
} 
echo ("$messages[title]</a></td> 
<td width='100px' align='center'>$messages[from]</td> 
<td width='130px' align='center'><font size=\"1\">$date в $messages[time]</font></td> 
<td width='45px' align='center'><input type='checkbox' name='delmsg[".$messages['id']."]'></td> 
</tr>"); 
} 
echo ("</table> 
<table width='100%'> 
<tr> 
<td align='right'><input type='submit' name='delmsga' value='Изтрии'> 
</td> 
</tr> 
</table></form>"); 
} 
break;
?>
 
Отново същата работа. Имам идея обаче.
След малко ще се опитам да направя една заявка отделна от която само да се броя редовете, а от друга да се прави страницинирането. Подобно на това което ти опита първия път.
 

Back
Горе