Posts by rch1231

Hello,

Pritaeas is correct about the index and you will need to change the insert statement and add IGNORE to cause mysql to ignore the errors when the insert fails due to duplicates.

INSERT IGNORE INTO person_tbl(person_name,person_status,creation_time,modified_time) VALUES ('$person',$status,$ctime,$mtime)

I usually go for the subquery version and I believe this will work:

update table2
set total score = (select sum(score) from table1 where table1.id = table2.id)

Hello,

OK a couple of things.
Using PHP to do your backups is a bad idea because the only files that PHP can access are the files that a web user can access and that is why your backup is smaller that the actual directory structure. And this script isdesigned for a single sitte not multiple sites.

Are you running this on Windows or Linux based server? In either case there are Linux shell scripts and Windows Power Shell scripts that will do this properly and retain the permission and ownership settings of the files when they do it. Tell us which OS and we will make suggestions on how to do it properly.

Hello,
What you need is a router instead of a switch. A simple 4 port router will have a WAN connection that you can connect to the WiMAX and 4 LAN ports that you can connect everything else to. You can then put the other static devices on the LAN ports and work from there and if you ever need it you could get the other three systems to the internet.

If I remember correctly the WiMAX uses 192.168.15.X for the subnet it is assigning IP in. If you moved your static devices to the 192.168.15.X subnet with a netmask of 255.255.255.0 with no gateway assigned and let your computer get the dynamic IP from the WIMAX or a new router you would be able to talk just fine.

Hello,

Unless I am mistaken the issue is with the Home Premium version of Windows 7. It is only designed to see computers in a Homegroup and does not support other networks or domains. Below is a link to the Microsoft page that shows the capabilities of each version of Windows 7. You need at least Windows 7 Professional to see the XP systems on the network.

Windows 7 Compare

Hello,

I would import the CSV file into the MySQL database as a different table. For example if the table in the current database is customers then make the import table customers1. Then use sql queries to compare the two tables. This type of query is what MySQL is designed for.

MySQL has an import function called mysqlimport that can be run form the command line and is designed to import text files like csv files. If you have any type of GUI interface (like phpmyadmin or mysqlworkbench ) most of them have built in options to load a csv file.

The a query to find matching records or records in table1 not in table2 is easy to write.

Hope this helps.

Hello,

You said you could hear beeping from the computer when you boot. Is it just one beep? If not the beep codes are designed to help you diagnose errors. You need to determine what the pattern is (i.e. One long beep repeated continually, 2 shorts and a long beep, or 3 long beeps, etc.) From there Google CMOS beep codes. Here is a link to a site that explains what several manufactures beep codes are and what the computer is doing to generate them.

http://www.computerhope.com/beep.htm

Hello

Your missing a few things in your crontab file. Simply placing the file in /etc/cron.hourly is not enough. The format of an entry in a crontab file is like this sample file. Lines that start with a # are comments and ignored by cron:

     # use /bin/sh to run commands, overriding the default set by cron
     SHELL=/bin/sh
     # mail any output to `paul', no matter whose crontab this is
     MAILTO=paul
     #
     # run five minutes after midnight, every day
     5 0 * * *       $HOME/bin/daily.job >> $HOME/tmp/out 2>&1
     # run at 2:15pm on the first of every month -- output mailed to paul
     15 14 1 * *     $HOME/bin/monthly
     # run at 10 pm on weekdays, annoy Joe
     0 22 * * 1-5    mail -s "It's 10pm" joe%Joe,%%Where are your kids?%
     23 0-23/2 * * * echo "run 23 minutes after midn, 2am, 4am ..., everyday"
     5 4 * * sun     echo "run at 5 after 4 every sunday"

The easiest way to create a crontab file is while logged in to a shell as garrett type the following:

crontab -e

To see your crontab use:

crontab -l

To remove the current crontab for the user:

crontab -r

Hope this helps.

Hello,

This is a know issue with Mint. You need to install the gnome-screensaver and add it to gnome-session-properties.

http://www.linuxmint.com/rel_nadia_whatsnew.php

What you are seeing is the GRUB boot loader. It allows you to boot multiple operating systems from the same drive. If you leave the system at the screen it should go ahead and boot Ubunto after a few seconds. Here is a link to more information:
https://en.wikipedia.org/wiki/GNU_GRUB

Hello,

Yes all you do is use two greater than symbols and it appends rather than overwriting.

