Combining Code for Previous and Next Links

[dcjones]

Hi all,

I have found this code on here which will fit my requirements:

$nrows = count($dbresult);

if($nrows <= $offset+$limit) {
    $to = $nrows-1;
} else {
    $to = $offset+$limit-1;
}

$from = $offset;

foreach (range($from, $to) as $rownum) {
    $row = $dbresult[$rownum];
    if(!empty($row)) {
        // do row display stuff here
    }
}

$numpages=ceil($nrows/$limit);

if($numpages > 1) {
    $pagebits = "Page: ";
    for ($i=0;$i<$numpages;$i++) { 
        $newoffset=$limit*($i);
        $pg = $i + 1;
        if($page == $pg) {
            $pagebits .= "<b>$pg</b>&nbsp;";
        } else {
            $pagebits .= "<a href=\"$PHP_SELF?offset=$newoffset&limit=$limit&page=$pg\">$pg</a>&nbsp;";
        }
    } 
    if($offset>1) { 
        $prevoffset = $offset - $limit;
        $prevpage = $page - 1;
        $previous = "<a href=\"$PHP_SELF?offset=$prevoffset&limit=$limit&page=$prevpage\">Previous $limit results</a> "; 
    } else {
        $previous = "&nbsp;";
    }
    if($nrows>($offset+$limit)) { 
        $nextoffset = $offset + $limit;
        $nextpage = $page + 1;
        $next = "<a href=\"$PHP_SELF?offset=$nextoffset&limit=$limit&page=$nextpage\">Next $limit results</a>"; 
    } else {
        $next = "&nbsp;";
    } 
}

This is the code I am working with:

$query = "select id, location, name, county, rating, tariff from accom where acctype = 'H' order by rating limit 10";

if (!($connection = @ mysql_connect($server,
$user,
$password)))
die("Cannot connect");

if (!(mysql_select_db("db66511019", $connection)))
showerror();

// Run the query on the connection
if (!($result = @ mysql_query ($query, $connection)))
showerror();
while ($row = mysql_fetch_array($result))
?>
<td align="left" background=\"../../Gif/Background.gif\"><font color="black\" face="arial\"size="-6">
<a href=\"accomodation/php/ac.php?idname=<? echo urlencode($row["name"]).">".$row["name"] ?></a></td>
<?
"\n\t";

 echo "<td align=\"left\" background=\"../../Gif/Background.gif\"><font color=\"black\" face=\"arial\"size=\"-6\" >" .
 $row["location"] . 
 "\n\t";
 echo "<td align=\"left\"background=\"../../Gif/Background.gif\"><font color=\"black\" face=\"arial\"size=\"-6\" >" .
 $row["county"] .
 "\n\t";
  if ($row["rating"] == "1")
echo "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var1."\"</td>";
         elseif ($row["rating"] == "2")
echo "\n\t<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var2."\"</td>";
        elseif ($row["rating"] == "3")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var3."\"</td>";
       elseif ($row["rating"] == "4")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var4."\"</td>";
          elseif ($row["rating"] == "5")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var5."\"</td>";
"\n\t";

  if ($row["tariff"] == "1")
echo "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar1."\"</td>";
         elseif ($row["tariff"] == "2")
echo "\n\t<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar2."\"</td>";
        elseif ($row["tariff"] == "3")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar3."\"</td>";
       elseif ($row["tariff"] == "4")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar4."\"</td>";
          elseif ($row["tariff"] == "5")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar5."\"</td>";

echo	"</tr>";

    // Finish the row
   echo "\n</tr>";

QUESTION: How and where do I use the code for creating my PREVIOUS and NEXT links

I have been playing with this over the weekend (sad I know) without any success.

Thanks in advance

DCJ

[bernouli]

are you going to code like this
back 1 2 3 4 5 next

then see this link

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10211349

[dcjones]

Hi there, and thanks for your pointer to the code. I have inserted the code into my script, I think I have put it in the right places.

