PHP - Echo Out The Number Of Records In A Mysql Table With Php?

It's pretty simple to see what I am trying to do here. For some reason all results in the table are the same exact cityName replacing all existing records. The echoed results are correct. I've include a small dump of my table as well.

$query = "SELECT cityName FROM sys_city_dev_2";
      $resource = mysqli_query($cxn, $query) or die("MySQL error: " . mysqli_error($cxn) . "<hr>\nQuery: $query");
      
  while($result = mysqli_fetch_assoc($resource)) {

          $nox = $result['cityName'];

          $toUpper = ucfirst($nox);
  echo "$toUpper" . "<br />";

          $setString = "UPDATE sys_city_dev_2 SET cityName = '" . $toUpper ."' WHERE cityName != ''";
          mysqli_query($cxn,$setString);


      } 

100 Records of table dump (pre running my script above):

--
-- Table structure for table `sys_city_dev_2_backup`
--

CREATE TABLE IF NOT EXISTS `sys_city_dev_2_backup` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Mid` int(11) NOT NULL DEFAULT '0',
  `cityName` varchar(30) NOT NULL DEFAULT '',
  `forder` int(4) NOT NULL DEFAULT '0',
  `disdplay` int(4) NOT NULL DEFAULT '0',
  `cid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=113970 ;

--
-- Dumping data for table `sys_city_dev_2_backup`
--

