Lowyat.NET: Latest topics by Jimbitz

Insert data from another table

Jimbitz — Thu, 14 Jun 2007 14:40:08 +0800

Hello,
I want to insert some data from a table into another table using PHP & MySQL.
Need some help from the masters..
I'm still a PHP and MySQL noob.

This is the code that I can come out with after some readings..

CODE

$retrieve = "INSERT INTO employee(emp_firstname, emp_lastname, job_title, ".
"department, emp_status,) ".
"SELECT first_name, last_name, title, department, ".
"employee_status FROM users ".
"WHERE username = '" . $_SESSION['user_logged'] . "' ".
"AND password = (password('" . $_SESSION['user_password'] ."'))";

from phpMyAdmin

QUOTE

SQL query: Documentation

INSERT INTO employee( emp_firstname, emp_lastname, job_title, department, emp_status )
SELECT first_name, last_name, title, department, employee_status
FROM users
WHERE username = '" . $_SESSION['user_logged '] . "'
AND PASSWORD = ( password( '" . $_SESSION['user_password '] . "' ) )

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user_logged'] . "'
AND password = (password('" . $_SESSION['user_password'] . ' at line 3

But I get this error when I try it in the browser and phpMyAdmin..

QUOTE

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') SELECT first_name, last_name, title, department, employee_status FROM users WH' at line 1

Thanks in advance.

[SOLVED] Hard Disk problem

Jimbitz — Sat, 05 May 2007 19:32:49 +0800

Hello..
I have a maxtor [L160P0] hard disk which I use with an external casing.
I seems to have a problem with the size displayed.
It shows that I have a bigger capacity hard disk which is of course is not right.
Should be 160GB formatted to 152GB.
I can't seem to remove the unallocated partition.
Have anyone encountered this problem before and have a solution for it?
If not I would need to sent it for RMA.

[SOLVED] Cannot run Windows Firewall.

Jimbitz — Fri, 16 Feb 2007 00:49:39 +0800

Hello..
I have a problem enabling the windows firewall/internet connection sharing (ICS) service for my friend's notebook.

I have cleaned some malware earlier.. might be some leftover that are still hanging around in there..

Any help is much appreciated..

» Click to show Spoiler - click again to hide... «

[attachmentid=195012]
[attachmentid=195013]
[attachmentid=195022]
[attachmentid=195023]

the start up time for this notebook is also extremely slow.. about 5-6 minutes to finish loading all the programs.

thanks in advance.

Knoppix & USB Network Adapter

Jimbitz — Thu, 04 Jan 2007 04:06:03 +0800

Hello,
I've been playing with Knoppix Live CD for a while now, and I seems to have some problems in detecting my USB network adapter..
I don't know how to configure it in Knoppix to make it to detect the USB network adapter.

I don't really know the exact model for this network adapter but it stated as 'ST268 USB To Fast Ethernet Adapter' at the Safely Remove Hardware in Windows XP.

This USB network adapter is the only way I can use the net now on my notebook..

Any help is much appreciated.
Thanks in advance.

[SOLVED]SysProtect and many more..

Jimbitz — Mon, 18 Dec 2006 01:47:38 +0800

Hello.. I would like some help regarding this problem I have here. The spyware/virus have infected my sister notebook. I guess it start to spread at an alarming rate now. I managed to clean some of them until I come to a complete halt for now.. Each time I scan it with any available tools it will shutdown automatically. This even happened during Safe Mode.

Here is the HijackThis log..

» Click to show Spoiler - click again to hide... «

Any help would be much appreciated..

I had tried VundoFix, NOD32, AVG Anti-Spyware, Spybot S&D, SpySweeper.. most of them would result an immediate shutdown during the scanning process..

Thanks in advance..