Kcarson

Sorry, but the only Server-Side Script they allow currently is PHP and that is only if you pay for it.See Questions 10 and 19 here (of course you have already seen 19 since you listed its answer above ):http://newbravenet.supportclient.com/viewk...osting&search=1

Well basically what i'm aiming for is a free .com address. I figured a home server would do that...

<{POST_SNAPBACK}>

Well, a home server would not provide the .com address unless you got a domain name assigned to it. As Skemcin mentioned above, there are a multitude of reasons why you may not want to host the site from your home computer. I personally am doing it right now only because I am working with a friend to design a site and this way he can easily check out the work I have done and make suggestions, not to mention I was wanting to experiment with Apache and this was a great excuse. But once the site is complete, we will be selecting a hosting service and getting a domain name for it (.com/.org/.edu/etc). As I mentioned before, the free hosting sites (such as Geocities, or the one's offered by a lot of ISPs) are very useful as you begin your site. I personally would suggest checking them out for now.

Yes you can use your own computer as a web host. You can do it with either IIS (Windows Only) or Apache (Windows or Linux). If you do a search on either of those, it is fairly straightforward. To give you a heads up though, to access your site, you will have to give people your IP address (ie. xxx.xxx.xxx.xxx) and you will have to keep your computer turned on as long as you want it to be available to others.Depending on what you are wanting to host, you probably should check out some of the free web hosting services. Check out this thread:http://w3schools.invisionzone.com/index.php?showtopic=592

Can you rephrase the question?Are you suggesting that somebody will say: "I need a list of students who are taking course A"?If so, you need to obviously do a select statement with 2 sub-select statements, or joins, your preference. To guide you, follow this guideline.Select the course id based on the name of the course givenSelect the student id based on the id of the course aboveSelect the student name based on the id of the student aboveIf you work around with it and play with it you should be able to figure it out. If not, show me what you have figured out and I will help you some more.

Well, I can't tell you how to populate your dropdown list. But as far as taking the contents of one table and using them to insert into another, you have a few different options.1. Try

INSERT INTO char_tbl (c_race)SELECT a_race FROM race_tbl WHERE a_race = ***What the user chose from the dropdown***

2. If you are using MS SQL, then you could also use variables to do this (I know that MySQL, and Oracle also allow this but I am unsure of their syntax)For MS SQL

@Race     VARCHAR(10)SELECT @Race = a_race FROM race_tbl WHERE a_race = ***User Input***INSERT INTO char_tbl (c_race)VALUES @Race

Or maybe even just:

@Race = ***User Input***INSERT INTO char_tbl (c_race)VALUES @Race

As I mentioned before, not sure how you will get the dropdown list populated, but this should help you once you get past that point.

Im using SQL plus not server

<{POST_SNAPBACK}>

Sorry for not catching that. I do not have any experience or knowledge of SQL*Plus and after looking around, I cannot find anything that would give you the results you are looking for you.Hope you can find your answer or somebody else can help you.If you do find an answer please do share it with the rest of us so we can learn with you.

Now its getting competetive . . . I'm 52 post back - I've got some work.

<{POST_SNAPBACK}>

Well I am not even on the first page yet....but I am slowing but surely moving up the list

I actually was discussing this with a developer earlier today for something I was doing. There is no way to do this without rewriting the query each time (I am interested though in trying Jerome's method).Well, from what the developer told me, you can do it with a loop and a bunch of if statements, its not pretty but can reduce the number of queries and error handling routines needed. Basically you would do:

Count = 0Do    If count = 1        set variables    If count = 2        set variables appropriately...Hope you see where this is going    Use the query with variables rather than constants    Inert error handling    Count = Count + 1While (count < Pre-defined number)

This is by no means the correct syntax, merely the pseudo code of what you could do using Transact-SQL.

Yes I understand your question perfectly, and unfortuantely I do not have a specific answer for you. I have not actually done a backup on MySQL, but from what I can tell it must be run from the command prompt. If you are only backing up the tables then you can do that using only SQL syntax. You could however do a full database back up by using the following command:

BACKUP TABLE tbl_name [, tbl_name] ... TO '/path/to/backup/directory'

on each table. Now this will not copy the database, but if you have all the contents of the database, then you should be fine.Hope that helps.By the way the information for the above query is:http://dev.mysql.com/doc/refman/5.0/en/backup-table.html

And if you just want to return those top 3 rows, you can check out the various possible solutions from this other thread:http://w3schools.invisionzone.com/index.php?showtopic=652

I am glad I could help. I actually had to look this up myself. I knew it was possible since the DBA where I work had mentioned it before, but I never had actually done it myself. So I got to learn something new as well.

I am assuming you mean you want to append the columns to the table rather than append the data from one column into another (i.e. concatenating the two). Assuming you do want to add the new columns to the table and all of the contents of those columns, see below.Well, if you are adding columns to the current table, then do that using the ALTER TABLE command.Then at that point there are two options.1. Create a view joining the two tables you are referencing. Example:

CREATE VIEW test (column_names) AS SELECT * FROM table1 JOIN table2 WHERE table1.field1 = table2.field1

Then perform your update on the view.2. Try the query below:

UPDATE   table1   SET    column_name   FROM table1 JOIN table2 ON table1.field1 = table2.field1

You will have to play with these a bit, but they should at least get you started in the right direction.

One thing I forgot to mention, you will need to add the server you want to connect to using the sp_addlinkedserver.Well, after further research on it, what you are wanting is linked servers. Here is a MSDN link that describes how to set it all up. You can even set it up so that you can access Access, Excel, or even a text file. Here is the link:http://msdn.microsoft.com/library/default....server_4uuq.aspHopefully that will be more informative than I could be.

Try this out:

SELECT SNo, [Last Name], [First Name], MI, FROM [servername\dbname].pubs.dbo.authors

where(server=servername, instance=dbname)

Are you using MS SQL, MySQL, PostgreSQL, Oracle, Access, or something else?For MS SQL:http://msdn.microsoft.com/library/default....migwiz_0z50.aspFor MySQL (ver 5.0):http://dev.mysql.com/doc/refman/5.0/en/backup.htmlFor MS Access:Just copy the database file and rename itFor PostegreSQL:???For Oracle:http://www.idevelopment.info/data/Oracle/D...y/BandR_2.shtmlMost SQL servers out there have an methods available to make this a quick and painless process. Many of them through export utilities, but it will vary with each company. But this should be enough information to get you started at least.

Try this:

SELECT * FROM table LIMIT 10

It should work in MySQL and PostgreSQL

List generated from this threadIf you feel there are more that belong under here, make a post here, and someone will edit it in. Thanks...

Okay, everybody, here are all the different editors that have been listed in this thread so far with all the relevant information. Now, if anybody ever needs a good editor, there will be no shortage of suggestions for them Nvu Free Platform: Windows/Mac/Linux http://www.nvu.com WYSIWYG editorhapeedit Free Platform: Windows http://hapedit.free.fr/ Highlights PHP, ASP, JS, HTML, CSS, SQLNotepad2 Free Platform: Windows http://www.flos-freeware.ch/notepad2.html Highlights PHP, ASP, JS, HTML, CSS, SQL, VBScript, Perl/CGI, C/C++, C#, Java, VB, Pascal, Assembler, Python, NSIS, INI, REG, INF, BAT, DIFFHTMLgate Free http://www.mpsoftware.dkHighlights: HTML, CSS, PHP, JS, JAVA, SQLNotepad Free Platform: Windows Comes with Windows (all versions)TextPad $29 Platform: Windows http://www.textpad.com Scite Free Platform: Windows/Linux http://www.scintilla.org/SciTE.html Text editor with lots of highlighting like Notepad2Crimson Editor Free http://www.crimsoneditor.com HTML KitFree http://www.chami.com/html-kit/downloadDreamweaver MX/8 $399 Platform: Windows/Mac http://www.macromedia.com/software/dreamwe...8_datasheet.swfEditPad Lite Free Platform: Windows jed Free Platform: Linux Slackware 10.1FrontPage 2000/2003/XP$199Platform: Windowshttp://www.microsoft.com/frontpage/PSPadFree (freeware)Platform: Windows 98,ME,2000,XPhttp://www.pspad.comNanoFree (open source)Platform: linux, with many portshttp://www.nano-editor.org/NEdit (Nirvana Text Editor)Free (open source)Platform: linux, with many portshttp://www.nedit.org/Bluefish Web Development StudioFree (open source)Platform: Linux, FreeBSD, MacOS-X, OpenBSD, Solaris and Tru64 (no windows!)http://bluefish.openoffice.nl/index.htmlBeaver (Early AdVanced EditoR)free (open source)platforms: Linux/unix/windowshttp://www.nongnu.org/beaver/http://en.wikipedia.org/wiki/List_of_text_editors

All in favor, AYE!!!

No kidding.....I now know whose answers I will be trusting most

Please keep posts like this in the General category, and also try to not place the same post in multiple categories as you did with this one, in General, HTML, and PHP.Thanks.

Other than using the font tag in HTML or CSS or what?IF that is the case, then I suggest using the font attribute in CSS, here is the w3c tutorial on it:http://www.w3schools.com/css/css_font.asp

Somebody else had this problem not too long ago on another board. Check it out here:http://www.geekstogo.com/forum/index.php?s...=0entry445708My first suggestion is to Open Windows, Press Alt+V, and see if that opens up any options for you, if not, see the suggestions listed in the link above.Hope that helps.

My understanding is that it is either or, not both.  Microsoft servers run ASP.net/SQL and linux servers run PHP/MySQL.  Let me know what you know.

You can run PHP/MySQL or ASP.net/SQL on either Windows IIS or Apache, its up to you. Obviously, if you run ASP.net/SQL on Apache, it will need to be the Windows version, but can still be done. Also, as far as I know you can run all four services on the same server, I am sure it can't be pretty, never done it myself, but saw a few hosting services offering you the ability to run all four on one website. Also, I see no technological reason it could not be done, you would just be allowing an additional file extension to be used on the server, and storing a second database that sites may access.

Your best bet is to use a server side script. Check out these w3c tutorials on it:Forms:PHP:http://www.w3schools.com/php/php_forms.aspASP:http://www.w3schools.com/asp/asp_inputforms.aspDatabase ConnectionsADO:http://www.w3schools.com/ado/default.aspPHP:http://www.w3schools.com/php/php_db_odbc.asp

Nope, no reason to add programing languages unless they can somehow help with web design. If people want tutorials for programming there are plenty of sites out there. This is w3 schools, meaning World Wide Web. Now with that said, they could add some stuff that might be of use for web site designers, such as how to create Java applets, or CGI scripts (although I know that PHP and ASP are much better than CGI, but for completeness, they could add it).Now one thing I would like to see, is more information on how to do photo manipulations for web sites. Such as how to use Photoshop, GIMP, or one of the many other worthy software packages.