INSERT INTO `sys_city_dev_2_backup` (`ID`, `Mid`, `cityName`, `forder`, `disdplay`, `cid`) VALUES
(84010, 1, 'dothan', 0, 0, 0),
(84011, 1, 'alabaster', 0, 0, 0),
(84012, 1, 'birmingham', 0, 0, 0),
(84013, 2, 'flagstaff', 0, 0, 0),
(84014, 1, 'auburn', 0, 0, 0),
(84015, 1, 'florence', 0, 0, 0),
(84016, 1, 'gadsden', 0, 0, 0),
(84017, 1, 'huntsville', 0, 0, 0),
(84018, 1, 'mobile', 0, 0, 0),
(84019, 1, 'montgomery', 0, 0, 0),
(84020, 1, 'tuscaloosa', 0, 0, 0),
(84021, 2, 'mohave valley', 0, 0, 0),
(84022, 2, 'phoenix', 0, 0, 0),
(84023, 2, 'prescott', 0, 0, 0),
(84024, 2, 'sierra vista', 0, 0, 0),
(84025, 2, 'tucson', 0, 0, 0),
(84026, 2, 'yuma', 0, 0, 0),
(84027, 3, 'bakersfield', 0, 0, 0),
(84028, 3, 'chico', 0, 0, 0),
(84029, 3, 'fresno / madera', 0, 0, 0),
(84030, 3, 'gold country', 0, 0, 0),
(84031, 3, 'humboldt county', 0, 0, 0),
(84032, 3, 'imperial', 0, 0, 0),
(84033, 3, 'inland empire', 0, 0, 0),
(84034, 3, 'los angeles', 0, 0, 0),
(84035, 3, 'alhambra', 0, 0, 0),
(84036, 3, 'merced', 0, 0, 0),
(84037, 49, 'fayetteville', 0, 0, 0),
(84038, 49, 'fort smith', 0, 0, 0),
(84039, 49, 'jonesboro', 0, 0, 0),
(84040, 49, 'little rock', 0, 0, 0),
(84041, 49, 'arkadelphia', 0, 0, 0),
(84042, 49, 'texarkana', 0, 0, 0),
(84043, 3, 'modesto', 0, 0, 0),
(84044, 3, 'alta sierra', 0, 0, 0),
(84045, 3, 'alpine', 0, 0, 0),
(84046, 3, 'pedley', 0, 0, 0),
(84047, 3, 'redding', 0, 0, 0),
(84048, 3, 'alondra park', 0, 0, 0),
(84049, 3, 'sacramento', 0, 0, 0),
(84050, 4, 'canon city', 0, 0, 0),
(84051, 3, 'san luis obispo', 0, 0, 0),
(84052, 3, 'santa barbara', 0, 0, 0),
(84053, 3, 'stockton', 0, 0, 0),
(84054, 3, 'aliso viejo', 0, 0, 0),
(84055, 3, 'visalia', 0, 0, 0),
(84056, 3, 'yuba city', 0, 0, 0),
(84057, 4, 'boulder', 0, 0, 0),
(84058, 4, 'colorado springs', 0, 0, 0),
(84059, 4, 'denver', 0, 0, 0),
(84060, 4, 'applewood', 0, 0, 0),
(84061, 4, 'pueblo', 0, 0, 0),
(84062, 4, 'air force academy', 0, 0, 0),
(84063, 5, 'avon', 0, 0, 0),
(84064, 5, 'hartford', 0, 0, 0),
(84065, 5, 'new haven', 0, 0, 0),
(84066, 5, 'ansonia', 0, 0, 0),
(84067, 5, 'fairfield', 0, 0, 0),
(84068, 7, 'daytona beach', 0, 0, 0),
(84069, 7, 'sebastian', 0, 0, 0),
(84070, 5, 'wallingford center', 0, 0, 0),
(84071, 8, 'belvedere park', 0, 0, 0),
(84072, 7, 'sarasota springs', 0, 0, 0),
(84073, 7, 'sandalfoot cove', 0, 0, 0),
(84074, 7, 'san carlos park', 0, 0, 0),
(84075, 7, 'st. augustine', 0, 0, 0),
(84076, 7, 'tallahassee', 0, 0, 0),
(84077, 7, 'safety harbor', 0, 0, 0),
(84078, 7, 'ruskin', 0, 0, 0),
(84079, 8, 'athens-clarke county', 0, 0, 0),
(84080, 8, 'atlanta', 0, 0, 0),
(84081, 8, 'augusta-richmond county', 0, 0, 0),
(84082, 8, 'brunswick', 0, 0, 0),
(84083, 8, 'columbus', 0, 0, 0),
(84084, 8, 'americus', 0, 0, 0),
(84085, 8, 'acworth', 0, 0, 0),
(84086, 8, 'valdosta', 0, 0, 0),
(84087, 10, 'boise', 0, 0, 0),
(84088, 10, 'ammon', 0, 0, 0),
(84089, 10, 'moscow', 0, 0, 0),
(84090, 10, 'blackfoot', 0, 0, 0),
(84091, 10, 'twin falls', 0, 0, 0),
(84092, 10, 'meridian', 0, 0, 0),
(84093, 10, 'jerome', 0, 0, 0),
(84094, 10, 'idaho falls', 0, 0, 0),
(84095, 11, 'addison', 0, 0, 0),
(84096, 10, 'garden city', 0, 0, 0),
(84097, 10, 'eagle', 0, 0, 0),
(84098, 10, 'chubbuck', 0, 0, 0),
(84099, 10, 'caldwell', 0, 0, 0),
(84100, 12, 'bloomington', 0, 0, 0),
(84101, 12, 'evansville', 0, 0, 0),
(84102, 12, 'fort wayne', 0, 0, 0),
(84103, 12, 'indianapolis', 0, 0, 0),
(84104, 12, 'muncie / anderson', 0, 0, 0),
(84105, 12, 'lafayette / west lafayette', 0, 0, 0),
(84106, 12, 'south bend / michiana', 0, 0, 0),
(84107, 12, 'terre haute', 0, 0, 0),
(84108, 12, 'northwest indiana', 0, 0, 0),
(84109, 13, 'ames', 0, 0, 0);

I need help with a count query and displaying it.  Right now have the following query

$query = "SELECT COUNT(*) as num1 FROM spoiler WHERE id='$id";
$total_trophies = mysql_fetch_array(mysql_query($query));
$total_trophies = $total_trophies[num1];

So I have another query that pulls how many trophies there are.  That way I can do the following


?  echo $total_trophies; echo 'of'; echo $row[trophy_count];  ?>

But the problem is sometimes in my database I could have mulitple entrys per trophy.  For Trophy 1 I might have only one record so It counts it correctly for trophy 2 I could have 3 records so It counts each one of those records when I only one to count it once for that trophy

Hi all,

I am trying to use the Mysql COUNT function to count the number of records in a database where the manufacturer is the same and then generate a list of all manufacturers along with a number of associated records next to their name.

I have got the script below to show the manufacturer in a fetch array but I can not get the number next to the manufacturer to work.

A push in the right direction would be appreciated thanks.


<?php 
include("cxn.php");