But the script shows the following error:

Parse error: parse error in /homepages/41/d43000764/htdocs/TraveltoEngland/Accomodation/PHP/hot.php on line 104

LINE 89 $query = "select id, location, name, county, rating, tariff from accom where acctype = 'H' order by rating limit 10";

LINE 90 if (!($connection = @ mysql_connect($server,
LINE 91 $user,
LINE 92 $password)))
LINE 93 die("Cannot connect");

LINE 94 if (!(mysql_select_db("db66511019", $connection)))
LINE 95 showerror();

LINE 96 // Run the query on the connection
LINE 87 if (!($result = @ mysql_query ($query, $connection)))
LINE 98 showerror();

LINE 99 $step = $diff = 10;
LINE 100 $offset=HTTP_POST_VARS['offset'];
LINE 101 $r = mysql_query("SELECT count(*) FROM accom ") or die(mysql_error());

LINE 102 $anz = mysql_result($r,0);
LINE 103 if ($offset+$diff>=$anz) {
LINE 104 $diff = $anz - $offset;
LINE 105 $vor = TRUE;
LINE 106}

LINE 107if (!$offset || $offset<0) {
LINE 108 $offset = 0;
LINE 109 $zur = TRUE;
LINE 110 }
LINE 111 $result=mysql("$DBName","SELECT * FROM accom ORDER BY ItemName LIMIT $offset,$diff");

Can you see the problem,

many thanks

DCJ

[bernouli]

ok, first i don't think you need the LINE 100, you can put it away, since you are not using the latest php

and LINE 101 try putting ; after the sql query

[dcjones]

Hi and thanks again.

The code looks like this

$query = "select id, location, name, county, rating, tariff from accom where acctype = 'H' order by rating limit 10";
if (!($connection = @ mysql_connect($server,
$user,
$password)))
die("Cannot connect");
if (!(mysql_select_db("db66511019", $connection)))
showerror();
// Run the query on the connection
if (!($result = @ mysql_query ($query, $connection)))
showerror();
$step = $diff = 10;

$r = mysql_query("SELECT count() FROM accom ") or die(mysql_error());
$anz = mysql_result($r,0);
if ($offset+$diff>=$anz) {
$diff = $anz - $offset;
$vor = TRUE;
}
if (!$offset || $offset<0) {
$offset = 0;
$zur = TRUE;
}
$result=mysql("$DBName","SELECT FROM accom ORDER BY Name LIMIT $offset,$diff");

// Start a table, with column headers
echo "\n<table width=\"500\" border=\"0\" cellpadding=\"2\" cellspacing\"1\">" .
"\n\t<td width=\"30%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" >Name</td>" .
"\n\t<td width=\"25%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" face=\"airal\">Location</td>" .
"\n\t<td width=\"16%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" >County</td>" .
"\n\t<td width=\"16%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" >Rating</td>" .
"\n\t<td width=\"16%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" >Tariff</td>" .
"\n</tr>";

 // Until there are no rows in the result set,
 // fetch a row into the $row array and ...

IT IS NOW SHOWING THE FOLLOING ERROR HERE:

Warning: Supplied argument is not a valid MySQL result resource in /homepages/41/d43000764/htdocs/TraveltoEngland/Accomodation/PHP/hot.php on line 137