curl -k "$FIELDLABEL" >> result.txt

Personally I use an IDE that runs on both Windows and Linux and provids a License key that works on both. Editrocket is the application name and it works with multiple languages and includes code snipites and what I have found to be many other great utilities. The price was within reason too.

Web site for Editrocket

IF you install it over the WIndows partitions then YES. You can try Linux without installing it by using any of the "Live CD" isks availabel for most of the distrubitions. Check out Fedora or Ubunto as they both have a cd you can boot from that will let you play with linux without changing your windows system.

If I understand correctly you are supposed to write the sql statements that will SELECT the records from the tables shown that meet the requirements listed.

For example the second instruction is to list products rented by both customers 1003 and 1101. I normally break this down into a couple of tasks. First I would find the transactions for the date range from TRXN where the customer IDs match. From there find the Products purchased by both where the TRXN id is in the list above. Then use those product IDs to list the products.

These are complex queries that use sub-queries to generate a subset that you select from later. I suggest that you talk with others in the class or go over your notes closly if the abve does not make sense.

Hello,

Linux is a operating system based on the UNIX operating system developed by Bell Labs (AT&T) in the 1960's. It is faster at file operations and more secure than Microsoft Windows but requires more customization than Microsoft Windows. Most software for Linux in Open Source and available for free. Most web servers that host more than one site run a version of Linux annd the protocols for web traffic are based on the original Unix communication standards.

There are many different versions (referred to as distributions) of Linux available but the most popular for Personal desktop or Laprtop use are Ubunto and Fedora. For server there is the top of the line RED HAT Linux, CentOS, SUSE and several others.

To answer your question I would have to say a Linux box is a server that requires very little maintenance when properly configured. The company I work for has 2 Linux techs that are primarly available for configuration questions and building new servers. Compare this to the 8 Windows techs and 6 Exchange techs that are always trying to fix some bug or problem with Microsoft Products.

Hello,

I think you are trying to run from the wron table. don't run from suppliers run from the table you are trying to get results for. In this case it would be the order_items table. If you run for all supliers then you get supliers with nothing ordered. If you run from order_items then you get all iteems and their supliers. That is what the join does. It links the data in the individual record to a record in the other table. If you change the select I gave you the new output will be sorted by supplier and give one line per product with a total quantity.

Select
Suppliers.supplier_name,
Suppliers.supplier_email,
orderitems.product_id,
orderitems.product_name,
sum(orderitems.product_qty) as quantity
from
orderitems
Inner join orders on orderitems.order_id = orders.order_id
Inner join suppliers on orderitems.supplier_id = suppliers.supplier_id
where
orders.order_date > '01/01/2012' AND
orders.order_date < '02/01/2012'
group by orderitems.product_id
order by orderitems.product_id asc, 
Suppliers.supplier_name asc

Your output should be like this:

supplier_name   supplier_email       product_id    product_name     quantity
Tom             tom@thumb.com        67455         Widget                14    
Tom             tom@thumb.com        67456         Widget Large           4
Victory         orders@victory.com   A5551212      Smoke                100

You know I told myself I was not going to comment on this thread again but I just have too now that I have stopped laughing. As if 2TB of ram on laptop was not funny enough to begin with, you forgot to edit and change it from a 32 bit OS ..... and I will bet you don't even know why that is funny.
Good luck with your life and try not to make as big a fool of your self next time.
ROFLMAO

The only one whining in any of the posts is you. And the only one claiming that people must use a specific OS is again you... You are entitled to your opinion like every one else, just don't make things up to make your story sound good.

At least I am not limited to one OS by ignorance and bias.

I still am curious, in your post you said

I tried running the same amount of videos on Ubuntu Linux (99)
As you would imagine, Ubuntu is not very good at opening mass videos.
I had sufficient RAM (1TB) and was using an SSD card and had intel i5.
after opening 50 in about 3 minutes (unlike the Windows machine in 2 seconds, as demonstrated in the video I had provided) I got a black terminal window. And then, the laptop died.

Are you now claiming to own a supercomputer like the one sited in the Yahoo article? And a supercomputer laptop with 1TB of RAM I am impressed. I guess we can just expect this claim is as valid as all your others.

So who makes your laptop carrying case?

I use both Windows and Linux on a daily basis. Windows is a great GUI and Linux is a great server. Use the right tool for the job. You can drive a screw in with a hammer but it is not going to look pretty and may fail.