$query = "SELECT manufacturer FROM sales"; 
$result = mysqli_query($cxn,$query) or die(mysqli_error());
 
?>
<select name="manufacturer" id="manufacturer">
<option value="" selected="selected">Select a Manufacturer..</option>";
<?php 
while($row = mysqli_fetch_array($result)){
$query1 = "SELECT manufacturer COUNT(*) FROM sales WHERE manufacturer='$row[manufacturer]'";  // TRYING TO COUNT THE ROWS HERE
$result1 = mysqli_query($cxn,$query1) or die (mysqli_error());

while($row1 = mysqli_fetch_array($result1)){
echo "<option value=\"202\">".$row['manufacturer'] ."[". $row1['COUNT(manufacturer)']."]</option>"; // SHOW NUMBER HERE
}
}
?>

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=311502.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=325939.0

How would I write PHP code to echo the number of pictures I have in a folder on my hosting account?   Thanks in advance.

Hey...

I'm trying to echo the title of the news in the right column but I just want to display maximum of 25 characters how can I do it?

thanks

I have a html table displaying data from mysql database. I can count rows properly with mysql_num_rows but is there a way to echo which row number it is. What I want to do is count the rows ordered by cities and echo row number. Thanks for any help.

Hi everyone,

I have the task of building a PHP page where users can enter or remove as many records as they like into different categories. This then makes the number of records entered unknown, and therefore it becomes more complicated.

To make this clearer, I have attached an image of what I am trying to do.

