Posts by drjohn

You are extracting from two tables without a join condition???
why?

"Compact and repair feature in 2007 and 2010 does not fix the file size."

Really??? I just made a very simple little access 2007 database, put some data into it, edited field contents with large copy and pastes, deleted records etc, with saves after every edit, and after each time I ran the compact and repair tool, the file size was reduced.

Now if your database file is large, you may not notice a change in size from say 15,000,490 to 15,000,050 and get the impression its not working as its size could be reported as 15,000kb each time But on my little 400kb db, changes up and down of 10, 20, 50, 100kb were easily spotted.

Also, if you are running the compact and repair every time you edit a single record, then the before edit and after edit and compact repair size can be very very similiar. So you wouldn't see much difference at all. Try running it after enough edits that you can see the file size has increased after a while.

I didn't bother testing it in my access 2013 copy however.

PS I can't be bothered counting through the closing brackets to place echo $count at exactly the right place, so it might be later in your code. Try moving it down one closing bracket at a time yourself if it doesn't appear or appears several times.

you've answered your own question - just use a mix of <article>, <section>, and <div> tags.

So apart from placing an advert for that web company of this forum, what do they have to do with learning to design a web site???
Nothing.

1 - do this step first
2 - do this bit second
3 - do this step next

. buy onions
. buy potatoes
. buy milk
. buy steak

first is an ordered list, second is unordered list

Perhaps you could avoid telling users the name of the back-up folder and the file name, as well as restricting access to that folder. And place an index.html file in the folder with nothing in it, or saying something like silly like a link to the home page, so users cant see a file listing for the folder.

Try telling your boss that getting a total beginner to design a web site is not a good idea and not cost effective, as you will spend a long time learning things and make many mistakes. It is very much cheaper to hire someone who knows how to build a site than spend months trying it yourself and failing badly. Your SEo knowledge will be none existant for example, so even if you get a site built, it is extrememly likely that you will have the wrong tags in most places and thus your on-page SEO will be extrememly poor while a professional can do it without haveing to think while building the pages.

It would be a lot easier if you gave us a url so we can see what is happening and play with it there, without having to create our own copy of your page.

The human brain.

Seriously, there is no "best software". Everyone will simply recommend the software that they use. So here goes.

I use NotePad++, which is used by many, many professionals.

I tried Blue Griffon recently and thought it was good.
I tried Brackets, and thought it was good, but I did something wrong when I installed it and haven't had a chance to re-install and then read how it is supposed to be used.

It's much easier to list really bad software:
Serif Web
Frontpage
ANY software that says "no need to learn programming just drag and drop".
ANY software that is a word processor or desktop publisher with a Save As html feature.

Some people will tell you that dreamweaver is brilliant, others will tell you that it produces really bad code, but the bad code is produced by people who use dreamweaver but don't know anything about web design or code, so use it very, very wrongly.

You can use any program the wrong way and produce code.

No software can make up for a lack of knowledge and a lack of skill and imagination.

Hence, the human brain it the best tool to use.

Did your homework get a good grade after these guys helped you?

Several content management systems, such as wordpress and joomla have modules you can use to mark pages as only available to subscribers (and to provide some pages marked as free to view that contain a free section from some of your content, so users can see if it is worth paying to get at your content).

Some of these modules / plugins are free as well. Just like Wordpress and joomla.

Install one, get members to pay a subscription, and put most of your content on the subscribers only pages.

Simples.

Have you never seen this done on a professional blog before? A pay to learn site?

I use the full url, as in http://sitename/images/favicon.ico where you just have images/favicon.ico

Your first step, outside the loop, should be to print the the first two numbers that you are seeding the array with
echo $prev[0];
echo $prev[1];
then continue up to your target value in the loop.
but loop like htis
for ($i = 2; $i < $nr; $i++)
or you will go two steps past the limit the users asked for.
Simples.

A service that helps you with forms and emails was mentioned in a forum thrread I read elsewhere today.

http://phpforms.net/

I've not tried it, but for someone who struggles with html and php it might be ideal. There's a free version for a small number of emails per month,

You have no need for the value column.
Just a simple one column table, where status is a varchar. No need for joins, use it as a lookup table in queries to populate a drop down options box in a fomr a user completes.

It's a common beginner's mistake to add a numerical id value to a single column table under the mistaken belief that all tables need a numeric id. As there will NEVER be two different statuses with the status Open or Awaiting, etc, the status forms what is called a natural key. It uniquely defines itself. Using a number to reperesent a word means that the value then has to be "translated" into th eword by carrying out a totally unnecessary join to get at the real word.

You would only need a numerical id if there were other attributes associated with a row in the table, such as assigned, date, owner, and so on.

google for free email form services.
There are many, and they usually include an advert for themselves in the email sent. But as it is going to yourslef, that doesn't matter, does it?

They give you a bit of code to stick on your pages.

If it is a site you own, you should have the development oroginal copy on your pc.
If it is a site you are taking over to edit, use ftp to download the entire site.

If it is a site you wish to examine that belongs to someone else, HTTrack is your best bet, but if it does belong to someone else, why do you want a local copy?

