Moving among IDs

jokesadder

I should be posting in "Newbies" section but as I am no programmer and wouldn't become it, I dare to post here :rolleyes:

I run a joke site and want to add functionality. Wrote a script but it doesn't work.
The basic idea is to create a small navigation script which would allow a user to move from a joke to the next joke with a single click:

<?php

$sql = "select jokeid from jokes where jokeid>$jokeid and catid=$catid order by jokeid limit 1";
$result = mysql_query($sql ,$db);

if ($myrow = mysql_fetch_array($result)) {

printf("<a href='joke.php?jokeid=<?php printf($jokeid); ?>' >Next Joke</a>");

} while ($myrow = mysql_fetch_array($result));

?>

There's a table called 'jokes' in my database and the script had to move from ID to ID while the next ID's value is higher.

Please do not criticize 'printf'. I am a management student not programmer. Any ideas or suggestions would be highly appreciated! Thanks.

laserlight

Please do not criticize 'printf'.

In this case we should, because it happens to be the line that has the obvious problem.

Instead of

printf("<a href='joke.php?jokeid=<?php printf($jokeid); ?>' >Next Joke</a>");

which is syntactically incorrect, you should use:

echo '<a href="joke.php?jokeid=' . $jokeid . '">Next Joke</a>';
//or if you insist on printf()
printf("<a href=\"joke.php?jokeid=%d\">Next Joke</a>", $jokeid);

jokesadder

OK, the main table in MySQL database is 'jokes'. Each joke I add is asigned with it's own ID (row: jokeid) and category ID (row: catid) the row 'joke' contains the body text of the joke.
There is also a table 'categories' which gives each joke category it's own number.
Now back to the client side: There is a list of categories on the index.php page. When user clicks on the desired category (let's say: Political Jokes) he is taken to the page list.php which contains all joke titles with 'catid' relevant to Political Jokes. When he clicks on the desired joke title he is taken to page joke.php which displays the desired joke

printf("<table cellpadding=5 cellspacing=0 border=0><tr><td><font size='3' color='#0000CC' face='Arial'><li>$joke</font></td></tr></table>");

When he needs the next joke he has to press BACK to get to the list.php again. It is annoying 🙁
I wanted a small navigation script to deliver next joke while the joke is situated within the same catid and while it's own jokeid is bigger than the jokeid value of the previous joke. It sounds simple but all I succeeded in is giving the user an opportunity to pick a random joke 🙂