zollet — Thu, 23 Jan 2003 13:05:35 +0000

Alkaif, the code I posted checks the database for that ID, if it's not there, will not result any lines which then prints the category does not exist.

Mark Hensler — Thu, 23 Jan 2003 04:05:32 +0000

Alkaif Khan, the code Zollet provided should do the job. Post your code, and we'll make the appropriate changes for you.

Alkaif Khan — Thu, 23 Jan 2003 04:02:33 +0000

I mean that works but not for what i need.

IT should check the ID against the list of ids there.

Say i have 7 ids in the ID column

ID
1
2
3
4
5
6
7

and showcat.php?id=39489 wants to show an id of 39489 but we dont have the ID 39489 so then it should output an error saying "hey this is not a valid ID." or something like that.

I know that can be done, but how?

nike_guy_man — Thu, 23 Jan 2003 02:47:02 +0000

Looks like it'll work... as long as MySQL is installed and working
Are you getting any errors?
(Welcome to TWF too, Alkaif Khan)

zollet — Thu, 23 Jan 2003 02:43:07 +0000

You need to edit it to fit your needs. Also you must be connected to the MySQL server before you execute the above code. If you do that correctly, then it should work (unless I've typed it wrong ).

Alkaif Khan — Thu, 23 Jan 2003 02:13:49 +0000

Neverworked mate.

zollet — Wed, 22 Jan 2003 22:10:28 +0000

I'm assuming you're using MySQL to store the products and categories...

<?php
$result = mysql_query(\"SELECT id FROM categories WHERE id = '$id'\");
if(mysql_num_rows($result) < 1) {
    echo \"The category does not exist!\".
}
?>