PHP MySQL using isset($_GET)

Question

Hello, I have my php script using this code:

$start = (isset($_GET['start']) ? (int)$_GET['start'] : 0);

$result = mysqli_query($con,"SELECT * FROM menuitem LIMIT $start, 4");

This pulls in the data from my database fine. Now I want to load the next 4 items from my database when a user clicks the "Next items" link, so I put this in my code:

echo "<table width=\"1024\" align=\"center\" >";
echo "<tr height=\"50\"></tr>";

$next = $start + 4;
echo '<a href="?start="'.$next.'">Next items</a>';

echo "</table>";

Clicking the "Next items" link loads the url firstpage.php?start= but it doesn't load the next four items. Anyone see what i'm doing wrong?

Thank you! My eyes literally kept ignoring those quotes until you guys pointed it out. Thanks. Upvote for you! — ValleyDigital
– ValleyDigital, Commented Dec 4, 2013 at 18:02

scrowler · Accepted Answer · 2013-12-04 17:56:54Z

3

You're using the wrong combination of quotes when outputting the link:

echo '<a href="?start=' . $next . '">Next items</a>';
// unneeded double quote before your $next variable

answered Dec 4, 2013 at 17:56

scrowler

24.4k10 gold badges67 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ValleyDigital Over a year ago

AH! Dang it. That was it! You're the best! Thank you! I'll accept this in a few minutes when allowed.

Collectives™ on Stack Overflow

PHP MySQL using isset($_GET)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related