TECH6.0

UaECasher · #21 16-10-2008, 07:31 PM

I'm thinking of making the primary key in properties table (property_ID) related to customer_property (in customers table). so that when i add a customer it will ask me to add a property to it. do you think this will work?

what concern me is what if the customer have 2 properties?

UaECasher · #22 16-10-2008, 07:49 PM

hello can u tell me what did i do wrong here ?

Code:

<td style="background-image: url("http://project.casherz.com/images/linkbar.png"); background-repeat: repeat-x" height="23" colspan="2"><a href="http://project.casherz.com">Home</a></td>

webwizzy · #23 16-10-2008, 08:02 PM

Cant figure it out at a glance, what is the problem you're having with the code ?

1. I think you're missing a ; after repeat-x
2. And try removing the double quotation marks from the image URL.

UaECasher · #24 16-10-2008, 08:16 PM

hmm still not working, I'm trying to make the image "http://project.casherz.com/images/linkbar.png" to show as a navbar and enter links in it

please help

webwizzy · #25 16-10-2008, 08:37 PM

Why not create an external stylesheet for your website and store all your most commonly used CSS there.

And for the navbar, use CSS like this:-

HTML Code:

.navbar
{
background: #6495ED url(http://project.casherz.com/images/linkbar.png) repeat-x top left;
color: #FFFFFF;
font: bold 11px tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;
}

and then simply insert links in this manner:-

HTML Code:

<table>
<tr><td class="navbar">
<a href="http://project.casherz.com">Home</a>&nbsp;|&nbsp;		
<a href="http://www.tech555.com/forum/usercp/">User CP</a>&nbsp;|&nbsp;
</td><tr><table>

This is the best way you can create your navbar. Simply add up the links within the <td>

UaECasher · #26 16-10-2008, 08:54 PM

thanks for the help

UaECasher · #27 16-10-2008, 09:00 PM

Code:

.navbar
{
background: #6495ED url(http://project.casherz.com/images/linkbar.png) repeat-x top left;
color: #FFFFFF;
font: bold 11px tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;
text-align: center;

}

the text alignment is not working check it out

project.casherz.com

webwizzy · #28 16-10-2008, 09:40 PM

center align the table then

HTML Code:

<table align="center">

UaECasher · #29 21-10-2008, 04:36 PM

ok bro, any ideas how to make only a certain number of properties show on one page and the rest will be added on a new page, just like the no. of posts in each page

webwizzy · #30 21-10-2008, 04:47 PM

It is acheived via LIMIT clause.

Your query would be something like this:-

PHP Code:

  $perpage = 8;
"SELECT * FROM mytable ORDER BY `uid` DESC LIMIT $perpage";

Replace 8 with number of records to show per page. You'll have to create some kind of pagination system to show the next set of records. You can get some idea about pagination from a tutorial at vborg.

resumedocket · #31 13-08-2010, 12:15 PM

You would require atleast the property table and the user table.

moxet · #32 17-08-2010, 09:21 AM

If You Use Open Reality You Can Do This By Single Click..

Ennie · #33 19-11-2010, 11:44 AM

I think your question is about how to create the database table for your website. First you should create a class diagram for object in your project. Then you can translate those classes into database entity. This the standard way what we used in project.

DIXON.CARRY · #34 13-12-2010, 11:00 AM

Thinking of making the primary key in properties table (property_ID) related to customer_property (in customers table). so that when ...

sidharthbanyal · #35 21-03-2011, 04:16 PM

To make relationship between table you need to learn concept of foreign Key.
Foreign key is one which links one table to another table. It should be primary key in another table.

e.g.

I have a table Employee it contains information regarding Employee Designation.
structure is like this:

EMPDESGNO
EMPDESG

Another table to which i want to relate this table is Employee

EMPNO
EMPNAME
EMPDESG

Then EMPDESG in second table can relate to Designation available in first table and will contain values from EMPDESNO.

YOu can then later join them in queries for reterival of data.

mydiscoutlet · #36 14-09-2011, 11:30 AM

Even I plan to make a project in PHP but I don't have much idea about the language though I have heard it is quite interesting. I am into learning it now days.

newsky · #37 18-10-2011, 03:02 PM

Real Estate websites have this basic content:

(Alphabetized, none-the-less!)

Address
Basement type
Basement finished %
Bathrooms
1/2 Bathrooms
Bedrooms
Brochure (PDF)
Car Storage Type
# of Car Storage
City
Construction Type
County
Country
Latitude
Longitude
Lot Size
MLS #
Neighborhood Name & Website
HOA Fees
HOA Includes
Price
Roofing Materials
Schools
High School Name & Website
Middle School Name & Website
Elementary School Name & Website
Status of Listing (Sold/Under Construction/Pending/Active)
Square Feet
Taxes
Utilities (Avg.)
Year Built
Zip Code

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

TECH6.0

Building a Real Estate site in PHP