THIS IS LINE 137 while ($row = mysql_fetch_array($result))

 {
    // ... start a TABLE row ...
 echo "\n<tr>";  


?>
      <td align="left" background=\"../../Gif/Background.gif\"><font color="black\" face="arial\"size="-6"> 
        <a href=\"accomodation/php/ac.php?idname=<? echo urlencode($row["name"]).">".$row["name"] ?></a></td>
      <?

"\n\t";

 echo "<td align=\"left\" background=\"../../Gif/Background.gif\"><font color=\"black\" face=\"arial\"size=\"-6\" >" .
 $row["location"] . 
 "\n\t";
 echo "<td align=\"left\"background=\"../../Gif/Background.gif\"><font color=\"black\" face=\"arial\"size=\"-6\" >" .
 $row["county"] .
 "\n\t";
  if ($row["rating"] == "1")
echo "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var1."\"</td>";
         elseif ($row["rating"] == "2")
echo "\n\t<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var2."\"</td>";
        elseif ($row["rating"] == "3")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var3."\"</td>";
       elseif ($row["rating"] == "4")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var4."\"</td>";
          elseif ($row["rating"] == "5")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var5."\"</td>";
"\n\t";

  if ($row["tariff"] == "1")
echo "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar1."\"</td>";
         elseif ($row["tariff"] == "2")
echo "\n\t<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar2."\"</td>";
        elseif ($row["tariff"] == "3")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar3."\"</td>";
       elseif ($row["tariff"] == "4")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar4."\"</td>";
          elseif ($row["tariff"] == "5")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar5."\"</td>";

echo	"</tr>";

    // Finish the row
   echo "\n</tr>";
 }

if ($zur != TRUE) echo '<a href="'.$PHP_SELF.'?acctype='.$CA.'&offset='.($offset-$step) . '&UID='.$UID.' ">Back </a> ';
for ($i=1;$i<=(int)ceil($anz/$step);$i++) echo '<a href="'.$PHP_SELF.'?acctype'.$CA.'&offset='.(($i-1)*$step). '&UID='.$UID. '" > '.$i.'</a> ';

if ($vor != TRUE) echo '<a href="'.$PHP_SELF.'?acctype'.$CA.'&offset='.($offset+$step). '&UID='.$UID.'">next</a>';

any thoughts.

regards

DCJ

[bernouli]

replace

$result=mysql("$DBName","SELECT * FROM accom ORDER BY Name LIMIT $offset,$diff"); 

with

$result=mysql_query("SELECT * FROM accom ORDER BY Name LIMIT $offset,$diff"); 

[dcjones]

N $query = "select id, location, name, county, rating, tariff from accom where acctype = 'H' order by rating limit 10";
if (!($connection = @ mysql_connect($server,
$user,
$password)))
die("Cannot connect");
if (!(mysql_select_db("db66511019", $connection)))
showerror();
// Run the query on the connection
if (!($result = @ mysql_query ($query, $connection)))
showerror();
$step = $diff = 10;

$r = mysql_query("SELECT count() FROM accom ") or die(mysql_error());
$anz = mysql_result($r,0);
if ($offset+$diff>=$anz) {
$diff = $anz - $offset;
$vor = TRUE;
}
if (!$offset || $offset<0) {
$offset = 0;
$zur = TRUE;
}
LINE 111 $result=mysql_query("$DBName","SELECT FROM accom ORDER BY Name LIMIT $offset,$diff");ow I have this

I am still getting the error
Warning: Supplied argument is not a valid MySQL result resource in /homepages/41/d43000764/htdocs/TraveltoEngland/Accomodation/PHP/hot.php on line 137

AND
Warning: Supplied argument is not a valid MySQL-Link resource in /homepages/41/d43000764/htdocs/TraveltoEngland/Accomodation/PHP/hot.php on line 111

I have marked line 111 above

DCJ

[dcjones]

Hi there again, I hope your not getting fed up with me.

Here is the complete page:

I must confess, I am not even sure what to do with the last past of the script where the <a href > bits are. I am sorry to bother you so much

Thanks for your help

DCJ

<html>
<head>
<STYLE>
<!--
A{text-decoration:none}
-->
</STYLE>
<title>Hotels</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript">
<!--
function openpopup(){
var popurl="../../legend.htm"
winpops=window.open(popurl,"","width=500,height=338,scrollbars,")
}

function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}
}

