Posts by drjohn

Make your last join, the one to the comments table, a LEFT OUTER JOIN

yes

Set the small screen css first in the normal way. Then use javascript to over ride this with the wide screen version. No need to mention the small one in the javascript.

you could try looking at the code used...

<div class="map">
		<iframe marginheight="0" marginwidth="0" src="http://maps.google.co.za/maps?f=q&amp;source=s_q&amp;hl=en&amp;geocode=&amp;q=4+chester+drive,+bishopscourt&amp;sll=-33.991125,18.442891&amp;sspn=0.010942,0.01929&amp;ie=UTF8&amp;hq=&amp;hnear=4+Chester+Dr,+Bishopscourt,+Western+Cape&amp;ll=-33.984648,18.447247&amp;spn=0.021707,0.085745&amp;z=14&amp;output=embed" scrolling="no" frameborder="0" height="425" width="1000"></iframe><br><small><a href="http://maps.google.co.za/maps?f=q&amp;source=embed&amp;hl=en&amp;geocode=&amp;q=4+chester+drive,+bishopscourt&amp;sll=-33.991125,18.442891&amp;sspn=0.010942,0.01929&amp;ie=UTF8&amp;hq=&amp;hnear=4+Chester+Dr,+Bishopscourt,+Western+Cape&amp;ll=-33.984648,18.447247&amp;spn=0.021707,0.085745&amp;z=16" style="color: rgb(0, 0, 255); text-align: left;">View Larger Map</a></small>
</div>

They show the larger map by simply linking directly to google maps

summarising the code

<div class="map">
<iframe src =link to show google map>

</iframe>
<br>
<small><a href=....>link direct to google maps</a></small>
</div>

Very easy, if you look at the code.

I told you, when you float things, you take them out of their normal position. The result of that is that the div has zero content and zero height, so you can't see the background. Give it a height and float or no float, the background will be visible.

When you remove the float style, it is back in the normal flow of things and the div has a height, so you see the background.

try giving the div left_b a border and you'll notice that the floated divs are outside of the div, unless you give the div a height.

html says #
<div id = "left_">

css says
#left_b

Also left_b would need a height to display the background image. (Floating the divs inside it takes them out of the normal document flow, so the div appears empty with zero height, so the background is not visible.)

Finally, there is no doctype - use a strict 4.01

You don't "get" css from anywhere, you don't "download" it, you don't have any "cost", it just IS. I.E. it's part of how web sites are built.

It sounds like you need some tutorials on what css is and how to use it, and probably some basic html tutorials as well.

building a website without using css is a really bad idea, and it would take too long to explain every reason why it is a bad idea.

here's some places to get help with css

www.cssbasics.com
www.htmldog.com (includes htlm help too)
www.westciv.com/style_master/academy/css_tutorial/

this is a good general guide to building a web site
www.webdesignfromscratch.com/basics/
and you could try reading every article there.

PS w3schools has much code that is out of date, although they do seem to be trying to get into the 21st century now. So if more modern sites contradict them, believe the more modern sites.

Don't think you need the [ ... ] around CreditLimit

If you've done it, tell us what you did and we can tell you if you are right or wrong (your original post has errors)

The correct answer is to make your wrapper div, give it a width, and set margin:auto. The bit about text-align is an old technique used when you work with ie6, and then it requires more code to overcome the text being aligned centre. Also only about 10% of users are still on IE6, so don't worry too much about them with this particular bit of code, to be honest.