A few comments I just have to make.

1. The simplest reason the Linux/Unix/OSx are so popular is they work constantly for years and years without reboot or issues. I work in a data center where we have a few thousand servers, some on the web and some on private networks not visable to the web. The ratio is about 65% Windows Server to 35% Linux. However in most cases One Linux server does the same job faster that the 2 to 4 Windows servers performing the same task, hence the ratio. Most of our customers using Windows reboot once every week or at least every two weeks to flush the memory and clean up issues. When we do updates to the OS we reboot at the beginning or the process and of course when the updates finish. We constantly monitor all of the servers and most of our support staff spend their time fixing Windows issues.

The Linux servers on the other hand run for years without reboots and rarly have issues requiring attention. We can and regularly do upgrades to the Kernel, upgrade or install software, remove aplications or add drive space all without rebooting the server. We have …

Well you basically have two choices:
1) Go to the Dell Support Web site and enter the service tag off of the computer and download the driver from them.
2) Go to the intel site and download the driver for the 82801FB Chip set and the AC97 audio controller.

Did you give the user privileges to access the database projects?

Hello,

Based on the apt-get entry I am going to direct you towards this site:
http://www.howtoforge.com/ubuntu_pxe_install_server

OK try this from their site. Put an entry in /etc/init.d to make it a service that you can start or stop.
http://trac.red5.org/wiki/AppServer/Startup%20Scripts
but when pasting the code from the example STOP at the line that reads

esac

The rest is comments on how to use the service.

once it is listed in /etc/init.d you can set it to start when the system boots by using the command line application
chkconfig
Or use the system GUI and go to services and set it to start.

Hello,

On the ports you need available the one I can think of are:

21 ftp
22 ssh
25 smtp (email)
80 http
110 pop3 (email)
115 sftp
143 imap
220 imap2 (email)
443 https
465 smtp SMTP over SSL (TLS)
587 smtp (email - alternate as some ISP's block 25)

All the ports should be listed in /etc/services

On getting your domain name pointed to the server, go to godaddy and for your domain name find the DNS Manager. Point the A record to the IP static address of your router or firewall. On the router make the Linux server your DMZ host.

If you have not already installed email, Apache, mysql and PHP may I suggest looking into qmailtoaster. I use their installation and configuration scripts to set up web servers I manage housing multiple sites and company email. It gives you secure email with anti-spam and virus protection. Web based email and site configuration pages that can be managed by clients, along with webmail (squirrel mail). It also configures Apache and PHP to be secure for preventing sites from being hacked.

http://www.qmailtoaster.com/

Hello,

I would start by finding out what it is mounted as. Use the mount command by it's self to see what filesystems are mounted and where they are mounted.

Below are the results from running mount on my laptop...

[root@lptp1 ~]# mount
/dev/mapper/vg_lptp1-lv_root on / type ext4 (rw)
proc on /proc type proc (rw)
sysfs on /sys type sysfs (rw)
devpts on /dev/pts type devpts (rw,gid=5,mode=620)
tmpfs on /dev/shm type tmpfs (rw)
/dev/sda1 on /boot type ext4 (rw)
/dev/mapper/vg_lptp1-LogVol02 on /nfs type ext4 (rw)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)
fusectl on /sys/fs/fuse/connections type fusectl (rw)
gvfs-fuse-daemon on /home/rod/.gvfs type fuse.gvfs-fuse-daemon (rw,nosuid,nodev,user=rod)

Once you see how and where the fuse filesystem is mounted then unmount the specific connection to the filesystem with

umount <filesystem> <mount point>

Hello,

To be honest I have never configured the service they are referencing so I would not be able to help in that respect. I have seen it in use so I knew about the need to provide the destination addresses which I believe were partially enabled by adding the destination server to the Public servers /etc/hosts file. But beyond that I am not sure.
Sorry.

I think the part you are missing is that during the initial configuration of the Public server the addresses of the Protected servers are provided in a configuration file. Without the configuration file the Public server does not know where to redirect the requests.

Hello,

Try opening a command line window (run CMD) to get a dos prompt then type:

mysql

You should get a mysql shell prompt that your can run queries from like

select * from mydatabase;

I am sure there is a module somewhere to do this however the easiest way I can think of is to output the file as a TAB delimited text file. Then either open it with excel and it will automatically load it to columns or right click the file and select open with excel and it will again automatically use the TABS as column delimiters.

