1,073 Posted Topics
 | If you are referring to a simple master, detail type relationship I normally do something like this: [CODE]CREATE TABLE `master` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Invoice_Date` Date() Default null, `Customer_Name` VARCHAR(55) default NULL, `Customer_Address` VARCHAR(55) default NULL, `other_fields` VARCHAR(55) default NULL PRIMARY KEY (`ID`)) [/CODE] [CODE]CREATE TABLE `detail` ( …  |
| | Re: GotoMyPcIssue That you will have to take up with their customer service. May I suggest Team Viewer, it is also free and has the ability to transfer files which gotomypc only includes in their pay version.  |
| | Not sure if this will help but if you redirect the output to a file you can then watch the file grow with tail -f <filename>. For example if you ran the following: [CODE]# myscript > myoutput.txt[/CODE] You could watch the output as it arrived using: [CODE]# tail -f myoutput.txt[/CODE] … |
| | This is just off the top of my head mind you but you can determine the parent process id of the perl script via getppid You could use this to kill the login shell. [CODE]kill 'STOP', getppid; [/CODE] From a Perl Manual: [CODE]kill LIST This function sends a signal to … |
 | OReilly makes the best books on just about any computer topic. O'Reilly - Designing Large-Scale LANs O'Reilly - Network Security Assessment 2nd Edition Nov 2007 O'Reilly - TCP IP Network Administration O'Reilly - Internet Core Protocols The Definitive Guide O'Reilly - TCP IP Network Administration 3rd Edition O'Reilly - The … |
| | What happens if you put that URL in a browser on that computer? May tell you what is going on and also check the apache logs for the errors when it tries to get the page. |
| | Have you thought about simply putting it in a batch file. You can call a sql script straight from the command line or put it in a batch file like this: [CODE]mysql -u root -ppassword mydatabase < myscript.sql [/CODE] Or you can use the first line of the script to … |
| | There is no ; at the end of the sql query to tell MySQL to execute the code. Try this: [CODE]$query = "UPDATE account_details SET approved_status='1' WHERE account_number='$account_number';"; $result= mysql_query($query) or die(mysql_error()); [/CODE] |
| | I had a similar problem my self once. The problem is PHP scripts are designed to be run from a browser or web page and not the command line. When you think about it from that angle the answer is obvious. You either act like a browser or tell the … |
 | You can use telnet (you may need to add it to windows). telnet <ipaddress>:443 will connect you to port 443 at the ipaddress example: telnet 192.168.1.20:443 or telnet mysite.com:443 |
| | Open it back up and see if there is a cable or wire where the fan is hitting it. Or is the bearing going out on the fan? |
| | What you are looking for is a firewall. If you are running Windows (depending on the version of Windows) you can configure the built in firewall to do some of it. If you are running Linux then read up on iptables which is the linux firewall. |
 | Unless I am mistaken you need to set the following lines in the /etc/vsftpd/vsftpd.conf file: local_root=/var/www/ chroot_local_user=YES Try this site for more information: [URL="http://ubuntuforums.org/archive/index.php/t-518293.html"]http://ubuntuforums.org/archive/index.php/t-518293.html[/URL] |
| | A join is used in a query to retrieve data from more than one table based on a common element in the two tables. For example you might keep shipping addresses in one table and orders in another with a field in the order table holding the id of the … |
| | Your problem is probably due to the ownership of the files. In order for web applications to access files they must be in a directory that has group ownership by the apache user on the system. Making it 777 is not the answer. If the files are owner by root … |
| | I have used this before. create a file called exefix.reg with the following in it: [CODE] Windows Registry Editor Version 5.00 [-HKEY_CURRENT_USER\Software\Classes\.exe\shell\open\command] [-HKEY_CURRENT_USER\Software\Classes\secfile\shell\open\command] [-HKEY_CLASSES_ROOT\.exe\shell\open\command] [HKEY_CLASSES_ROOT\.exe] @="exefile" "Content Type"="application/x-msdownload" [-HKEY_CLASSES_ROOT\secfile] [/CODE] Then right click on it and select install. |
| | Your log from Malwarebytes is for a quick scan not the full scan. Run the full scan.  |
 | You have a -p flag for the password but nothing entered. If there is a root password then it should be prompting you. If there is not one remove the -p. You also should have a -D in front of database like this: [CODE]mysql -u root -ppassword -D newdb -e … |
| | Ok I have looked around for something that might help but the only think I can see is I believe there should be a space after the IN [CODE]class CHAR(10) NOT NULL CHECK class IN ('x1','x2','x3'), [/CODE] |
 | Hello, What you need is the motherboard chipset driver. It has the drivers for the CPU, memory controller and other motherboard resources. Normally it is best to install it first them any other drivers. Without it your system cannot talk to the onboard video chipset so the drivers would not …  |
| | Go into the computer BIOS setup (normally Hit <DEL> or <F1> or <F2> depending on manufacturer) as the computer is booting and disable the onboard game port. While you are in there you might disable the onboard serial and parallel ports (if they are installed. Also I bet the motherboard … |
| | I think what you are looking for is probably a combination of the LIMIT option and the UNION command. If you have 4 sets of like results for 4 queries (each query returns like columns and the same number of columns ) then write your selection statements in parentheses and … |
| | Maybe this will help. I wrote it for another thread that was having problems with two routers on the network. I think what you need is a wireless access point instead of a router in the second location. An access point will connect to the router to allow it to … |
| | Hello, The dell site has the codes for the flashing lights in the service manual for the specific model. Go to their site and use the service code to get to the manuals on your computer. On Dell desktops if your don't see a label that specifically says it is … |
| | Hello, Normally installing mysql will not overwrite your database files however to be on the safe side use phpmyadmin to backup the databases or export them using mysqldump (or both). My suggestion is: make two separate copies of the data files. Murphy's Law says if you have two backups then … |
| | Looking at the code I think the problem is you are not using the "SET" command to identify the variable you are updating. Normal syntax for an update statement is something like: [CODE]UPDATE table_name set table_name.field5 = <field5data>, table_name.field10 = <field10data> where table_name.id = <record_id>[/CODE] In your case I think … |
| | Your problem comes from a couple of things. Try this: [CODE] a=3 type=$a echo $type [/CODE]  |
| | I am not sure what you mean by "A value that I choose" but there are several ways. Here is an example from the mysql cookbook that should do the trick: We've used lookup tables often in this chapter in join queries, typically to map ID values or codes onto … |
 | Hello, There are several issues with the statements you made. 1) installing XP twice usually means you installed XP on top of it's self. If you are seeing two options when you initially boot for running XP it just means that your boot loader has two entries however both of …  |
| | Hello, Are they on the same subnet as the server 2003 system. What is the server IP, subnet, Gateway and what IP, subnet,gateway do the other computers have? It could be that there is another router between them and you that connects through your current system. For example: They could … |
| | Hello, You need to look into a book on the shell (bash shell programming) and the difference between commands with and without sudo is that sudo executes the command as root.  |
| | Just looking at it real quick is identity your primary key and set for auto-increment? If so then do not attempt to set the value as the system will automatically fill it in. |
| | Hello, More like 3 page by dynamic pages that are created on the fly by php querying the database. I would set up a table for each of the selection criteria. Table 1 Countries, Table 2 Majors by country, Table 3 Universities including country and majors. The code is not … |
| | It is really kind of hard to help you without seeing the code for your site. If you post it up here make sure you change the password to something different. |
| | If the adapter is disabled it does not have an IP address. If you have used a fixed address and disabled it then the address is stored in your OS but not being used. If you are using DHCP then the NIC is disabled and therefor has not requested an … |
| | If you have not fixed this yet here are a couple of things to do. I take it you are trying to connect via the 10-base T cable instead of the wireless. 1) Check for link lights on both the Router and the NIC card. 2) Try setting the wired … |
| | In order to be able to see the XP systems you will need to make sure a protocol is loaded on the XP based system. Go to Control Panel, Network Connections the right click on Local Area Connection and then select properties. When the box comes up look through the … |
| | Re: Subnetting help This might help also: [CODE]ID # Bits Number Hosts Usable Hosts Netmask Note 6 /6 67108864 67108862 252.0.0.0 7 /7 33554432 33554430 254.0.0.0 8 /8 16777216 16777214 255.0.0.0 Class A Network 9 /9 8388608 8388606 255.128.0.0 10 /10 4194304 4194302 255.192.0.0 11 /11 2097152 2097150 255.224.0.0 12 /12 1048576 1048574 … |
| | The message you are receiving could be from a virus that is trying to get you to install it. To find out for sure get the latest copy of MALWAREBYTES from the link below. The free version will usually get rid of almost everything and you can install it in … |
 | Here is a link to the site I used to install the driver from: [URL="http://unixmen.com/linux-tutorials/linux-distributions/fedora/1376-how-to-install-nvidia-drivers-in-fedora-13-and-14"]http://unixmen.com/linux-tutorials/linux-distributions/fedora/1376-how-to-install-nvidia-drivers-in-fedora-13-and-14[/URL]  |
| | |
| | try this to seewhat is happening: /bin/sh -x cup.sh it will show you each line and result as it executes. |
| | Re: error with mysql The code you have is selecting every record from question and only joining info from records in answer that match the criteria. I think what you ar looking for would be: [CODE]SELECT * FROM question LEFT JOIN answer ON question.Que_ID=answer.Que_ID AND question.Que_Answer1=answer.Ans_Answer1 AND question.Que_Answer2=answer.Ans_Answer2 AND question.Que_Answer3=answer.Ans_Answer3 AND question.Que_Answer4=answer.Ans_Answer4 WHERE question.Tes_ID=7 … |
| | you have to tell apache what the default web site is for the server put something like this in the httpd.conf file: [CODE] NameVirtualHost *:80 <VirtualHost *:80> ServerAdmin webmaster@dummy-host.example.com DocumentRoot /www/docs/dummy-host.example.com ServerName dummy-host.example.com ErrorLog logs/dummy-host.example.com-error_log CustomLog logs/dummy-host.example.com-access_log common </VirtualHost> [/CODE] |
| | Your problem is coming from the field being treated as a string rather than a number. Basically you have two options. 1. Split the files into tree separate fields as integers and then do the order by using all three fields. 2. Change the columns that need it in your … |
| | If you can't turn the laptop back on then there is a hardware issue. My first guess is that the system is over-heating. Make sure the vents on the bottom and sides are not blocked and check to see if there air coming out at least one of the vents … |
| | May I suggest that you take a look at qmail and the install provided at qmailtoaster. I use it on my servers with the addition of spamdyke and it works great. It has the features you are looking for and more. [URL="http://www.qmailtoaster.com/"]http://www.qmailtoaster.com/[/URL] |
 | It does not make sense for the server to block you unless the account is restricted to only one connection per user. I am not sure what ssh client you are using to access the server but may I suggest you try PUTTY. [URL="http://www.chiark.greenend.org.uk/~sgtatham/putty/"]http://www.chiark.greenend.org.uk/~sgtatham/putty/[/URL] I work for a hosting company … |
| | I don't believe what you are describing is possible with just one hard drive. You are attempting to use partitions for the RAID instead of physical disks. RAID, an acronym for Redundant Array of Independent Disks (Changed from its original term Redundant Array of Inexpensive Disks), is a technology that … |
| | try ftp 111.92.1.214 but the question is do you have an ftp server running to allow the connection. Try this from the command line: ps aux | grep ftp this will show you any processes with ftp in the name that are running. You may need to install an ftp … |
The End.