Greetings,
i have probably been at this way to long and need to take a break but...
my sql community installed as a stand alone,
Xampp apache standalone
PHP standalone.
I have a folder that has a .sql file, file was loaded into workbench and database added..or so i thought!
working through some php in dreamweaver... i keep getting
Notice: Undefined index: cat_id in c:\ etc etc
PHP source;
<?php session_start();
error_reporting(E_ALL); ini_set('display_errors', '1');
$link=mysqli_connect("localhost","root","password") or die("cant connect");
mysqli_select_db($link,"jobscope") or die("cant select db");
$q = "select * from jobs where j_category ='".$_GET['cat']."' and j_active=1";
$res = mysqli_query($link,$q) or die("Wrong Query");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--
Design by Free CSS Templates
http://www.freecsstemplates.org
Released for free under a Creative Commons Attribution 2.5 License
Name : Flowerily
Description: A two-column, fixed-width design for 1024x768 screen resolutions.
Version : 1.0
Released : 20090906
-->
<html xmlns="
http://www.w3.org/1999/xhtml">
<head>
<?php
include("includes/head.inc.php");
?>
</head>
<body>
<div id="header-wrapper">
<div id="header">
<div id="menu">
<?php
include("includes/menu.inc.php");
?>
</div>
<!-- end #menu -->
<div id="search">
<?php
include("includes/search.inc.php");
?>
</div>
<!-- end #search -->
</div>
</div>
<!-- end #header -->
<!-- end #header-wrapper -->
<div id="logo">
<?php
include("includes/logo.inc.php");
?>
</div>
<div id="wrapper">
<div id="page">
<div id="page-bgtop">
<hr />
<!-- end #logo -->
<div id="content">
<div class="post">
***** <h2 class="title"><?php echo $_GET['cat']; ?></h2> *****error is here
<p class="meta"></p>
<div class="entry">
<ul>
<?php
while($row = mysqli_fetch_assoc($res))
{
so im trying to work out why no matter what i do it keeps giving these errors!
so i look back over the folder, and the database...hmmmm
really ive been here for 4 hours now playing around...
the folder that had the .sql file in it also has a subfolder with another subfolder that has all these .myi .myd .frm and one .opt
1. so was i also supposed to somehow import these other files in the subfolder with the .sql file to populate the tables with data that is contained in these files?
2. was the .sql just the "exoskeleton" of the database? or should the .sql file have already contained all this information?
3. is this the reason for continually getting the index error because no matter what i did, the index was not there!
such a noob! but im getting there.
your assistance would be much appreciated!