twilitegxa Posted July 9, 2009 Share Posted July 9, 2009 I am receiving an error when I run this php code: Error - Notice: Undefined index: cat_id in C:\wamp\www\seestore.php on line 28 Here is the php code: <?php //connect to database $conn = mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("smrpg",$conn) or die(mysql_error()); $display_block = "<h1>My Categories</h1> <p>Select a category to see its items.</p>"; //show categories first $get_cats = "select id, cat_title, cat_desc from store_categories order by cat_title"; $get_cats_res = mysql_query($get_cats) or die(mysql_error()); if (mysql_num_rows($get_cats_res) < 1) { $display_block = "<p><em>Sorry, no categories to browse.</em></p>"; } else { while ($cats = mysql_fetch_array($get_cats_res)) { $cat_id = $cats['id']; $cat_title = strtoupper(stripslashes($cats['cat_title'])); $cat_desc = stripslashes($cats['cat_desc']); $display_block .= "<p><strong><a href=\"$_SERVER[php_SELF]?cat_id=$cat_id\">$cat_title</a></strong> <br>$cat_desc</p>"; if ($_GET['cat_id'] == $cat_id) { //get items $get_items = "select id, item_title, item_price from store_items where cat_id = $cat_id order by item_title"; $get_items_res = mysql_query($get_items) or die(mysql_error()); if (mysql_num_rows($get_items_res) < 1) { $display_block = "<p><em>Sorry, no items in this category.</em></p>"; } else { $display_block .= "<ul>"; while ($items = mysql_fetch_array($get_items_res)) { $item_id = $items[id]; $item_title = stripslashes($items[item_title]); $item_price = $items[item_price]; $display_block .= "<li><a href=\"showitem.php?item_id=$item_id\">$item_title</a> </strong> (\$$item_price)"; } $display_block .= "</ul>"; } } } } ?> <html> <head> <title>My Categories</title> </head> <body> <?php print $display_block; ?> </body> </html> How do I set the index on a $_GET? Someone gave me a way to do it on a $_POST one: if(!isset($_POST['op'])) But this one is different. Any help? Quote Link to comment Share on other sites More sharing options...
joel24 Posted July 9, 2009 Share Posted July 9, 2009 does your url have www.whatever.com?cat_id=whatever in it? you should probably also change it to if(isset($_GET['cat_id']) && $_GET['cat_id'] == $cat_id) { Quote Link to comment Share on other sites More sharing options...
twilitegxa Posted July 9, 2009 Author Share Posted July 9, 2009 Thank you so much! That did it! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.