Two questions:
- Before submitting the form, how can each record entry be matched with the correct category? (maybe hidden form fields somehow?)
- What is the best way of inserting each record (and it's associated category) into a MySQL database table from a single form submit?

I want to try and keep this as simple as possible as the data will later be updated, removed etc.

I'm experiencing a brain fart and just cannot picture the best way of going about this

Any help and advice is much appreciated!

Thanks in advance.

Code: [Select]
Basic table schema example...

CATEGORY TABLE
----------------------------
| catid |    category    |
----------------------------
|  1    |  Category A  |
|  2    |  Category B  |
etc.   etc.
----------------------------

DATA ENTRY TABLE
----------------------------
dataid | catid |    data     |
--------------------------------
|  1  |   2    |  data xyz |
|  2  |   1    |  data zyx |
etc.  etc  etc.
--------------------------------

Hello all,

I am new to php coding and have a couple of problems with editing records in my database! I have two files below one test.php and edit.php. In the test.php the code outputs the records into a table. The problem is with the edit link as when it is selected I wish to be able to edit a record by a form, which is on edit.php. I am trying bring up the movie's information on the form to be edited. Currently on the form i get;

Quote

Movie: movie
Gen Genre
Year: year



Any ideas how I can edit the record and then return to the test.php page?
Code: [Select]
test.php

<html>
<body style="background-color:#669999;">
<table width="490"border=0><tr>
<td  colspan="2" style="background-color:#FFA500;">
<div id="header"
<h3 style="color:black">This is my first web-page! Below is a database of some of my favourite movies!
</h3>
</td>
</tr>

<?php
//connecting to server
$con = mysql_connect("localhost","root","NYOXAkly");

if (!$con)
{
    die('could not connect: ' . mysql_error());
}

//selecting movie database
mysql_select_db("my_mov",$con);

//Check if add button is active, start this
if(isset($_REQUEST['add']))
{ 
echo "<meta http-equiv=\"refresh\"content=\"0;URL=form.php\">";
}

$result = mysql_query("SELECT * FROM Films ORDER BY filmID");
?>

<!-------------------------------creating table------------------------------------------------------------------------------------>
<table width="490" border="0" cellspacing="1" cellpadding="0">
<tr>
 <td>
  <form name="test1" method="post" action="test.php">
  <table width="490" border="10" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC"><tr>
 <td bgcolor="#FFFFFF"></td>
 <td align="center" colspan="6" bgcolor="#FFFFFF">Movie Database</td></tr>
 <td align="center" bgcolor="#FFFFFF">filmID</td>
 <td align="center" bgcolor="#FFFFFF">Movie</td>
 <td align="center" bgcolor="#FFFFFF">Genre</td>
 <td align="center" bgcolor="#FFFFFF">Year</td>
 <td align="center" bgcolor="#FFFFFF">Edit</td>
 <td align="center" bgcolor="#FFFFFF">Delete</td>
</tr>

<?php
while($rows=mysql_fetch_array($result))
{
?>

<tr>
 </td>
 <td bgcolor="#FFFFFF"><? echo $rows['filmID']; ?></td>
 <td bgcolor="#FFFFFF"><? echo $rows['movie']; ?></td>
 <td bgcolor="#FFFFFF"><? echo $rows['genre']; ?></td>
 <td bgcolor="#FFFFFF"><? echo $rows['year']; ?></td>
 <td bgcolor="#FFFFFF">
  <a href="edit.php?filmID=<?php echo 'filmID';?>">Edit</a> 
 <td bgcolor="#FFFFFF">
<a href="delete.php?filmID=<?php echo 'filmID';?>">Delete</a> 
 </td>
</tr>

<?php
}

echo print_r(error_get_last());
mysql_close();
?>

<!--add button-->
<tr>
  <td colspan="15" align="left" bgcolor="#FFFFFF">
      <input name='add' type="submit" filmID="add" value="Add A New Record" action="form.php?"> 
  </td>
</tr>

</table>
</form>

<br/>
By C.M.D.W
<br/>

<?php 
     echo date("Y/m/d") . "<br />";
?>

</body>
</html>


Code: [Select]

edit.php

<html>
<body style="background-color:#669999;">

<!------------------Creates a form ---------------------->
<br />
 <form action="" method="post">
  <fieldset>
   <legend>Enter your movies into database here!</legend>
   Movie: <input type ="text" name="movie" value="<?php echo 'movie';?>">
<br />
   Gen <input type ="text" name="genre" value="<?php echo 'genre';?>"/>
<br />
   Year: <input type ="text" name="year" value="<?php echo 'year';?>"/>
<br />
   <input type="submit" name="name" value="Submit" />
  </fieldset>
 </form>

<?php
//connecting to server
$con = mysql_connect("localhost","root","NYOXAkly");

if (!$con)
{
    die('could not connect: ' . mysql_error());
}

//selecting movie database
mysql_select_db("my_mov",$con);

if (isset($_POST['submit']))
 { 
 // confirm that the 'id' value is a valid integer

 if (is_numeric($_POST['filmID']))
 
 // get form data
 $filmID = $_POST['filmID'];
 $movie = mysql_real_escape_string(htmlspecialchars($_POST['movie']));
 $genre = mysql_real_escape_string(htmlspecialchars($_POST['genre']));
 $year = mysql_real_escape_string(htmlspecialchars($_POST['year']));
 
 // check that fields are filled in
 if ($movie == '' || $genre == '' || $year == '')
 {
 // generate error message
 $error = 'ERROR: Please fill in all required fields!';
 } 
 else
 {
 
 // save the data to the database
 }
mysql_query("UPDATE players SET movie='$movie', genre='$genre', year='$year' WHERE filmID='$filmID'")
 or die(mysql_error()); 
 
 // once saved, redirect back to the view page
 header("Location: test.php"); 
 }
 }

 if (isset($_GET['filmID']) && is_numeric($_GET['filmID']) && $_GET['filmID'] > 0)
  {
 // query db
 $id = $_GET['filmID'];
 $result = mysql_query("SELECT * FROM Films WHERE filmID=$FilmID")
 or die(mysql_error()); 
 $row = mysql_fetch_array($result);
 
 // check that the 'id' matches up with a row in the databse
 if($row)
 {
 
 // get data from db
 $movie = $row['movie'];
 $genre = $row['genre'];
 $year = $row['year'];

}}

?>


<br/>
<br/>

<a href="test.php">Return To Home Page</a>
<br/>
<br/>
By C.M.D.W
<br/>
<?php 
     echo date("Y/m/d") . "<br />";
?>
</body>
</html>

Thanks

Chris

Hi guys, I am trying to UPDATE some records on a mySQL database but can't seem to find out why it is not working. This is my code.


Code: [Select]
<?php


$latitude = $_POST['lat_location'];
$longitude = $_POST['long_location'];
$unique_ID = $_POST['unique_ID'];

include('connect2.php');



$query = mysql_query("SELECT * FROM user_location WHERE unit = '$unique_ID'");

$numrows = mysql_num_rows($query);