also the advice given was incomplete anyway. you should have set text-align:center for the BODY, then text-align:left for the wrapper div to get this to work in ie6 (all other browsers understand margin:center.

BUT you must use a doctype. Google on it an duse html 4.01 strict or at worst html4.01 loose. Without a doc type, IE will be in quirks mode and screw up your layout.

Create several sets of separate queries, each stored in a password protected folder, one for each group.

The queries simple retrieve what each group is allowed to see.

Included a posted_by field in the database and the queries.

Perhaps the lecturer said standard three column layout

It's not an official name or anything, just something many people call it.

There's also the joke name of "Holy Grail" layout

Who said anything about absolute?

No-one.
it was a comparison of how one way of positioning is well know for causing problems, while another way is well known for solving problems. But you thought that the one that often solves things was a source of problems. That's all.

And of course there are lots of different ways of solving layout problems.

If you dump ALL the styles in the head (css file and the repeated css styles embedded in the head) and set border=2 for your table (TABLES!!! it's the 21st century!), then you will see that something is throwing an extra something, perhaps a td, at IE, sitting between the table cell containing your resources and the cell containing your image map. But I haven't found what the something is yet.
And I'm not totally sure it's a table cell to be honest.

What format are the images in?

Also, creating a web page using MS Word, or any other program not originally designed to create web pages really does make helping you very difficult, as the page will be full of rubbish whose sole purpose is to convert it back into a word doc.

If you give the divs horizontalnav and minihorizontalnav a height they will appear. Currently it's as if they are displaying at zero height, so you can't see the background color of these divs, so the menus show as white on white, outside/below the divs.

Alternatively if you give the background for the body a colour, they also show up.

this

WHERE thread.threadid = threadoffering.threadid AND where threadoffering.year AND threadoffering.season = currentDate AND where threadoffering.User > 1 AND threadLocation = CS

has two WHEREs in it. Start by changing it to this

WHERE thread.threadid = threadoffering.threadid AND threadoffering.year AND threadoffering.season = currentDate AND where threadoffering.User > 1 AND threadLocation = CS

Then run just the query to check that it returns the correct data.

After that, the update can be considered.

I was serious.
Writing javascript whose sole purpose is to create create something you can more easily create is straight html is not a good way to build a web page. Yes, you could use javascript to write some variable content to an area, but not to write your basic html and layout divs.

PS the reset seems to be lacking a closing } , but I'm assuming that was just a typo here and it is correct on the actual web page.

Dump the totally unnecessary javascript!!!!

Write html.

In my opinion this is the best reference:
http://matthewjamestaylor.com/blog/perfect-3-column.htm

That's one overly complicated way to get a simple three col layout!!!

<div id=wrapper>
<div id=header>
</div>
<div id=left>
</div>
<div id=content>
</div>
<div id=right>
</div>
<div id=footer>
</div>
</div>

That's how the rest of the world does it. With left, content and right all floated left. body has margin 0 and padding 0. Wrapper is given padding 0 and usually margin 0 auto. Width for header and footer usually the same as wrapper, and they both have margin 0 and padding 0.

Job done.

PS Formal name? ? ?

I think you'll find that's exactly what the Frankey gave you.

Or you can try http://www.cushycms.com/

A link to the page so we can examine more than three or four lines of code will help! (although it does look like the reset should have helped)

You have to use some programming language, usually PHP.
HTML is just for mark-up (hence the name) - it isn't a programming lanaguage.

To store the comments, you'll need a database - MySQL is the commonest one you'll find from web hosts.

Then you'll use SQL, another lanaguage, to retrieve the comments, and PHP manipulate the data returned and to display the results using PHP.

Yes, way off base.

Position:absolute is dreadful, while position:relative often SOLVES problems with other things.

If divs are physically overlapping, that means you have some strange code elsewhere that is the real problem.

No

Select * from friends where name1='james' or name2='james';

OR

Select name2 from friends where name1='james'
union
select name1 from friends where name2='james';

This second one is most likely what you want as it gives a list of just the friends' name.

It appears to be related to the lack of any height info, not necessarily just the border. A border means it has some physical height attached to it.
Adding height:1%; or min-height:10px; or something similar gets you back to the first page's layout.

If you cut out the entire declaration for #TopMenuBar it also goes wrong.

So it is possibly a case of a totally empty declaration being assigned a default padding or margin to give it some size.

overflow:hidden; for #TopMenuBar also cures it.

total time to notice overflow:hidden; cured it - ten minutes.

Uninstal, re-install, and ignore the tutorial.

Or uninstall, and install xampp lite instead.

Both sets of applications will be supplied with a user and a password already, so changing things means you have to configure phpmyadmin to use the new username and password. Reinstalling is probably quicker.

A union is used when a set of columns with the same name and same data-type are present in two tables (or the same table but two aliases, and you are querying on two exclusive sets of conditions) and you wish to present the combined data extracted from each table.

A join is used when you have a primary key in one table that is a foreign key in another table and you wish to pull the data from one table that matches the key from the other table.
eg emp{empID, name, address, universityID, etc}
University (universityID, uName, uAddress, etc}

and you want the employee's name address and the name and address of the university that they attended.

So you join the two tables on employee.universityID = university.univeristyID

http://dev.mysql.com/doc/refman/5.1/en/mysql-indexes.html

http://www.tizag.com/mysqlTutorial/mysql-index.php

The result is very much faster queries. You set indexes on the fields that you are most likely to use in queries' WHERE clause. Primary keys are automatically created with an index.

Without indexes, MySQL will start at the first record in a table, and read through the entire table to find all of relevant records. If the table has an index, MySQL can find the position of the data in the middle of the data file.

You can add an index to an existing table -
CREATE INDEX employeeid ON myTable (empid);
or if you were creating a new table, you'd add at the end of the create table code eg .....INDEX(empid) }

Unless you have many millions of records in the table, one table and a current_student field would work okay. Adding an index or two would speed things up. The primary key will automatically get indexed, but in this case adding an index on current_student would be an excellent idea.

One table may also simplify things when you need data on past and present students in a single query.

(A field called type risks type being a reserved word in your programming language, so current or current_student is probably a better field name.)

Have you tried feeding these queries directly into the database, not generating them / choosing them via your php code? You should always start by checking the query itself is correct, then using the php to choose which of your now tried and tested queries to use.

The %Y%m%d are formatting instructions used INSIDE the date_format() function. Outside that function they are probably totally meaningless. They are probably being interpreted literally and may not be valid characters to include in a table name, unless the entire name was quoted, which would then cause you problems of having to use quotes in evvery query of that table name.

So if you are expecting the table name to turn into outgoing_20010-03-28 you will have to find another way to get this name.

Arrange the order of the columns to match that of the database, and every column in the database must have a matching column in the spreadsheet.

Export the data from the spreadsheet as txt (tab delimited) not csv.
no column headings, as already mentioned.

Run a query like this.

load data local infile "C:/Documents and Settings/dr john/My Documents/logpile/AccountDataExport_2010-03-26.txt" into table mycounts;

I do this every week to update an online database with an extract from an offline one.

I do this remotely using SQL Manager Lite for MySQL, which is free from EMS.

clear takes one of four values:
none (the default)
left
right
both

ALL is not an option. so the browser is guessing that you don't know how to use clear and trying something else. IE8 is more standards compliant the IE7, and may not be applying the same correction to your faulty code.

Also, it would be <br style="clear:both" >, not <br clear=`all`>

Well, some other part of your code elsewhere is breaking the system, because I just made a test page using your code, and the colour was applied the same in FF and IE7, exactly as I expected it would.

I also stuck a link outside your table, gave it a different color and it worked too.
Do you have a sample page online where we can look and see what else is going on?

PS You are not really using tables for layout purposes, are you??? That is literally soooo last century. Tables are for tables of data, not layout control. CSS is for styling, including the size and position of divs, and thus for layout control.

you appear to be testing for a space being entered, when you should be testing for an empty field.

Try this instead

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

$uniqueT=trim($_POST['uniqueidT']);
$fnameT=trim($_POST['fnameT']);
$snameT=trim($_POST['snameT']);
$tottreat=trim($_POST['tottreatT']);
$treatcom=trim($_POST['treatcomT']);
$ampay=trim($_POST['ampayT']);
$filelink=trim($_POST['filelink']);


if ( $uniqueT == '' OR $fnameT == '' OR $snameT == '' OR $tottreatT == '' OR $tottreatT == '' OR $treatcom == '' OR $ampayT == '' OR $filelinkT == '')

{
echo "error please enter data in all the boxes <br/>";
echo "<a href='laserclearentry.html'> click here to go back to entry page</a>";

/*rest of code here */

trim() will remove any leading or trailing blank spaces, so if there is only blanks, the variable becomes a null, then the tests in the if are for nothing - i.e. that is a set of single quotes, not one double quote. The rest of the code would be the same

UPDATE tblclients
SET password=sha1(password)

That's it done in a single query.

The value from sha1() is returned as a binary string of 40 hex digits, or NULL if the argument was NULL.

SELECT is to find things, not alter them.

A color not being supported in IE7!!! Total nonsense. Be serious!

As for the original question, seeing a bit of code might be more helpful, so we can see what you've done wrong rather than just guessing.

If you mean wrap the text (scroll means move/animate it), you have to put the table in a div of a given size, probably floated left or right , and the text outside the div.

or more likely like this

<div class="outer">
<div class="inner">
table bit here
</div>
text in here
</div>

the above gives you more control as you can set widths to outer and inner, and set any other attributes you fancy as well.

try this instead

$sl="INSERT INTO stud (name,CID) VALUES ('$_POST[name]','$id')";

PS also try echoing the $id to make sure there is a value

First, use alter table to add a new field called password2.

Then run an update query to set password2=sha1(password)

I strongly suggest you make a practice table first, of course.

Then, use alter table again, this time to remove the password field and then to rename password2 to password.

You could perhaps make this into a script in your programming language - PHP probably - where you set it the table name and it does all this.

Again after practising the first set of commands, make a script to do this and run on another practise table first, before letting it loose on the real thing. Because you'd better be sure it all works before deleting the original password field.

project---equipment is not correct

project---employee is not correct.

Have another think about these.

Think more about this line

"Many clients can arrange a viewing for a property."

edit your formtoemail.php script to exclude these bits.

Why do you have quotes around the table name and column name? I've never done that.

Pages you didn't want the search engine to index.

Okay, to be more specific, log-in pages to admin sections of a site.
Any other admin type pages, say for a CMS.
Members areas that might include a set of tutorials or pdfs or private info of some sort.

Well I copied your code and viewed in in Firefox than IE Tester as IE6, and it looks the same in both.

and from the words

for IE6 (maybe the higher ones are affected too)?

Are you only testing things in FF and IE6?? That's a bit risky.

Is the database being told to store 1980-03-01 or a unix timestamp or a day in the year number, which when read back gets converted to 1980-02-29, based on its day number.

Just use it as if it was a foreign key!

A true foreign key would enable you to enforce relational integrity, but you can work with a database without it actually being enforced. You just carry out joins in the usual way and they work.

What you lose out on is not automatically getting a warning when there is an error such as no parent record for your foreign key eg foreignID should be 1023 and you entry 1032, for which no record exists in the other table. This would be accepted in MyISM but rejected in InnoDB.

Use PHP - it is the standard way to talk to a web based MySQL database (or almost any other web based database). It will almost certainly be installed already on the server.