-1

Hello Dear Brothers & Sisters
How are you………………….?

Well, I am working on a personal project http://www.propertyagentreviews.com/ that is about Property Agent Reviews. But now I am so much confuse because I can not find solution of one problem.

And problem is that I want to create a message board like this one
www.allagents.co.uk/atlantis/
here you can saw a feedback is given by different users about a agent and a button “Agent Response & Comments(0)” from where a agent and reply them.


I am trying to create such type of system on this link
http://www.propertyagentreviews.com/Comments-reviews.php
on right side where “First Name” and “Last Name” are displaying of left I wanna put button like “Agent Response & Comments(0)” form where agent can reply. Current users will give feedback form this link http://www.propertyagentreviews.com/Feedback-form.php which will appear on this link http://www.propertyagentreviews.com/Comments-reviews.php


Now, I need you help.
1. I want to you please tell me that how I can achieve that functionality........?
2. How I will create database……………………?
........And how I will manage that database for different feedbacks and agents reply.
3. Also how that I can manage that database for different user’s feedback and for ........agents.
4. As well as how I will able to retrieve that data and echo that.
5. Also later on I want to able admin panel to have access to whole system so by ........using admin panel how I can edit comments and delete records?

Please keep in mind whole cenrerio and help me out by suggesting and answering all these questions or especially if you will give code then I will so much thank full and great full to you for this great favor.

Further more for currently I am using this database code to store values

CREATE TABLE  `agents`.`feedBack` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`firstName` CHAR( 40 ) NOT NULL ,
`lastName` CHAR( 40 ) NOT NULL ,
`Email` VARCHAR( 50 ) NOT NULL ,
`agencyName` VARCHAR( 50 ) NOT NULL ,
`CeaNo` INT( 20 ) NOT NULL ,
`TelePhNo` INT( 20 ) NOT NULL ,
`DisplayName` VARCHAR( 15 ) NOT NULL ,
`ratePAgent` INT( 1 ) NOT NULL ,
`Summary` VARCHAR( 1000 ) NOT NULL ,
`date` DATE NOT NULL
) ENGINE = INNODB;

and this php code to retrieve data and then to present that on page.

<?php
require 'connectDB.php';

       $query = "SELECT * FROM feedBack ORDER BY id DESC ";
       $result = mysql_query($query);

       while($row = mysql_fetch_array( $result )) {
	      
[INDENT][INDENT]// Print out the contents of each row into a table
echo '<img src="images/'.$row["rateAgent"].'.JPG" height="16">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
First Name:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.$row["firstName"].'<br>Last Name: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.$row["lastName"].'<br>Agency Name:&nbsp;&nbsp;&nbsp;'.$row["agencyName"].                            '<br>Experience:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Would you like to use this agent agian?<img src="images/'.$row["useAgain"].'.JPG" height="20">
           <br>Date:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.$row["date"].
                            '<br><br>'.$row["Summary"].'<br><hr>'; [/INDENT][/INDENT] 
      }
?>
1
Contributor
1
Reply
7
Views
5 Years
Discussion Span
Last Post by shujat132
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.