if ($numrows == 1) {



$query2="UPDATE user_location SET lat = '$latitude', long = '$longitude' WHERE unit = '$unique_ID'";
mysql_query($query2);



$test = "matches";



} else {

mysql_query("INSERT INTO user_location VALUES ('','$unique_ID','$latitude','$longitude')");

$test = "not match";

}

echo $test . "<br />";
echo $numrows;

?>
The script receives the data via the POST method and assigns it to variables. Then I query the database for one of those variables and check how many results are found. If 0 results are found then a new record is created on the database, but if there is 1 record found then the record that is found has to be UPDATED. When the result is 0 the scripts creates the new record fine, but if the result is 1 it doesn't update. I just can't figure out why. Any help will be greatly appreciated.

Thanks in advanced,

Hi guys,

I need your help. I am checking on a database as I want to see if the records have been updated or not.

Code: [Select]
<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbuser');
    define('DB_PASSWORD', 'mydbpass');
    define('DB_DATABASE', 'mydbtable');
       
    $errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {
  die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
  
    $username = clean($_GET['user']);
    $password = clean($_GET['pass']);
    $test = clean($_GET['test']);
    $public = clean($_GET['public']);
   
   
   if (isset($_GET['user']) && (isset($_GET['pass']))) {
    if($username == '' || $password == '') {
  $errmsg_arr[] = 'username or password are missing';
  $errflag = true;
    }
} elseif (isset($_GET['user']) || (isset($_GET['test'])) || (isset($_GET['public']))) {
    if($username == '' || $test == '' || $public == '') {
  $errmsg_arr[] = 'user or others are missing';
  $errflag = true;
    }
  }

    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
  $qry="SELECT * FROM members WHERE username='$username' AND passwd='$password'";
  $result=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());


if ($username && $password) {
  if(mysql_num_rows($result) > 0) {
     $qrytable1="SELECT images, id, test, links, Public FROM user_channel_list WHERE username='$username'";
    $result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());

    while ($row = mysql_fetch_array($result1)) {
        echo "<p id='test'>";
        echo $row['test'] . "</p>";
        echo '<p id="images"> <a href="images.php?test=test&id='.$row['id'].'">Images</a></td> | <a href="http://' .  $row["links"] . '">Link</a> </td> | <a href="delete.php?test=test&id='.$row['id'].'">Delete</a> </td> | <span id="test">'.$row['Public'].'</td>';
     }
   } else {
    echo "user not found";
  }
} elseif($username && $test && $public) {
    $qry="SELECT * FROM members WHERE username='$username'";
    $result1=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());
    
    if(mysql_num_rows($result1) > 0) {     
      $qrytable1="SELECT Public FROM user_channel_list WHERE username='$username' && test='$test'";
      $result2=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());
      
      if(mysql_num_rows($result2) > 0) {
        $row = mysql_fetch_row($result2);
        mysql_query("UPDATE user_list SET Public=('$_GET[public]') WHERE username='$username' AND test='$test'");
        echo "update!";
      } else {
        echo "already updated!";
      }
    } else {
      echo "user not found";
    }
  }
} 
?>

When I run debug the code on my php, if i input the data in a url bar while the records are the same as the data that I enter in the url, i should get the print out on my php "already updated", but I keep getting "update!".

Do you know how i can check on mysql database to see if the records have been updated or not??

Hello,

This is driving me crazy, as I cannot get it working.

I have a database that has a table called 'categories'. I need to retrieve all categories with category_id != '1,2,3'. For this, I can this query:

Code: [Select]
$q = "SELECT * FROM categories WHERE category_id NOT IN (1,2,3)";

The query executes fine. I need this categories retrieved, to be passed to a Smarty Template Engine powered page. I have:
Code: [Select]
$q = "SELECT * FROM categories WHERE category_id NOT IN (1,2,3)";
$res = mysql_query($q);
while($row=mysql_fetch_array($res)) {
 Assign('categories',$row);
}
But when retrieving the array in the Smarty page, with a loop, I only see the last item of the array (the last category).

If I go back to the while loop, and add a Code: [Select]
print_r($row);, I see two arrays (I have two categories).

But the question is: How can I work with those two categories, as I need to use them individually outside the while loop?

Any help is appreciated.

Best Regards,
Richi

