drjohn

FrontPage is to web development as a shotgun is to marriage - you can force it to work, but it's crude and nasty, and not true love. You'll have to learn web development. Sorry, but there is no easy way out.

fields in a table: id firstName surname dob mobileNum shoesize city eyecolor job roomNum socialSecurityNumber Superkey is any field or combination of fields that can uniquely identify a row So the following are all superkeys id id, dob id, socialSecurityNumber socialSecurityNumber socialSecurityNumber,job socialSecurityNumber, job, dob socialSecurityNumber, city, shoesize id, socialSecurityNumber, …

edit your formtoemail.php script to exclude these bits.

You can set up your own test bed server on your home computer, using XAMPP Lite, for free, and have MySQL and PHP running under Apache within minutes. This enables you to reliably create and test your PHP/MySQL code. It also matches what you are being taught at college, and …

Whatever size the frame is, the size of the page inside it is determined by that page's design and amount of content. Assuming it's the Tropical Fish News page, how about having less news? But honestly, why worry about it, your visitors will decide whether they wish to view it …

Without viewing your actual website, it's a bit tricky to guess what the problem is.

display:block is the default style for a div, therefore it is not necessary to state this the vast, vast majority of the time, as a div is by definition a block. And block level elements sit under each other. The normal way to get divs to sit next to each …

As well as the css methods in the last two responses, you can use javascript. This is necessary if you wish you site to look the same in IE as in firefox and other modern browsers. Because IE doesn't yet support the css required -moz-border-radius:15px; <-- for older mozilla browsers …

Normally you will have one file which holds the connection details for the database (host, database name, username, password). This should be present as an include file. So you just change the appropriate bits of that file to match what the online provider has given you. (I keep one copy …

Your code says this. [code] <p align="center"><a href="http://www.ariahost.net/news.htm"> اخبار </a>- <a href="http://www.ariahost.net/aboutus.htm">درباره ما</a> - سوالات متداول -<a href="http://www.ariahost.net/support.htm"> پشتيباني</a> - <a href="http://www.ariahost.net/contactus">تماس با ما</a> -<a href="http://www.ariahost.net/map.htm"> نقشه سايت </a><br> تمامي حقوق اين سايت براي شركت آريا هاست محفوظ است . © 1382 - 1389<br> Copyright © 2003 - 2010 AriaHost.net …

In simple terms, age is a calculated value, which will change with time. So NEVER store it, calculate it, as shown in the first answer given. Then it will always be the correct age.

Why are you wasting your time with tinyint, which as pointed out, has a max value of 127??? Just use int.

Or you should do it the way everyone else does, create a wrapper div around the content and give the div the width. Then every paragraph inside that div will be constrained to that width. It's not normal to give the p tag a wdith.

You probably need a wrapper div around the content, set to a width that matches your design and that will work in most viewport sizes. If you are designing for the viewport being at full screen it is very common to run into this sort of problem. But as you …

What he says ^ And you can do this from a single form by using a series of queries, one after the other, each with it's own connection. (MySQL can't chain queries, each has to be a separate event.)

In a database, the order of the columns in the table is TOTALLY irrelevant. The same is true for the order of the rows. This is an important basic concept in relational databases. In other words it just doesn't matter at all, you write your query and STATE the columns …

It's a table of data, use a table, that's what they were invented for.

Set width:100% and height:100% for the image However this will always distort the image unless the div is the same size as the image. A background image is a valid thing in ALL browsers. Are you thinking of positioning your links over specific parts of the image? If so, what …

no comma required after StoreName) in the first table definition

Entering an ID will not get the other fields filled automatically. you'd have to run a query on the ID and the table, then recreate the page with the data place and send it to the user.

Because I believe that some processing takes place on Google's server to make it work. I think (but I might be wrong) that you having the font on your server is not going to work. I haven't played with these fonts on google because when first looked there were only …

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 …

No, it is NOT a database, it's an object orientated class definition for connecting and querying a database.

Start again, with less divs. Especially less deeply nested divs eg [code] <div class="colmask holygrail"> <div class="colmid"> <div class="colleft"> <div class="col1wrap"> <div class="col1"> <div class="content"> <ul class="menu"> <li class="home"><a href="index.php?module=home">Home</a></li> <li class="hair"><a href="index.php?module=hair">Hair</a></li> <li class="beauty"><a href="index.php?module=beauty">Beauty</a></li> <li class="tanning"><a href="index.php?module=tanning">Tanning</a></li> <li class="contact"><a href="index.php?module=contact">Contact</a></li> <li class="navend"></li> </ul> [/code] The menu is nested …

