Posts by |-|x

Something like this would work, you may also be able to make use of the SELECT DISTINCT predicate if it helps - however, I think using the GROUP BY clause is cleaner and likely more efficient.

food for thought anyway...

select * from mytable where id=(
    select id from mytable where sid=(
        select Min(sid) from mytable
    ) limit 0,1
) or id=(
    select id from mytable where sid=(
        select Min(sid) from mytable where not sid=(
            Select Min(sid) from mytable
        )
    )limit 0,1
);

What specific error messages are you getting?

at a quick glance I can advise the following:

You will probably need to surround your SET variables with quotes, ie: "... SET PublishDate='$update' ..." Also, assuming that PublishDate is a datetime field of some sort in your database, you will need to ensure the data being input is in a format that MySQL can convert to a date, such as "yyyy-mm-dd"

I don't think $id= $_POST["id"]; will work since you are passing the value in the url.

take a look at $_Request and HttpQueryString

Hi ZeroEddy

Just had a quick glance at your css code and can give you the following advice (anyone feel free to correct me if you have a better idea).

1 - Using font-size as a percentage does not make it relative to page/screen size, but to the base inherited font size. I guess you could resize the font with some javascript, but I don't think there is a way in css to specify dynamic font size.

2 - I believe you need to add a float (left or right shouldn't matter) to the navbar div. This will cause the float on main div to follow the navbar rather than the navbar's children. [ie: it should stop the divs from jumping]

You will likely need to play with this and tweak it, especially if you check it in firefox/chrome and IE as they often do things differently.

Hope this helps.
~H

echo doesn't print the variable values when using a single quoted string.
ie:

$id = 1;
echo "<td>$id</td>"; // output: "<td>1</td>"
echo '<td>$id</td>'; // output: "<td>$id</td>"

there are a number of ways you could get around this issue, one would be to change those two link lines to be like this

echo '<td><a href="update_tanent.php?id=',$id,'">Edit</a></td>';

(for more information, check the php man pages ;)

Another related, useful tool by security expert Steve Gibson...
https://www.grc.com/haystack.htm

You may be able to configure a browser proxy on your VPN connection, which should redirect browser activity via the vpn - but as Lola said, it will depend on the specific configuration of your company network.

You should also check the usage policy (if the company has one) as you may be required to use specific methods for accessing services.

I'd say as long as you can see that your firewall is blocking his attempts to connect, you're not going to have a problem. Just because he is a member of a hacking forum, doesn't necessarily mean he knows what he's doing. A lot of software can be downloaded from places like that to automate basic things like port scanning.

A lot of the free anti-virus, anti-malware, and firewall software are just as good as the commercial ones. Check the reviews on download sites and you should be fine. This is one area where price does not necessarily equate to quality.

If you can, change your IP address. You should be able to move your internal LAN to a new address range in your router configuration.

You could also contact your ISP and make them aware of the situation. They may be able to move your connection to a different subnet, and possibly perform some monitoring / filtering of their connection.

If you believe you have sufficient evidence that he is trying to access your system illegally you could report it to the police, but you would probably need back logs that identify his IP address as the source, and I don't know how far you would really get.

Technically, the answer is yes, it is possible. That said, if he is bragging about it, he's not likely to be a serious threat. (The guys that tend to cause serious trouble will do so silently and, if possible, without your knowledge.)

There are some steps you can take to ensure your computer is secure. Things like;

- having a strong password - and change it immediately if you believe your computer has been compromised (accessed by someone without permission).

- Make sure your router / firewall is blocking incoming connections, unless absolutely necessary.

- keep your antivirus / anti-malware / etc software up to date - this will help identify if anyone is putting bad files or programs on your computer.

If you are still concerned about him accessing your computer without your knowledge, there are a number of programs available for free download that can monitor network traffic and detect potential threats on your network or PC.