Ive been to php.net and this is what they say:
// Reporting E_NOTICE can be good too (to report uninitialized
// variables or catch variable name misspellings ...)
so I put this code in my file like so:
Code: Select all
<?php
error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);
// config-------------------------------------
$host = "*"; //your database host
$user = "*"; // your database user name
$pass = "*"; // your database password
$db = "contact_management_system"; // your database name
$filename = "people.html"; // name of this file
$option = array (5, 10, 20, 50, 100, 200);
$default = 100; // default number of records per page
$action = $_SERVER['PHP_SELF']; // if this doesn't work, enter the filename
// database query. Enter your query here
$query = "SELECT
o.org_id,o.web_url,
p.person_id,p.org_id,p.salutation,p.firstname,p.surname,
p.organisation,p.role,p.address1,p.address2,p.city,
p.postcode,p.telephone,p.mobile,p.fax,p.dateoflastcontact,
p.datecontactagain,p.notes,p.email,
DATE_FORMAT(dateoflastcontact, '%M/%Y')
AS dateoflastcontact, DATE_FORMAT(datecontactagain, '%M/%Y')
AS datecontactagain
FROM people p LEFT JOIN organisations o
ON o.org_id = p.org_id
ORDER BY firstname";
// end config---------------------------------
?>Two questions how good is this error reporting anyway, does it tell you which line of code is dodgy
and secondly why are my erros not being reported.?