Grabbing from a database

[reed682]

I have atag board script which grabbs a name, message, and a url, from a database. It works greak, the only thing is I don't want to display all the entries in the database, just maybe the 15 most recent. is there a way to tell php to grab the 15 most recent entries?

I would appriciate any help. If someone could give me a hint (I really want to figure it out myself but could use a helpful nudge) as to adding smilies? That would be nice.

Thanks again.

[Malcolm]

SELECT * FROM table WHERE condition=true LIMIT 10

That will only return 10 records

SELECT * FROM table WHERE condition=true LIMIT 10, 10

That will select records 11 to 20

Now finally you can do something like this to select by date

SELECT * FROM table WHERE condition=true ORDER BY date DESC LIMIT 10, 10

For more info check out MySQL's manual:
http://dev.mysql.com/doc/mysql/en/SELECT.html

[reed682]

Thanks, that really worked. What about smilies or emoticons? How can I set up a a smilie that will insert a set of symbols into the text input field and then when I retreive the text render those symbols as a graphic? I know it can be done, but can it be done simply?

[webmaster]

Code: Select all

$variable = "Weee :)";
$print = preg_replace("/:)/","<img src='smile.gif' alt='' />",$variable);

echo $print;

And welcome to DEVPPL

[reed682]

SELECT * FROM table WHERE condition=true LIMIT 10, 10

That will select records 11 to 20

But what if there are more records than that? Is there a way to make a button that refreshes and displays the previous 15 entries, and then the previous 15 before that? Am I making snese? What if say someone wanted to go through the tag board archives, all of them. Is there a way to do that dynamically?

[Malcolm]

Yeppers,
Heere's an example of a URL that would work with this code:
page.php?page=10&offset=31

Code: Select all

<?php
if(isset($_GET['page'])){
  $page = $_GET['page'];
}else{
  $page = 1;
}

if(isset($_GET['offset'])){
  $offset = $_GET['offset'];
}else{
  $offset = 10;
}

$current = $page * $offset;

$query = mysql_query("SELECT * FROM table WHERE condition = true LIMIT " . $current . ", " . $offset);
while($result = mysql_fetch_array($query)){
  echo "<hr /><pre>";
  print_r($result);
  echo "</pre>";
}

$total_IDs = mysql_result(mysql_query("SELECT COUNT(ID) from TABLE"), 0);

$total_pages = ceil($total_IDs / $offset );

for($x=1;$x < $total_pages; $x++){
  if($x == $page){
    echo "<b>" . $x . "</b> ";
  }else{
    echo "<a href='?page=" . $x . "&offset=" . $offset"'>" . $x . "</a> ";
  }
}
?>


Again, like most code posted here, this hasn't been tested but should work fine

{EDIT}
Note that this code isn't secure as it doesn't check for numerical values for the page and offset values nore does it check for escapable characters in the input. Just thought I'd let'cha know

[reed682]

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /home/virtual/site49/fst/home/normal/public_html/tag_board/tag_board.php on line 219

This is the error I get when I put that script in my tag board. What am I doing wrong?

[webmaster]

Can you show the line 219 and some lines before and after that row.

[reed682]

for($x=1;$x < $total_pages; $x++){
if($x == $page){
echo "<b>" . $x . "</b> ";
line 218 --> }else{
line 219 -- > echo "<a href='?page=" . $x . "&offset=" . $offset"'>" . $x . "</a> ";
line 220 --> }
line 221 -->}
line 222 -->?>

Does that help? I know this thread is old but I had to research loops because I could not begin to understand that code but it is making more sense. Thanks for your help.

[webmaster]

Change line 219 to:

Code: Select all

echo "<a href=\"?page=$x&offset=$offset\">$x</a>";