I have a problem .
I 've been trying for a long time to make an update for php mysql to change the data.
but every time I do not manage to make it work with a form.
but it works if I only if I put this ($ sql = "UPDATE users SET username = 'value' WHERE id = 10 " ; )
so it only works when I put the value of the id.

but I want in an html form to indicate what I want to change and what id goes.

but I have tried so long that I do not feel like I so want someone help me.

make the same database and same as my records and make the code and test it if it works show me please
my database name : web test
my table called : users
my records are called :

id int ( 11) AUTO_INNCREMENT
username , varchar ( 255 )
password , varchar ( 255 )
first_name , varchar ( 255 )
last_name , varchar ( 255 )
email, varchar ( 255 )
Age, int ( 11)             Look, my update.php is like this now
<?php
$servername = "localhost";
$username = "root";
$password = ".....";
$dbname = "webtest";


$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} 

$sql = "UPDATE users SET password='cotton candy' WHERE id=10";

if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}

$conn->close();
?>
but now i have still have to go into the php file to change the valeu or the id 
but i looked on site and youtube how to put it in a simple html form 
but it still does not work.

i want it in a html from.
I want that when I enter the ID that the data of the user appears and that I can change any valeu separately.

Hi,I'm hoping someone can help me:).  When I add foreign keys to the database in MySQL I CAN change the primary key field and the corresponding indexed field will automatically change giving me the same value which is exactly what i want. The issue is when I try to insert the values using my php code i get the 'cannot update child error'. I have not selected a value for the unique_id field as I want it to inherit the value from the primary key. Here's my code as simplified as I could do it.

<?php  //this calls the class productupload and instantiates the function insert_form to insert values into the db.

$product = new productUpload();
$product->insert_form();?>
//This calls the insert_form function and inserts info into tables
<?php
class productUpload extends DatabaseObject{
protected static $table_name="itm_details";
protected static $db_fields =array('id','unique_id','itm_cat','itm_make','itm_model','itm_desc','itm_cond','itm_date_from','itm_date_to','itm_add_date');     


    public $id;
    public $unique_id;
    public $itm_cat;
    public $itm_make;
    public $itm_model;
    public $itm_desc;
    public $itm_cond;
    public $itm_date_from;
    public $itm_date_to;   
    public $itm_add_date;
Heres the function insert_form which grabs the form submitted data. Note I have not defined a value for $unique_id

public function insert_form(){ 
global $database; 
 //set the object attributes to the form the parameters
        if(isset($_POST['submit'])) {
        $result = array(
        $this->itm_cat =(!empty($_POST['itm_cat'])) ? trim($_POST['itm_cat']) : NULL,
        $this->itm_make =(!empty($_POST['itm_make'])) ? trim($_POST['itm_make']) : NULL,       
        $this->itm_model = (!empty($_POST['itm_model'])) ? trim($_POST['itm_model']) : NULL,                                   
        $this->itm_desc =(!empty($_POST['itm_desc'])) ? trim($_POST['itm_desc']) : NULL,
        $this->itm_cond =(!empty($_POST['itm_cond'])) ? trim($_POST['itm_cond']) : NULL,
        $this->itm_date_from =(!empty($_POST['itm_date_from'])) ? trim($_POST['itm_date_from']) : NULL,
        $this->itm_date_to =(!empty($_POST['itm_date_to'])) ? trim($_POST['itm_date_to']) : NULL,
        $this->itm_add_date = date("Y-m-d H:m:s"));
//check date is numeric
        //if(is_numeric($_POST['itm_date_from'])) {
        //$this->itm_date_from = $_POST['itm_date_from'];
//}   
//check date is numeric                       
        //if(is_numeric($_POST['itm_date_to'])) {
        //$this->itm_date_to = $_POST['itm_date_to'];
        //}
        if($result){
        $result = $this->create();
        }
        }
        }

//here's the create function referred to above which sanitises the posted data and inserts it into the db.


public function create() {
        global $database;
        $attributes = $this->sanitised_attributes();

        $sql = "INSERT INTO ".self::$table_name."(";
        $sql .= join(", ", array_keys($attributes));
        $sql .= ") VALUES ('";
        $sql .= join("', '", array_values($attributes));
        $sql .= "')";
        if($database->query($sql)) {
        $this->id = $database->insert_id();
        return true;
        } else {       
        return false;
        }

}