The servers will handle the separate networks as long as only one NIC on each system has a gateway assigned. For example to get Server A to access on the 192.168 network and B to access the internet on the 10.10 network you could use:
I hate to correct someone in Public but Zagga is wrong. <img src="/images/picture.jpg" /> is not based on the current directory but on the Document Root directory for the web site. For example all the sites on my server are located in /var/www/html/ and have their own directory by domain. My web site resides in /var/www/html/txlinux.com/ which is listed as the document root for the site I can refer to any file in the top directory of the site with <img src="/picture.jpg" /> but the absolute path for the files on the server is /var/ww/html/txlinux.com/picture.jpg. The only time I really need to use this form of the path is when using "Include file.php (i.e. Include /var/www/html/txlinux.com/config/config.php )
"./" is the current directory and "../" is one directory up.
For software recommendations on the support ticket issue, take a look at SiT (Situation Incident Tracker). PHP and MySQL based with email capabilities, a knowledgebase and customer portal. The setup takes some work but once your get it updated it is pretty cool. Has SLA's, multi site, Contract and support levels, Skill levels for techs, Products and a lot more.
If I understand correctly you currently have the printers connected to servers in one room and the servers are on both networks (the reason for the current two nic configuration) and the printers are shared on the servers. If that is the case you should be done. The printer sharing is based on you being able to connect to the server/system the printer is connected to. The big trick on the NIC cards is only assigning one gateway to one of the cards and leaving the gateway empty on the other card. Otherwise you get confused routing determining which card to get to the WAN via. IF that is not enough then describe the current setup and I will be happy to make suggestions based on it.
That would depend on how the printers are configured now. If they are off of a work station then it (the workstation) would need access to both networks( a second NIC card) to allow both networks to access it. If it is working off an internal network port and has a USB port available then connect a workstation on the other network and share the printer through the workstation.
I never tried using a value too small. Give it a shot is all I can suggest. The documentation on MySQL states it can give unpredictable results so why take the chance.
From what I have seen it depends on how you referred to the data. If a temp table is created then it is possible your data would be truncated. Basically the number is stored correctly but may display wrong. Just make sure you provide a large enough area to display your worst case or largest possible number.
To make the searches faster index the field. If possible use a unique index provided none of your descriptions are exactly the same. As far as limits on the size it depends on the version of MySQL.
From my reference manual.
CHAR(n) character string with specified length, maximum 255 characters
VARCHAR(n) character string with variable length, maximum 255 characters (MySQL
through 4.1: n<256; MySQL from 5.0.3: n<65,535)
TINYTEXT character string with variable length, maximum 255 bytes
TEXT character string with variable length, maximum (2 to the 16 power)-1 characters
MEDIUMTEXT character string with variable length, maximum (2 to the 24 power)-1 characters
LONGTEXT character string with variable length, maximum (2 to the 32 power)-1 characters
New Aspects of VARCHAR: In MySQL 5.0 there are two significant innovations for the data type VARCHAR. • The maximal column size for tables is now 65,535 bytes (it was previously 255 bytes). The maximum number of characters depends on the character set, since many character sets require more than 1 byte per character. • Spaces at the beginning and end of VARCHAR values are now stored in the table. Thus INSERT INTO table (varcharcolumn) VALUES (‘ abc ’) actually stores ‘ abc ’ in the col- umn, that is, a space, the characters a, b, and c, and finally another space character. (Previously, MySQL deleted spaces at the end of VARCHAR values, which was in viola- tion of the ANSI standard.)
It is defined as the number spaces (characters)to be used in the output and has nothing to do with the size of the number to be stored.
TINYINT(m) 8-bit integer (1 byte, -128 to +127); the optional value m gives the desired
column width in SELECT results (Maximum Display Width), but has no
influence on the permitted range of numbers.
SMALLINT(m) 16-bit integer (2 bytes, -32,768 to + 32,767)
MEDIUMINT(m) 24-bit integer (3 bytes, -8,388,608 to +8,388,607)
INT(m), INTEGER(m) 32-bit integer (4 bytes, -2.147,483,648 to +2,147,483,647)
64-bit integer (8 bytes, ±9.22*1018)
BIGINT(m)
SERIAL Synonym for BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY
Optionally, in the definition of an integer field, the desired column width (number of digits) can be specified, such as, for example, INT(4). This parameter is called M (for Maximum Display Size) in the literature. It assists MySQL as well as various user interfaces in presenting query results in a readable format.
■ Note Note that with the INT data types, the M restricts neither the allowable range of numbers nor the possible number of digits. In spite of setting INT(4), for example, you can still store numbers greater than 9999. However, in certain rare cases (such as in complex queries for the evaluation of which MySQL constructs a temporary table), the numerical values in the temporary tables can be truncated, with incorrect results as a consequence.
I think you are trying to get it all on one line with a column showing revenue - costs. If that is correct then add a column to the revenue entry like this:
SELECT 'Reveneue' AS Category,ROUND(Amount) as a, 0 AS Expenses FROM `Revenue`
and then change the total select line from the other selects to:
select 'Total' As category,sum(category_total) AS Expenses, 0 as a from
and finally at the very first select:
Select 'Totals' As Category,a as 'Revenue', Expenses, (a - Expenses) as ProfitLoss
By adding a column even if it is 0 to each of the unions you keep the number of columns and column names the same. IF I guessed wrong tell me what you want as the result and I will give it a shot.
I think I see what the problem is. When you use UNION you have to have the same column names in every query. On line 6 instead of
as Category_Total
you have
as expense
. I am not sure but I also noticed on the same line category is spelled with a lower case C and every where else it is capitalized. See if that fixes it and let me know.
DATE_FORMAT(date, format) and TIME_FORMAT assist in the representation of dates and times in formats other than the MySQL default format. Three examples illustrate the syntax:
SELECT DATE_FORMAT('2005-12-31', '%M %d %Y') December 31 2005
SELECT DATE_FORMAT('2005-12-31', '%D of %M') 31st of December
This is what I used for reference and it says INT UNSIGNED (4 bytes) which is how mine are defined and they work great.
MySQL has two built-in functions: INET_ATON() and INET_NTOA(). They are actually based on the equivalent inet_aton() and inet_ntoa() which are C library functions present on pretty much every TCP/IP capable system. Why? These two functions are used allover the place in any TCP/IP stack implementation or even application. The INET_ATON() function converts Internet addresses from the numbers-and-dots notation into a 32-bit unsigned integer, and INET_NTOA() does the opposite. Isn't that handy!
So you can store an IP address in an INT UNSIGNED (4 bytes) which is of course much more efficient and faster than a CHAR(15). Naturally, you can call the function while you're inserting, so something like this is fine also:
INSERT INTO tbl VALUES (..., INET_ATON('192.168.0.10'), ...)
You can pick up a USB external housing for aroung $40 and put a CDROM in it then boot from the USB-CDROM. For network boot you have to set up a system with a tftp server, dhcp server, and pxelinux (part of syslinux) or look into Microsoft RIS. I set up the PXE boot server running Linux for my company and have at home and it is not something you set up the first time in a couple of hours. But here are a few links that helped me get the process started and understand what had to be done.
If your output has the same number of fields with the same field names you can use UNION between the queries to generate a combined format and then sum it. Here is what merging the first two queries would look like. You will probably have to do a little tweaking but I think you will get the idea. From experience, get the first two working before you add the others. I usually get each query generating the output I want then merge them one at a time.
$result = mysql_query(
(
SELECT 'Diesel' as Category, FORMAT(ROUND( Qty * Itemrate ),2) as Category_Total
from `diesel_info`
INNER JOIN rates ON diesel_info.marker = rates.item
AND MONTH( diesel_info.Date ) = MONTH(rates.Date )
WHERE diesel_info.Code =$a AND MONTH( diesel_info.Date )=$m
)
UNION
(
SELECT 'Lims Payment' as Category, FORMAT(ROUND(SUM(`Amount`/12)),2) as Category_Total
FROM `lims_payment`
WHERE `Code` =$a AND YEAR(DurationS)=$y
)
)
$row = mysql_fetch_array($result);
echo $row[0];
The 6 processes you see are 6 available connections for web browsers to connect to. The main application is only running once in memory but has 6 children listening on port 80 for a connection.
If you look at the process tree you will see something like this:
YES. It could be several things but if the fan on the power supply of processor go out you could burn out the processor.
Check to see if there are any cables or wires that might be getting in the path of the CPU fan. Run the system with the case off for a while and see if you can narrow the noise down to exactly where and/or what is causing it.
You could use a sub-queries to generate the main query. My example is kind of an odd way to accomplish this but it should work.
Basically to get this working you run a selection to generate a list of the db_emails that have more than one record. Strip out just the db_email field and use it to go back through the table selecting the records where the email address is in the list.
First get the two main queries working.
Query 1: What do I want the output to look like
select db_email, db_medlem
from kunder
order by db_email
Query 2: Create a select to output db_email and count where count > 1
SELECT db_email, count(*)
FROM kunder
GROUP BY db_email
HAVING count(*) > 1
Refine Query 2 to just give you the db_email field.
SELECT data1.db_email from ((SELECT db_email, count(*)
FROM kunder
GROUP BY db_email
HAVING count(*) > 1) as data1)
Plug Query 2 into query1 as a list to select from.
select db_email, db_medlem
from kunder
where db_email in
(SELECT data1.db_email from ((SELECT db_email, count(*)
FROM kunder
GROUP BY db_email
HAVING count(*) > 1) as data1)
)
order by db_email
That is as close as I can get without the actual db to play with so you may have to do a little tweaking. I may be off with one of the () around data1. If you want send me the results or errors and I will debug it for you.
Based on what you put in your post I am not sure you have the meaning of DISTINCT correct. If you are trying to get all records with a specific value in the Sheet1.[SR No#] field what you are looking for is really the WHERE clause. I am including the definitions and syntax for both at the bottom. DISTINCT gives you one line of output for each group of similar records (i.e. all records with Sheet1.[SR No#] = to specific value). If I am reading the post wrong then the syntax for what you want would be:
SELECT Sheet1.Date, Sheet1.[Club Name], Sheet1.[Problem / Symptom Description], DISTINCT Sheet1.[SR No#] FROM Sheet1
GROUP BY Sheet1.Date, Sheet1.[Club Name], Sheet1.[Problem / Symptom Description], Sheet1.[SR No#], Sheet1.[SR No#]
HAVING (((Sheet1.Date)>#6/1/2010# And (Sheet1.Date)<#6/30/2010#))
ORDER BY Sheet1.Date;
If you want all records for a specific Sheet1.[SR No#] then you would use:
SELECT Sheet1.Date, Sheet1.[Club Name], Sheet1.[Problem / Symptom Description], Sheet1.[SR No#] FROM Sheet1
WHERE Sheet1.[SR No#]='100'
GROUP BY Sheet1.Date, Sheet1.[Club Name], Sheet1.[Problem / Symptom Description], Sheet1.[SR No#], Sheet1.[SR No#]
HAVING (((Sheet1.Date)>#6/1/2010# And (Sheet1.Date)<#6/30/2010#))
ORDER BY Sheet1.Date;
The line WHERE Sheet1.[SR No#]='100' would imply output all rows (records) where Sheet1.[SR No#]='100'.
1. If I install the antivirus/antispyware in safe mode, can it be able to detect and remove the virus/spywares? Some yes some no but it is a good place to start. Download MalwareBytes on another system and try installing in Normal mode first then safe if it wont let you.
2. If I install them, will they work in normal mode? Yes.
3. Will I be able to connect to internet or need to install other driver/utilities? Depends on the Virus. Try Safe Mode with Networking.
4. If the antiviruses works and fix the problem, how can I make sure that all are removed? MalwareBytes with all updates. Run until you get two full scans without any infected results in normal mode.
5. How can I check the registry or clean up them from registry if it is get infected? Hijackthis will show you registry entries.
So basically you want to write your own conversion software in PHP to convert PDF files to text and post it to mysql.... Like most programming ideas it sounds easy but is probably going to take a while to code. I suggest you look into the format used for storing PDF files and you will see why others have been suggesting software to convert the file for you and then post the results to the database.
If you get the answer to your problem how about letting us know!!!
It only takes a moment to update the posting you started and give credit (when deserved) to the person that helped you. It lets everyone know that they you have been helped and they don't need to check to see if you need more help and they can go on and help others.
For me it is nice to know I have been able to help someone. For people looking for solutions it is important to know that the answer you got worked so they know it might work for them too.
Not without running a virtual system of some sort. You have to have a primary OS running and you only get one Operating System. Under that Operating system you can run other OS's virtually. For example, I have a system (Dual Quad core XEON 3.0) running VMWare ESXi 4 (Linux based kernel for Virtual OS's) and under it I have currently 7 different Operating systems (1ea XP, 2ea Windows Server 2003, 4ea Linux). One of the Server 2003 (Running IIS) and one of the Linux (CentOS running LAMP with main site and email) are almost (99%) always running and available on the web. XP is for testing compatibility and only started when needed. Second Server 2003 is for development and rebooted a lot. Second Linux is for CentOS development and testing and up most of the time. Third Linux is Ubuntu and forth is Debian and are for reference and down most of the time.
Not without running a virtual system of some sort. Only one OS per system till you get to virtual systems. You could run Ubuntu set up a virtual system and run XP under it or install VMWare and run both under it.
Not sure if this will help but if you want a complete email system that is secure and has web based management take a look at qmail toaster. Gives you secure pop3, webmail, installs and configures mysql php and apache for you and if you add qmail toaster plus (spamdyke is the greatest) pretty much spam free. You can create email accounts from scripts or using provided browser pages.
What you are talking about is a database. If the server your site is on has php then it probably also has MySQL. A database consists of an organized collection of data for one or more uses, typically in digital form. One way of classifying databases involves the type of their contents, for example: bibliographic, document-text, statistical. Digital databases are managed using database management systems, which store database contents, allowing data creation and maintenance, and search and other access. PHP is used to access the data in the data base and display, add, edit the data from a web browser. You will find a multitude of references to PHP and MySQL and how they work together.
It is my understanding that all you have to do is connect the drive to an infected system and you are open to getting a virus. Many viruses look for the addition of a drive and copy them selves the moment they detect a new arrival.
I suggest that you check the system start-up. If it is XP you can do "Start", "Run" and put "msconfig" in the box. You will get to a series of tabs that show you the applications starting when the computer starts. Check the "Startup" tab and see if the dll's are being called from there. If not run regedit and search for the dll name in the keys.
#!/bin/bash
DIR1=d1
DIR2=d2
DIR3=d3
for x in `/bin/ls $DIR2 `
do
#If the file does not exits in DIR3 then copy it.
if [ ! -a $DIR3/$x ]
then /bin/cp $DIR2/$x $DIR3/
fi
# If the file exists in DIR3 but one in DIR2 is newer copy it.
if [ $DIR2/$x -nt $DIR3/$x ]
then /bin/cp $DIR2/$x $DIR3/
fi
done
Personally I would move to another provider if they chose to change my OS without my consent. Your php will work just fine provided they have PHP enabled in IIS and MySQL installed on the server you are moving to. Why anybody would move clients off of a server OS (Linux) onto a GUI pseudo server OS (Windows) is beyond me.
That really sounds like what you use triggers for. I am curious why you would ever change a products PID. Isn't that the key for the Product table? You might change the description or cost or unit of measure but the PID should be unique.