WHY would you need this info? All current browsers support css2, no browser supports more than a couple of bits of css3. The latest versions of firefox support a few more bits of css3 than most other browsers, but as css3 is still only at the discussion stage, you should …

just change the image used in the hover bit background: url("rollover-image2.gif") 0 0 no-repeat;

as above ^ Your table is not normalised and forces you to use bad code to find the children. Imagine checking to see if fred has a child called jimmy - you'd have to query each column via an or, whereas with a proper;y normalised database, you'd just search on …

Just visit the web site without adding a page after the domain name. What you see is the index page, the default page shown for the domain. you have been doing this for years when browsing the web.

Just edit your PHP script to send it to two destinations. Normally you build up the message in steps from each field, so just add a bit for a cc as well or if you don't want to do that, repeat the entire code in the same script, but with …

You can't use html and css to do this. You will need to use PHP - use google to find php uploader scripts. Of course the question then arises - what are you going to do with these images and things? If you plan to use them to dynamically style …

Give the li a href of the menu some padding (equal to the width of the icon) to push it in a bit from where the icon will appear.

You are linking to folders with your code. Without an index page, your system is returning instead a file listing, which always does what you don't like. So make an index.htm page for each folder, listing the files and linking to them. And make the link not to the folders, …

edit your css to include img {border:0} If you want rid of the underline on all hyperlinks, also add a {text-decoration:none;}

[url]http://validator.w3.org/check?verbose=1&uri=http%3A%2F%2Fwww.corporate-event.com.au%2F[/url] 27 errors. So start by correcting them, where possible. You should not be using the center tag, use standard ways to center your layout. i.e. Add a <div id="wrapper"> around your entire content inside the body, and set its margin:auto; and give it a width of 750px (it doesn't …

WHY would anyone want to sign up with an unknown email provider, when they can use major free providers such as gmail or hotmail, with more facilities?

order by is ordering it in alphabetical order in your opening post. that's why you need a different approach, using the date data type and then getting at the year and month. (which are stored as numbers)

Remembering of course that w3schools tutorials are well known to be out of date or contain errors, and they have no relationship to wc3, the web consortium that sets web standards...

use a background image that is semi transparent.

And not every server is set up to use server side includes. Which has annoyed me several times in the past.

position:relative. Always. Float divs to get them side by side.

<h3><span>content in here</span></h3> h3 span{css in here} You do know you can give the h3 tag a width... Also <span class="h3"> </span> is probably invalid, as h3 is reserved as a tag name.

change float:left to float:right on line 197

REQUIRE "connect_to_mysql.php"; means you must have a file of that name, which will then contain your connection details. So, is the opening bit of PHP code you give saved in a file called connect_to_mysql.php and in the same folder as the other file that uses it?

[QUOTE=MJ Pieterse;1236458]i would say CSS and if you want extra stuff added to it to make it look a little more 'cool' then you should use jquery or java. I strongly suggest to never use a pure jav menu as some people have java turned off and they won't be …

Because you told it too... [code] #nav > li:hover { top:5px; background-color:#3d3f44; -moz-border-radius:10px; -webkit-border-radius:10px; border:1px Solid #999; } [/code] top:5px; is pushing it down by 5px. change it to zero or delete it and it will stop moving.

Without your actual homework scenario, we can't make it relational. And I don't do other people's homework, although I might point out errors and give hints if you attempted it..

[url]http://reference.sitepoint.com/html/base[/url] It's something I've never seen used, but the above explains it. I'm surprized you're seeing it, as I haven't seen it in the ten years I've been working on web pages.

Extract the files, and try loading them into a spreadsheet, such as excel. Then save as as text file, tab delimited. ~then create your database tables with th ecolumns in the same order as in your file. then use the mysql load data infile or load data local infile command …

Why not just do it in the programming language BEFORE the query is submitted? eg if (referenceID is null) referenceID = attID because your problem is NOT a database query one, it's a data entry one.

Run a query to count the number of records. Then use an IF statement in your programming language (PHP?) to use one of two queries - one your original top five / bottom five union, the other is just a select with no limit. This is not a database problem, …