I just created your table on my local server, moved the } in the while loop to AFTER the last ECHO, so I could see the row you used and a new row I inserted without entering a created_date. I got exactly the expected result - two sets of data, your original single row data set and my new row with the correct created timestamp.

My local server version: 5.0.24a-community-nt - older than yours and it worked.

I'm afraid this simply makes it even stranger, as your table definition worked, your insert worked, my manual insert via phpMyAdmin worked, and your php code worked!!!

I can't see in a single row table the position of that closing } of the while making a difference, but at least try moving it to the correct place and see what happens - otherwise you will always only see the last row found's data.

Give the sub menu a high z-index - the Professional Education bit is sitting over the flyout menu.

I set for cat ul z-index:50 and it worked, you probably don't need as high a value as that, but I didn't bother looking for a smaller answer.

That's normal with floats.

When you have a set of floats that have to line up, you discover that the next line hits the bottom of the tallest item in the previous line and stops there.

The solution is simple - set a min-height based on the tallest item expected in those divs.

Your site uses what is termed mystery meat navigation - areas that have to be prodded to find out what they are. This has been considered a bad interface for the last 10 - 12 years ! Enter the 21st century by giving them a normal navigation system.

Next, you have a background image that is a 2.5Mb image - this will slow down all users. Save it as a jpg (you have named it a jpg, but it is actually a bitmap file!!! Changing the extension is not converting the file type.)
When I converted it to a real jpg, it shrunk in size by a factor of ten to 262Kb , which will greatly please your users, especially those using a mobile phone with a low monthly data transfer limit. (Even 262Kb is a bit big, but it beats your original image out of site/sight)

Define the number of changes you will accept before you start charging more for the extra work.
Don't work for free!

why make life difficult?
one form, one file, one other file called to do the submit (and validation)
second form, second file, second other file called to validate and submit.

This is SOOOO much simpler, safer and easier to write and troubleshoot than a more complex system, which you've just said you can't understand, so probably can't troubleshoot for errors!
KISS rules.

And if you can't write simple code, why look for a more complex solution???

Then you don't have the correct set of relationships! You can't have the correct foreign keys between the players, club and nations. Because I made sure that the test data set I used DID have each club linked to a nation and each player linked to a club, and I got back exactly the correct rows that I expected.

So, write down a set of club and nation data and match the foreign keys so that a link is correctly established. Then add a couple of players with foreign keys that link them to an existing club and nation.
OR
You could print out each table's contents and scrutinise then to make sure there is any data to be returned. Change a few bits to match existing clubs and nations in your player team.

Although eventually you are going to have to fix the wrongly normalised tables (and then your queries) as at present you can only have one club per nation, as I said earlier. Working with badly designed tables just doesn't help.

Look for any simple slide show that does that - www.cssplay.co.uk/menu has a couple of examples that do that. Using css.

this isn't quite what you asked for
http://www.cssplay.co.uk/menu/magnify.html
http://www.cssplay.co.uk/menu/image-bounce.html
http://www.cssplay.co.uk/menu/zoom-gallery.html
http://www.cssplay.co.uk/menu/css3-image-enlarger.html
http://www.cssplay.co.uk/menu/zoom.html
http://www.cssplay.co.uk/menu/cssplay-popbox.html

but they work. And there are other similar things there

the Web Developer Toolbar that was mentioned has a Chrome version.

I use it all the time, especially the edit css tool which is how to do a trial edit and see the result, without touching your real css file.

Posting the jquery library is not going to help with a css color change.

You have the field `club_id` int(11) NOT NULL COMMENT 'Foreign Key', in the nation table
This doesn't make sense.
It implies that each nation only has a single club in it.
It would make more sense to me if the club table had it's nation id in there as a foreign key - which then suggests that a nation has many clubs in it.

So check your normalisation again.

Why have you got all those fr_ in front of almost every field? They serve no purpose other than to give you more typing to do and increase the risk of making a typo.

Also I'm willing to bet that no two nations have the same name - there is only one Scotland, one Germany, one Denmark. So you don't need a numerical id for the nations table acting as the primary key, the name of the nation itself is the correct, natural primary key. Using the name as the primary key will reduce the number of joins you will regularly require, as the numerical id always forces a join to find the nation's name. But using the name as the PK means you already have that info in the player table.

It's a common beginners mistake to assume that a numerical id field is always required, when there is already a unique natural primary key present which will simplify things.

Example

color table
1, red
2, green
3, …

This is possible using php via the gd library. Most installations of PHP now have this library installed by default. With this library you can draw graphs and resize images at the server end and deliver optimised graphics that way from a single image.

you can do the same with the Imagick library. google on resizing images with either of these. It's simple.

here's the first site in google I found, which covers both methods.
http://www.fliquidstudios.com/2009/05/07/resizing-images-in-php-with-gd-and-imagick/

But your pages must be php pages of course.

typical inaccurate stuff from w3schools !

have a quick look at www.w3fools.com and learn why you should treat that site's lessons with care.

What your code does is just a typical way to style your menu, which you should create as an unordered list.

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.