You might want to look into any of the O'Reilly books on the bash shell. The Bash cookbook is a good reference. It will give you all of these examples.

Use the shell built-in variable ${#}. Here’s some scripting to enforce an exact count
of three arguments:
#!/usr/bin/env bash
# cookbook filename: check_arg_count
#
# Check for the correct # of arguments:
# Use this syntax or use: if [ $# -lt 3 ]
if (( $# < 3 ))
then
printf "%b" "Error. Not enough arguments.\n" >&2
printf "%b" "usage: myscript file1 op file2\n" >&2
exit 1
elif (( $# > 3 ))
then
printf "%b" "Error. Too many arguments.\n" >&2
printf "%b" "usage: myscript file1 op file2\n" >&2
exit 2
else
printf "%b" "Argument count correct.
Proceeding...\n"
fi

Use the various file characteristic tests in the test command as part of
your if statements. Your specific problems might be solved with scripting
that looks something like this. This tests for the existence of a file:

if [ -e myfile ]
then do something
fi.

Unary operators that check file characteristics
Option Description
-b File is block special device (for files like /dev/hda1)
-c File is character special (for files like /dev/tty)
-d File is a directory
-e File exists
-f File is …

Good then this will be easy.

The text files with random words I am assuming you can make for your self. But lets say you have the three files called text1.txt text2.txt and text3.txt. Linux has a built in sort command called sort that will do what you are trying to do. To use it you either pipe the output of another program to it or redirect a file in to it.

** Note in my examples the $ is your prompt and not part of the command.

For example to sort the contents of text1.txt you could cat the file and pipe it to sort like this:

$ cat text1.txt | sort

The results will be displayed on your screen. To write the output to a file you simply redirect the output to a file name. The file does not need to exist and using a single redirect if it exists it will be overwritten.

$ cat text1.txt | sort > sortedfile.txt

To sort all three files together you simply list them one after the other:

$ cat text1.txt text2.txt text3.txt | sort > big_sortedfile.txt

By default sort uses the first word of each line and sorts alphanumerically which means that 2 is larger than 10 because the first letter (2) is larger than the first letter of 10 (1). There is a flag to tell it to look for numerical values but you did not ask about that.

I read your question and I still stand by the structure I suggested. This uses the least amount of space and ties all of the data together where it can be queried quickly. It also allows for the number of skills, projects and users to be unlimited. With your method if you add a 101st skill you have to add a new field to the table.

Your statement "Suppose there are 1000 projects, 100 users per project and average of 5 skills per user in a project, then number of records = 1000 x 100 x 5 = 500,000" implies that every user in every project would add a new record for their modified skill rating. Or would you simply be updating some of their skill ratings and adding records for others.

Building the correct indexes to support the tables is the trick since then you only access the records you need. I manage several large databases for the company I work for and the average table has over 350,000 records with the largest holding over 7 million. I frequently pull joined tables containing a million rows of data from the databases is less than a minute.

The really big tables are in Oracle.

What you would need to look at next is what data needs to be accessed on a regular basis and what for? What data can be archived because it is no longer current or the user is no longer part of the system.

I think what you are trying for is where r1 = standard and the status is either NTC or In Progress. If so try this:

SELECT * FROM installs 
WHERE r1 = 'Standard' 
AND (STATUS = 'NTC' 
OR STATUS = 'In Progress') 
ORDER BY building, appointment_date ASC

Ok with a relational database you create a table to hold a specific piece of information. The link the information in the tables together with the record IDs for the information in the other tables. I would create 4 tables projects, users, skills, user_rating

Projects 
ID int 11 primary key
Project_Name varchar 55
Project_description varchar 255

Users
ID int 11 primary key
User_Name varchar 55
User_Address varchar 255

skills
ID int 11 primary key
Skill_Name varchar 55


User_Rating
ID int 11 primary key
Project_ID int 11
User_ID int 11
Skill_ID int 11
Rating int 11

Then you create a record for a skill for a user for a project. Does that make sense?

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?

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 more descriptive names or labels. But lookup tables are useful for more than just SELECT statements. They can help you create new records as well. To illustrate, we'll use the artist and painting tables containing information about your art collection.
Suppose you travel to Minnesota, where you find a bargain on a $51 reproduction of "Les jongleurs" by Renoir. Renoir is already listed in the artist table, so no new record is needed there. But you do need a record in the painting table. To create it, you need to store the artist ID, the title, the state where you bought it, and the price. You already know all of those except the artist ID, but it's tedious to look up the ID from the artist table yourself. Because Renoir is already listed there, why not let MySQL look up the ID for you? To do this, use INSERT ... SELECT to add the new record. Specify all the literal values that you know in the SELECT output column list, and use a WHERE clause to look up the artist ID from the name:

INSERT INTO painting (a_id, title, state, price)
SELECT a_id, 'Les jongleurs', 'MN', 51 …

This might help also:

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		255.240.0.0 	
13	/13 	524288		524286		255.248.0.0 	
14	/14 	262144		262142		255.252.0.0 	
15	/15 	131072		131070		255.254.0.0 	
16	/16 	65536		65534		255.255.0.0 	Class B Network 
17	/17 	32768		32766		255.255.128.0 	
18	/18 	16384		16382		255.255.192.0 	
19	/19 	8192		8190		255.255.224.0 	
20	/20 	4096		4094		255.255.240.0 	
21	/21 	2048		2046		255.255.248.0 	
22	/22 	1024		1022		255.255.252.0 	
23	/23 	512		510		255.255.254.0 	
24	/24 	256		254		255.255.255.0 	Class C Network 
25	/25 	128		126		255.255.255.128 	
26	/26 	64		62		255.255.255.192 	
28	/28	16		14		255.255.255.240	
27	/27	32		30		255.255.255.224	
29	/29 	8		6		255.255.255.248 	
30	/30 	4		2		255.255.255.252

Based on your post I would be willing to bet that the NETBIOS protocol is not loaded on the XP system network card. Open the network card properties and look in the list if you don't see NETBIOS IPX/SPX then you are missing the protocol that windows systems use to identify each other. Click <Install> just below the box and then select protocol from the Dialog box. Then install NETBIOS IPX/SPX from the list. Once complete it is usually best to re-boot even if it does not prompt you to.

Any CD/DVD that will work with Windows will work with Linux. They are generic like hard drives and use the BIOS for communications standards.

If I am understanding you correctly you want a specific user on the XP systems to be able to access certain shared directories on the Vista system. In order to do that you will need to create a user on the Vista system(I would suggest a limited user) with the same name and password as the user on the XP system you want to access the files.

But the poster referred to running this on a laptop and unless you move up to something like ESXi from VMware (which is a Linux based OS) I am not aware of another method to allow you to run some of the older OS's that he mentioned. I run Fedora Core 14 which is primarily designed for Laptops and their various wireless adapters. The installation of the OS from the distribution DVD is easy and has drivers for almost everything built in. I have even removed the SATA laptop drive from my AMD 1.9GHz Athlon x2 based laptop and plugged it into my Intel P4 - 3.6GHZ Desktop and booted the system without any errors or prompts for drivers. Then moved it back without any hitches either.

The virtual OS's run just a hair slower than the real thing on the laptop and having more than one running at a time would not be a great idea. If you would like to give it a try and have any questions I have set this u a couple times for some of our developers and would be happy to assist.

Jlego - Unless you have another idea of a method to accomplish this based on the parameters he supplied then I think this is his best bet. Installing Linux is easier than installing Windows, runs faster, crashes less, has the OS versions he needs available virtually and has practically no Viruses plus it is FREE. Don't knock it till …

You either need to used fixed addresses (not really an option using dynamic DNS) or to set up virtual hosting in Apache. Below are the first three domains on one of my servers running as virtual domains on the same IP address. The lines starting with # are comments and I use them to remind me of what is needed. The singel NameVirtualHost *:80 tells the server to use the next entry as the default for the IP address or unspecified domain.

NameVirtualHost *:80

#<VirtualHost *:80>
#    	ServerAdmin webmaster@chartwriter.com
#    	DocumentRoot /var/www/html/default
#    	ServerName chartwriter.com
#    	ErrorLog logs/chartwriter.com-error_log
#    	CustomLog logs/chartwriter.com-access_log common
#</VirtualHost>

<VirtualHost *:80>
    	ServerAdmin webmaster@chartwriter.com
    	DocumentRoot /var/www/html/chartwriter.com
    	ServerName chartwriter.com
    	ServerAlias www.chartwriter.com
    	ErrorLog logs/chartwriter.com-error_log
    	CustomLog logs/chartwriter.com-access_log common
</VirtualHost>

<VirtualHost *:80>
    	ServerAdmin webmaster@txlinux.com
    	DocumentRoot /var/www/html/txlinux.com
    	ServerName txlinux.com
    	ServerAlias www.txlinux.com
    	ErrorLog logs/txlinux.com-error_log
    	CustomLog logs/txlinux.com-access_log common
</VirtualHost>

<VirtualHost *:80>
    	ServerAdmin webmaster@fortworthjazz.com
    	DocumentRoot /var/www/html/fortworthjazz.com
    	ServerName fortworthjazz.com
    	ServerAlias www.fortworthjazz.com
    	ServerAlias www.dfwjazzfestival.com
    	ServerAlias dfwjazzfestival.com
    	ErrorLog logs/fortworthjazz.com-error_log
    	CustomLog logs/fortworthjazz.com-access_log common
</VirtualHost>

if it is on linux system and you are referring to the active connections to the server use the following:

netstat -a

to list a count of all of the UDP entries use:
netstat -a | grep udp | wc

Not quite.
DHCP is the service that provides systems with an IP address, Gateway and DNS if they ask for it.

A router controls a block of IP addresses and the flow in and out of the subnet to the WAN (or internet). Where a hub or switch (sometimes referred to as gateway mode on routers ) is simply a box that connects several ports together without supplying any services DHCP or Routing (Network address translation in this case). TO put the router in gateway mode you have to turn off both DHCP and routing.

It took me a while to get a handle of how network routing and subnets work and really just took somebody taking the time to explain what is going on.

You have three settings to deal with:
IP Address 192.168.1.100
Netmask 255.255.255.0
Gateway 192.168.1.254

These tell me that the computers address is 192.168.1.100. The subnetmask tells me that I can get to any IP address from 192.168.1.1 to 192.168.1.255 locally on my local network. That if I want to get to an IP outside that range (like google.com at 72.14.213.99) I have to send the traffic through the gateway which will send it along its way and add the routing information for packets to come back to me along the reverse route.

When you had your Belkin LAN and WAN ports in …

Your script should work if you remove the quote marks. However may I suggest something like this. For your crontab entry (assuming your shell script file is in /root/bin and called getpic.sh) use:

00,30 * * * *  /root/bin/getpic.sh <Site URL of file to get> <filename>

For your script use:

#!/bin/bash
cd <path to where you want to store files> 
/usr/bin/wget $1/$2 
mv $2 $2.`date +%s`

Now you have a script you can use on multiple sites with multiple files. The date +%s inside the grave marks (to the left of the 1 below the tilde on most keyboards) will execute the date command and return a large integer and the actual file should show the date created.

%s     seconds since 1970-01-01 00:00:00 UTC

Then you don't have to worry about them being in the correct order in your directory listing or trying to figure out what year, month, day or time they were created. Hope that makes sense and works ok.

I think you will find that date is a reserved word and you need to change the field name.

Your select is forcing the must be in both tables issue. Try a left join instead.

$sql = "SELECT * 
FROM ".$_SESSION[dbprefix]."users
Left join user_skills ON user_skills.userid=users.id 
WHERE ((users.username LIKE '%" . $queryString . "%') OR (users.email LIKE '%" . $queryString . "%') OR (users.firstname LIKE '%" .$queryString . "%') OR (users.lastname LIKE '%" . $queryString . "%') OR (user_skills.skill LIKE '%" . $queryString . "%')) AND enabled='1'  ORDER BY id DESC LIMIT 3 ELSE ";

and you may need to list the fields from each table that you want to display.

First you have to find out what device name the system has given the new drive. Normally it is something like /dev/sda (which stands for scsi or sata drive a) or /dev/hda (pata drive a) and then it will be broken down by partitions. For example the second sata drive primary partition would be /dev/sdb0 .
You can check what partitions the system sees with

fdisk -l

and then mount the partition as a directory on the system. The /mnt directory is normally used for this and the contents or the drive replace what was previously visible in the directory (so don't mount anything to /home or /var or /etc OK). To mount the second PATA hard drive primary partition as /mnt you would use:

mount /dev/hdb0 /mnt

If you are not sure about the mount options use the man pages to get more info:

man mount

Try this and see how it works:

SELECT article.article_title, 
article.article.body, 
count(*), 
sum(comments.status) 
from articles, comments
where articles.ID = comments.Article_ID
group by article.article_title

Should be about right.