[SOLVED] something.php?=

[jck]

i have made a script with some links so when i point sometimes it says

view.php?id=someno  but sometimes when there are no more records it just view.php?id=  i want to add an if clause to echo that no such jokes exist in that case

i have tried id == '0' and id == ' ' snd id== '' but none of them work can i do anything for it??

[Caesar]

We'll have to see your code to be able to help you.

[pocobueno1388]

Just do something like this:

 

<?php

$id = $_GET['id'];
$query = mysql_query("SELECT col FROM jokes WHERE jokeID='$id'");

if (mysql_num_rows($query) > 0){
   
   //The joke EXISTS

} else {

   //The joke DOES NOT exist

}

?>

 

[jck]

$rnext = mysql_query("SELECT * from dd_items WHERE ItemCategory = '$a1[itemCategory]' AND ItemID < '$ItemID' ORDER by ItemID 

DESC LIMIT 1");
$rownext = mysql_fetch_array($rnext);
$next = $rownext['ItemID'];

$rprev = mysql_query("SELECT * from dd_items WHERE ItemCategory = '$a1[itemCategory]' AND ItemID > '$ItemID' ORDER by ItemID 

DESC LIMIT 1");
$rowprev = mysql_fetch_array($rprev);
$prev = $rowprev['ItemID'];



<a href="/view.php?ItemID=<?=$prev?>"><img
style="border: 0px solid ; width: 50px; height: 50px;"
alt="Previous Joke in this category" src="images/prev.gif"></a><a
href="view.php?ItemID=<?=$next?>"><img
style="border: 0px solid ; width: 50px; height: 50px;"
alt="Next Joke in this category" src="images/next.gif"></a>

[jck]

hey i did in a easier way if ($id != 0)

original code

else

//no joke