Posts by drjohn

OR
one table for dmr, another table for tuner.

But then if you add more product types, you'd keep having to add more tables, and it would get messy. The first way would handle any number of products types, each with a different number of different attributes.

product {pid, pname}
productattribute{pid,aid}
attribute{aid, aname, value}

would work.
This enables any product to have any number of attributes.

Normalise the data.

Or the easier way, create an ERD, then work out which attributes with each entity.
So you could give us a clue by stating what the dmr actually is, what the tuner is - what does it tune? engines, radio frequncies, etc. What do they do?

Is there any link between the dmr and the tuner (eg does a dmr use a tuner, or vice versa, or use more than one) or are they totally separate items? like a car and an aircraft.
You may know your data domains and field types, but we don't, yet.

So give us a clue.

Every robot that visits the site and checks out a link results in a "download" to view the file.
Webaliser does not distinguish between robots and normal users.
Try awstats. much more believable data from that.

ah, you beat me to it...

You're doing research, and you are asking for a topic on a web forum???

Speed comparision mysql vs oracle on a 100,000,000 row table, with and without indexes

The internal file structure of mysql vs oracle - a comparative study.

Advantages and disadvantages of mysql over oracle and access as a desktop system.

Conversion of mysql into a GIS

Efficiency of the mysql query optimiser (and optionally, compared to other systems)

Speed and efficiency of a mysql distributed database.

A better query optimiser for mysql.

When is it worth using an InnoDB or MyISAM or Aria, based on data types, and database size.

A comparitive study of mysql vs InfiniDB vs XtraDB - which user scenario suits each engine.

Well, you did ask for a research topic, didn't you.

If you are willing to let people leave a box empty/field on the form, then you can do either default null or select the null checkbox!
Both will give the same result.

If you check the not null box, it will fail to store the empty / null value that the form passes it. And report an error.

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

Use the above code for just the laptop,
then a separate if below that for the monitor, then a separate if for each of the others.

