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? Link to comment https://forums.phpfreaks.com/topic/165289-solved-undefined-index/ 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) { Link to comment https://forums.phpfreaks.com/topic/165289-solved-undefined-index/#findComment-871672 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! Link to comment https://forums.phpfreaks.com/topic/165289-solved-undefined-index/#findComment-871719 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.