function MM_findObj(n, d) { //v4.0
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);
if(!x && document.getElementById) x=document.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
<body background="../../Gif/Background.gif" onLoad="MM_preloadImages('../../Gif/HandR.gif')">
<table width="100%" height="100%">
<tr>
<td align="center" valign="top">

  <table width="500" border="0" align="center">
    <tr> 
      <td colspan="2"> <font color="#990000" size="-1"><a href="../Accom.htm" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('handl','','../../Gif/HandR.gif',1)"><img name="handl" border="0" src="../../Gif/HandG.gif" width="35" height="12"></a>Accomodation</font> 
    </tr>
    <tr> 
      <td colspan="2"> 
        <div align="left"></div>
      </tr>
    <tr>
      <td colspan="2">
        <div align="center"><font color="#990000" size="-1">Warwickshire Guest 
          Houses</font></div>

    </tr>
    <tr> 
      <td colspan="2" height="10">&nbsp; 
    </tr>
    <tr> 
      <td height="17">&nbsp; 
      <td width="153" height="17"> 
        <div align="left"><a href="javascript:openpopup()"><font size="-1">symbols</font></a> 
        </div>
      </tr>
    <tr> 
      <td colspan="2"> 
        <?php

include 'error.inc';
include 'db.inc';

$var1 = rose2.gif;
$var2 = rose2.gif;
$var3 = rose3.gif;
$var4 = rose4.gif;
$var5 = rose5.gif;
$tar1 = tar1.gif;
$tar2 = tar2.gif;
$tar3 = tar3.gif;
$tar4 = tar4.gif;
$tar5 = tar5.gif;

$query = "select id, location, name, county, rating, tariff from accom where acctype = 'H' order by rating limit 10";
if (!($connection = @ mysql_connect($server,
$user,
$password)))
die("Cannot connect");
if (!(mysql_select_db("db66511019", $connection)))
showerror();
// Run the query on the connection
if (!($result = @ mysql_query ($query, $connection)))
showerror();
$step = $diff = 10;

$r = mysql_query("SELECT count() FROM accom ") or die(mysql_error());
$anz = mysql_result($r,0);
if ($offset+$diff>=$anz) {
$diff = $anz - $offset;
$vor = TRUE;
}
if (!$offset || $offset<0) {
$offset = 0;
$zur = TRUE;
}
$result=mysql_query("$DBName","SELECT FROM accom ORDER BY Name LIMIT $offset,$diff");

// Start a table, with column headers
echo "\n<table width=\"500\" border=\"0\" cellpadding=\"2\" cellspacing\"1\">" .
"\n\t<td width=\"30%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" >Name</td>" .
"\n\t<td width=\"25%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" face=\"airal\">Location</td>" .
"\n\t<td width=\"16%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" >County</td>" .
"\n\t<td width=\"16%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" >Rating</td>" .
"\n\t<td width=\"16%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" >Tariff</td>" .
"\n</tr>";
echo "\n<tr>\n\t<td></td>\n</tr>";
echo "\n<tr>\n\t<td></td>\n</tr>";
echo "\n<tr>\n\t<td></td>\n</tr>";

 // Until there are no rows in the result set,
 // fetch a row into the $row array and ...

 while ($row = mysql_fetch_array($result))


 {
    // ... start a TABLE row ...
 echo "\n<tr>";  


?>
      <td align="left" background=\"../../Gif/Background.gif\"><font color="black\" face="arial\"size="-6"> 
        <a href=\"accomodation/php/ac.php?idname=<? echo urlencode($row["name"]).">".$row["name"] ?></a></td>
      <?

"\n\t";

 echo "<td align=\"left\" background=\"../../Gif/Background.gif\"><font color=\"black\" face=\"arial\"size=\"-6\" >" .
 $row["location"] . 
 "\n\t";
 echo "<td align=\"left\"background=\"../../Gif/Background.gif\"><font color=\"black\" face=\"arial\"size=\"-6\" >" .
 $row["county"] .
 "\n\t";
  if ($row["rating"] == "1")
echo "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var1."\"</td>";
         elseif ($row["rating"] == "2")
echo "\n\t<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var2."\"</td>";
        elseif ($row["rating"] == "3")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var3."\"</td>";
       elseif ($row["rating"] == "4")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var4."\"</td>";
          elseif ($row["rating"] == "5")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var5."\"</td>";
"\n\t";

  if ($row["tariff"] == "1")
echo "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar1."\"</td>";
         elseif ($row["tariff"] == "2")
echo "\n\t<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar2."\"</td>";
        elseif ($row["tariff"] == "3")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar3."\"</td>";
       elseif ($row["tariff"] == "4")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar4."\"</td>";
          elseif ($row["tariff"] == "5")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar5."\"</td>";

echo	"</tr>";

    // Finish the row
   echo "\n</tr>";
 }