You could use an array and loop through the array, with the same sort of print logic (only print if !=0 or if greater than 0

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.

try experimenting with easing on hovering, google it.

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.

I know you want fluid shadows, PIE.HTC does that !

I simply mentioned a few other things it can also do, if you write the css3 code. I always make the pie.htc line the last one in a css declaration, and it enables older IEs to display css3 effects as intended.

Have a look here to see it giving very fluid shadows
http://lxavionics.co.uk/portables.htm
notice that the boxes with shadows are all different sizes. No images were harmed in making them.

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.

Use the standard css3 method to get your box shadow.
Then visit this site http://css3pie.com/
And use their behavior: url(PIE.htc);

No need for images at all.
The PIE file also lets you add other css3 effects for older versions of IE.
Like text-shadow and broder-radius I do hope you are not wasting your time using images for rounded corners...

"we will write all the programs using vb SIX.ZERO and mysql as database"

VB 6 is from the late 1990's - you are soooo out of your depth here!

An intranet is a private network inside the company! Things are NOT on the internet. And the intranet itself is not connected to the internet either, that's how you get security.

They may have a private web server inside their company, and they connect to that using browsers, but it is internal only. They may have a VPN that connects one base to the one with the server. But you or I can't get at it.

What this newbie's company are after is a server that they can run their existing software from - an ordinary network server. They do not want to put stuff on the internet. Our newbie is totally out of his depth here. They need someone with experience of setting up networks to establish a VPN between the two locations, and wire in ethernet around the builds. This is not a web project at all, and our newbie is trying to do this work with no experience of what is actually required.

My advice to him is to get out quick before they sue him when data gets lost or the business has problems he generates.

Google gives me, for some sites with a similar amount of traffic about £1 / $1.60 a day.

Ah - when I click on your menu items, I get thrown over to betting sites full page ads, I get anti malware advisors popping up saying don't go here. I get new windows opening...

Conclusion, I and most other people in the world will NOT return to your site, and you will probably earn nothing. Are you posting the url here as a spammer perhaps???

Typical homework problem.
First, you have to attempt it according to what you learned in class.
Then we might offer advice.

Payroll and accounting on the web?!!!

Totally insane and asking for major problems. If my last job had put my payroll details on a web server, I'd have been round banging on doors complaining like mad!

Only a total newbie would dare to suggest such an idea.

You might want to run your pages through the html validator...

http://validator.w3.org/

these might help you.

http://www.opencms.org/en/

http://www.opencms.org/en/support/tour/index.html

PS the default width for body is - wait for it, wait for it - 100%, so whether you set that in your css or not, the body width will be 100%.

When you use a single gigantic word with no spaces in it, it forces the container to be wide enough to hold it. The word will not break in the middle at random and have the remaining letters on a new line.
So you test is seriously flawed.
You should insert some spaces in that huge single word every 5 or six letters to get a more valid test.

Oh, if you look at your post above, you can see the text forcing its way out of the container...

Also, you shouldn't set the body width, you should put a wrapper div around all your content and set a width on that. This is much more flexible as now you can set a background for the wrapper AND a different one for the body itself.

Try using a tab delimited file instead.
I update 64,000 rows every week using a tab delimited file and it works every time.
Inventing your on type of csv file is never worth the effort when there are tried and tested methods.

If you want to practice with mysql / php you need a web server to handle this.
WAMPP and the like provide you with a local, private, test web server so you can do this. I use usbwebserver as it doesn't need to be installed and is totally portable on a usb stick, just unzip the files to a folder and it works, and you can make several folders each with a copy in it if you wish to work on separate projects, although you can work with a single copy just as easily. It's the ideal way to develop and test a databse driven web site - get it working at home, then upload to the real server. You are not adding "more junk" as you erroneously call it, you are adding the required server software. You wouldn't expect a program you downloaded to run without an operating system on your computer, would your?

IF you just want to play with PHP you don't need to use MySQL, but just playing with php will not help you much. PHP is used mainly to communicate with the web database and process the contents. Or run includes. But PHP still needs to run through a web server.

It sounds as if you are trying to run MySQL as a standalone program, in which case you are forced to use the command line. But on web servers, you need php to talk to the database.

Usbwebserver and the like are self …

The content in the header div is forcing that div to be wider than you want when you make the viewport width smaller. This then makes the content below your menu sit centered on THAT width while your menu contracts to match the viewport size.
Split the content in the header into two parts, one floated left, one floated right (containing everything but the logo on the left, a simple <span> would work or one extra div).
When the viewport gets too small to accomodate them both on the same level, one will slip under the other, the header will stay the width of the view port, the content will be centered on the width of the viewport, and the menu will fill the viewport.

I'll give you one guess why I know this will work ;)

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?

Query your database to collect the data
Use PHP to create a standard list with nested lists of links.
Create a standard menu
Use css to hide the bits you don't want initially shown
Use hover to reveal them.

If you wish to use javascript, use something simple, tried and tested, such as jquery / superfish.

You have a table certificate with an attribute result_id and that appears to be a foreigh key from a table called result. But result only has a SINGLE attribute - result_id.

Why are you storing this value twice??? The table result looks totally redundant to me.

Also, you have department with many sections, and section has its id in the equipment table. But department ALSO has its id in the equipment table. You do not need the department_id in the equipment table, that data is accessable from the section id by querying the section table. So I would drop the one to many link between department and equipment, removing the department_id from equipment.

If a section was assigned to a different department, you'd have to go looking for all references to the section in equipment and change the department_id, wouldn't you.

Does an employ work in a section??? you might need a foreign key of section_id in employee.

How does a task relate to anything? Does a task involve several bits of equipoment being used perhaps? Should there be a link table task-equipment perhaps???

Google search pagination in php
There are plenty of standard ways to do this, using mysql queries and manipulating the limit option to pull sets of images at a time from the database.

You might just want to check that your host actually supports mysqli - I too recently decided it was time to expand my skillset and do things in what appeared to be the modern way. Pity that the web host I tried my new project on hadn't set the server up for mysqli (client already had a site, so no choice in host), so I had to rewrite things the way I was used to.

If you do decide to switch and the host does support it, watch that in some cases the order of variables is swapped round - why, god only knows!

The html editor NVU is dead and has been for about four years, and was replaced with Kompozer which has a help forum (http://wysifauthoring.informe.com/forum/index.php) but that editor too hasn't been updated for a while, although the forum is active and helpful for beginners and occasional users.

The author of NVU and Kompozer is now working on BlueGriffin which I came across recently and that's quite a reasonable free wysiwyg html editor. So try that or kompozer to work with. I use Notepad++ a great deal as I prefer to write the code, but bluegriffon does look interesting.

You MUST start with html and css, and try really really hard to avoid inline styling.
www.htmldog.com is good for intro tutorials, as is www.tizag.com , mentioned above

Avoid using inline styling, just thought it worth mentioning again.

Java is NOT for web design, it's a heavyweight programming language for building applications, I think you are confusing it with javascript, which changed its name to sound like java, about 1996 to fool people into thinking they were related (it has successfully fooled generations of beginners ever since) But you should not play with javascript until you can actually write html and css. Javascript manipulates the html and css that your write, so you need these skills first, and can even not learn javascript for quite some time with no ill effect. Flash - ignore that.

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.

just replace IndividualFrequency in the second query with COUNT(*) !!!

Pages will not load any faster in an iframe than if you simply opened the page in a new tab or replaced the existing page with the new page!!!
Unless of ocurse you are only altering a few lines displayed.
The data still has to be retrieved from the server, sent to the user and rendered.
The real question is what particular need do you have to load one web page inside another web page? Can you show us an existing page and explain what happens on it?

Also, if you are just after some data from another source, there is always AJAX, although I personally have never needed it. Aprt from in prebuilt calendar systems that is, as one of my clients uses a booking service, and they can use that technique to update availablility as different days are selected.

You don't use myphpadmin (I think you actually mean phpmyadmin), you write a line of php and tell it to display the number it reads from the database in the format you want. The number will be stored in the database in the database's format, and that has nothing to do with the display format, that's the phph script's job.

To take data entered on a web page and put it in a database, you use a form and give the form and action - tell it to run a script when the submit button is clicked.

The script then takes the data, connects to the database and runs an sql query which inserts the data into a table in the database, and into the appropriate fields in that table.

You currently don't have a form, a submit button, an action or a script for us to look at..

The form should probably be in your iframe, with a textarea input field, named and ided, and the script uses that to know what data it has to handle.

I've had data that had a ' in it a few times, and that caused me problems. I loaded the csv file into Excel, and saved it as text, tab delimited and the problem went away instantly. I've stuck to that method and delimiter ever since.

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.

Why do you wish to do this???

Tables are for presenting data and that is what yours seems to be doing. It is NOT a list. Tables exist for a reason.

Are you mis-interpreting the common, correct, statement that you should not use tables for layout?

Sounds like your homework to me ;)

Who ever heard of a hospital hiring a beginner to create a database, when they almost certainly use one of the existing medical / patient databases that are available commerically.

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)

We need a bit more info as to the actual fields in each table before we can help.

Also there is no need to prefix every table name with tbl ! Among other things it gets in the way of reading the actual name.
winners, user, completerewards, rewards - so much more readable and less likely to contain a typo.

First, Word is very VERY VERY bad for creating a web page!!! Use a proper editor (eg Notepad++) rather than something desinged to create a Word doc.

Secondly, your links probably point at places on your hard drive, ie are absolute links. You may even have made the classic begginers mistake of pointing links at items in different folders.

You should create a folder just for your site, then within it create a folder called www. In the first folder place all raw items you intend to use and process for the web site. In the www folder you put your web pages.

Within the www folder create a second folder called images. In this place your processed (properly resized images). Then create relative links to the images in the images folder. Rememebr that when uploading to your web site, you must separately upload the images as well, as they are NOT embedded in the web page but are linked to from the page.

I'd change line 123...

Post the url where we can all see it!

Do your own homework perhaps...

line 19 float:left AND position:absolute ???

There's no need for a semi-colon at the end of the last style rule in any css declaration, but having one avoids problems later if you add another rule, as then you might forget to add it.

And solving this would be an awful lot easier if we could see the site and thus the problem in situ and all the code.
Post the url