/**************************************************

HERE IS WHERE I AM NOT TO SURE WHAT TO DO WITH. this is the script has I copied it from the this site, I have not started to look at it as yet. I know I need to change the "&UID" and "$CA" but to what. thats the question.

/**************************************************

if ($zur != TRUE) echo '<a href="'.$PHP_SELF.'?acctype='.$CA.'&offset='.($offset-$step) . '&UID='.$UID.' ">Back </a> ';
for ($i=1;$i<=(int)ceil($anz/$step);$i++) echo '<a href="'.$PHP_SELF.'?acctype'.$CA.'&offset='.(($i-1)*$step). '&UID='.$UID. '" > '.$i.'</a> ';

if ($vor != TRUE) echo '<a href="'.$PHP_SELF.'?acctype'.$CA.'&offset='.($offset+$step). '&UID='.$UID.'">next</a>';

/*********************************************
// Then, finish the table
echo "\n</table>\n";

// Close the connection
if (!(mysql_close($connection)))
showerror();

?>
</tr>
<tr>
<td colspan="2">
</tr>
<tr>
<td colspan="2" height="20">
<tr>
<td colspan="2" height="20">&nbsp;
</tr>

  </table>

</table>

</body>
</html>

[bernouli]

it depens on you, which condition you want to use, if you want to select from the table where acctype = 'H' then you should use give the value of acctype to 'H', but since i see your query

$result=mysql_query("$DBName","SELECT * FROM accom ORDER BY Name LIMIT $offset,$diff"); 

has no conditions, you dont need the acctype, you can put away all the variable , butleave the $offset

if ($zur != TRUE) echo '<a href="'.$PHP_SELF.'?offset='.($offset-$step).' ">Back </a> '; 
for ($i=1;$i<=(int)ceil($anz/$step);$i++) echo '<a href="'.$PHP_SELF.'?offset='.(($i-1)*$step). '" > '.$i.'</a> '; 

if ($vor != TRUE) echo '<a href="'.$PHP_SELF.'?offset='.($offset+$step).'">next</a>'; 

[dcjones]

Ok. thank you for that.

The script is showing

Warning: Wrong parameter count for mysql_query() in /homepages/41/d43000764/htdocs/TraveltoEngland/Accomodation/PHP/hot.php on line 115

which indecates that it does not like

$step = $diff = 10;
//*******************************************
$r = mysql_query("SELECT count() FROM accom ") or die(mysql_error());
//********************************************
$anz = mysql_result($r,0);
if ($offset+$diff>=$anz) {
$diff = $anz - $offset;
$vor = TRUE;
}
if (!$offset || $offset<0) {
$offset = 0;
$zur = TRUE;
}

Why is it showing an error on the "count"

Thanks

DCJ

[bernouli]

brrrr
have no idea, i dont know why it shows error like that,
i copyed and pasted the line, but it works
see again if you have misstyped or something like that

[dcjones]

Together we are getting closer to solving this script.

this is what I have now:

$step = $diff = 10;
$r = mysql_query("SELECT COUNT(*) FROM accom WHERE acctype = 'H'") or die(mysql_error());
$anz = mysql_result($r,0);
if ($offset+$diff>=$anz) {
$diff = $anz - $offset;
$vor = TRUE;
}
if (!$offset || $offset<0) {
$offset = 0;
$zur = TRUE;
}

$result=mysql_query("SELECT * FROM accom WHERE acctype = 'H' ORDER BY name LIMIT 10 $offset, $diff");

 while ($row = mysql_fetch_array($result))

It is showing the error on " while ($row = mysql_fetch_array($result))

Is the command correct,

DCJ

[bernouli]

the correct one should be

$result=mysql_query("SELECT * FROM accom WHERE acctype = 'H' ORDER BY name LIMIT $offset, $diff"); 

[dcjones]

Yes I know your right using

$result=mysql_query("SELECT * FROM accom WHERE acctype = 'H' ORDER BY name LIMIT $offset, $diff");

but when I use the above the script runs without any errors but does not show any data. If I just run a normal query all data is shown.

I am at the end. HELP

DCJ

[bernouli]

which query did you call 'normal' ?
and may i know if you are using the latest php? so that the $offset and $diff can't be used in your script

[dcjones]

Hi,

if I run

$query = "select id, location, name, county, rating, tariff from accom where acctype = 'H' order by rating limit 10";

this query returns data

The version I am using is PHP release date Aug 11, 2002, ver 2.3.0

Do this help

DCJ

[dcjones]

Hi,

if I run the code
echoing the variables i get the following results:

$offset 0
$diff 10
$anz 26
$r Resource id #3

Does this tell us anything?

this was run with the code looking like this

$query = "select id, location, name, county, rating, tariff from accom where acctype = 'H' order by rating limit 10";

if (!($connection = @ mysql_connect($server,
$user,
$password)))
die("Cannot connect");
if (!(mysql_select_db("db66511019", $connection)))
showerror();
// Run the query on the connection
if (!($result = @ mysql_query ($query, $connection)))
showerror();

$step = $diff = 10;
$r = mysql_query("SELECT COUNT(*) FROM accom WHERE acctype = 'H'") or die(mysql_error());
$anz = mysql_result($r,0);
if ($offset+$diff>=$anz) {
$diff = $anz - $offset;
$vor = TRUE;
}
if (!$offset || $offset<0) {
$offset = 0;
$zur = TRUE;
}

//$result = mysql_query("$DBName","SELECT * FROM accom WHERE acctype = 'H' ORDER BY name LIMIT 10 $offset, $diff");

If I leave the last line in it shows the error

Warning: Supplied argument is not a valid MySQL-Link resource in /homepages/41/d43000764/htdocs/TraveltoEngland/Accomodation/PHP/hot.php on line 114

Does this tell us anything?

Regards

DCJ

[bernouli]

//$result = mysql_query("$DBName","SELECT * FROM accom WHERE acctype = 'H' ORDER BY name LIMIT 10 $offset, $diff");

the syntax ist LIMIT offset,difference
you will just get parse error if you do that,

The version I am using is PHP release date Aug 11, 2002, ver 2.3.0

Are you sure, you are using PHP version TWO Point Three? 😃

it ca be, that the global_variable is set to off

try to do this

$offset=$_GET['offset'];
$step = $diff = 10;
$r = mysql_query("SELECT COUNT(*) FROM accom WHERE acctype = 'H'") or die(mysql_error());
.
.
and so on
.
.
.

[dcjones]

Hi and good morning to you.

Below is the code as it stands now. It runs without any errors but it does not show data.

$query = "select id, location, name, county, rating, tariff from accom where acctype = 'H' order by rating limit 10";

if (!($connection = @ mysql_connect($server,
$user,
$password)))
die("Cannot connect");
if (!(mysql_select_db("db66511019", $connection)))
showerror();
// Run the query on the connection
if (!($result = @ mysql_query ($query, $connection)))
showerror();

$offset=$_GET['offset'];
$step = $diff = 10;
$r = mysql_query("SELECT COUNT(*) FROM accom WHERE acctype = 'H'") or die(mysql_error());
$anz = mysql_result($r,0);
if ($offset+$diff>=$anz) {
$diff = $anz - $offset;
$vor = TRUE;
}
if (!$offset || $offset<0) {
$offset = 0;
$zur = TRUE;
}

// Start a table, with column headers
echo "\n<table width=\"500\" border=\"0\" cellpadding=\"2\" cellspacing\"1\">" .
"\n\t<td width=\"30%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" >Name</td>" .
"\n\t<td width=\"25%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" face=\"airal\">Location</td>" .
"\n\t<td width=\"16%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" >County</td>" .
"\n\t<td width=\"16%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" >Rating</td>" .
"\n\t<td width=\"16%\" bgcolor=\"#990000\"><font color=\"white\" size=\"-1\" >Tariff</td>" .
"\n</tr>";
echo "\n<tr>\n\t<td></td>\n</tr>";
echo "\n<tr>\n\t<td></td>\n</tr>";
echo "\n<tr>\n\t<td></td>\n</tr>";

 // Until there are no rows in the result set,
 // fetch a row into the $row array and ...

// while ($result = mysql_fetch_row($result))

 {
    // ... start a TABLE row ...
 echo "\n<tr>";  


?>
      <td align="left" background=\"../../Gif/Background.gif\"><font color="black\" face="arial\"size="-6"> 
        <a href=\"accomodation/php/ac.php?idname=<? echo urlencode($row["name"]).">".$row["name"] ?></a></td>
      <?

"\n\t";

 echo "<td align=\"left\" background=\"../../Gif/Background.gif\"><font color=\"black\" face=\"arial\"size=\"-6\" >" .
 $row["location"] . 
 "\n\t";
 echo "<td align=\"left\"background=\"../../Gif/Background.gif\"><font color=\"black\" face=\"arial\"size=\"-6\" >" .
 $row["county"] .
 "\n\t";
  if ($row["rating"] == "1")
echo "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var1."\"</td>";
         elseif ($row["rating"] == "2")
echo "\n\t<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var2."\"</td>";
        elseif ($row["rating"] == "3")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var3."\"</td>";
       elseif ($row["rating"] == "4")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var4."\"</td>";
          elseif ($row["rating"] == "5")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$var5."\"</td>";
"\n\t";

  if ($row["tariff"] == "1")
echo "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar1."\"</td>";
         elseif ($row["tariff"] == "2")
echo "\n\t<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar2."\"</td>";
        elseif ($row["tariff"] == "3")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar3."\"</td>";
       elseif ($row["tariff"] == "4")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar4."\"</td>";
          elseif ($row["tariff"] == "5")
 echo   "<td align=\"left\" background=\"../../Gif/Background.gif\"><img src=\"".$tar5."\"</td>";

echo	"</tr>";

    // Finish the row
   echo "\n</tr>";
 }

/if ($zur != TRUE) echo '<a href="'.$PHP_SELF.'?id='.($id-($tmp+$step)).'&offset='.($offset-$step) . ' ">Back </a> ';
for ($i=1;$i<=(int)ceil($anz/$step);$i++) echo '<a href="'.$PHP_SELF.'?id='.(($i-1)$step).'&offset='.(($i-1)*$step). '" > '.$i.'</a> ';

if ($vor != TRUE) echo '<a href="'.$PHP_SELF.'?id='.$id.'&offset='.($offset+$step).'">next</a>';

*/

 // Then, finish the table
 echo "\n</table>\n";

// Close the connection
if (!(mysql_close($connection)))
showerror();

?>

If I run the code using the query:

$query = "select id, location, name, county, rating, tariff from accom where acctype = 'H' order by rating limit 10";

followed by:

while ($result = mysql_fetch_row($result))

The script shows data.

Can you please help me more. I know you have spent a lot of time on this and I am very thankful.

Regards

DCJ

[dcjones]

Hi Bernouli,

if you want to see the code in action;

[url]http://www,travellingtoengland.co.uk[/url]

select ACCOMODATION, HOTELS

regards

DCJ