Search results for query: *

Hi, I'm looking for a way to paste data into a sheet where data has been filtered. Eg: Sheet1: 1| A 2| B 3| C 4| D Sheet2 (filtered data): 1| 10 3| 30 7| 70 8| 80 I want to paste the column from Sheet1 onto Sheet2, so that it will read: 1| 10 A 3| 30 B 7| 70 C 8| 80 D Sorting is not...

Hi, My company installed a VPN client on my Windows XP laptop recently, and now I can no longer see the other PC's within my home LAN. Here's the setup: Internet -> Router (DHCP) -> LAN The VPN client installed is Check Point VPN-1 SecureClient ipconfig /all returns: Windows IP...

Hi, I'm using MySQL with PHP, and I was wondering what would be the better way of doing things performance-wise. Sometimes I need data (some of it grouped, such as SUMs) from 5 columns in one time. Would it be better to execute one complex SQL query (with a lot of JOINs, SUMs and what not) or...

I have cleaned up my old PHP installations on my Windows XP machine, and installed the latest PHP version (PHP 5.1.4) on it. I first used the automatic installer, but it seemed impossible to enable the bundled GD support (although the only thing that had to be done was to uncomment the relevant...

I don't understand why this code class player: name = '' hand = [] def __init__(self, name=""): self.name = name class test: def addItem(self, recipient, item): recipient.hand.append(item) def main(): me = player("LaundroMat") him = player("Someone...

Hi, I'm initializing a database with random numbers, and I noticed INSERTing the data into my mySQL database does take quite some time (especially considering the amount of data I want to enter). Here's the script: for ($x = 1; $x <= SIZE_X ; $x++) { for ($y = 1; $y <= SIZE_Y ; $y++) { $amt...

Hi, Is it first of all possible to store an object in a session variable? Eg: $user = new user(); // $user->login returns MSG_LOGGEDIN if ok. if ($user->login($login, $pw) { $_SESSION["user"] = $user; } On the page where I execute the above code, a print_r($_SESSION["user"]) gives me a...

Hi - I've been looking all night for an answer to these tow (related?) problems. Add/Remove software has disappeared from my Control Panel. Before that, it just didn't work (I clicked & nothing happened). Also, most of the .cpl's in Administrative Tools don't work (eg Event Viewer). I have...

Suppose I have an HTML file with a few anchors in it. Now also suppose that I get the url "main.php?anchor=part_two" instead of "main.php#part_two". What would be the best way to translate the GET data into an anchor, and make the browser "jump" to the part of the page intended?

I'm pretty sure I saw a way to convert an associative array to variables. This array: $array = ("one"=>1, "two"=>2); Can it be converted to two variables, $one and $two, with the values 1 and 2? I think I'm blind, as I can't find this anywhere in the manual anymore...

Hi, I'm accessing an Excel file through PHP, and apparently the Excel DNS Driver I'm using has a problem with the euro sign (€) in column names. This for example $query = "SELECT * FROM [Amount in €]" produces an error odbc_exec(): SQL error: [Microsoft][ODBC Excel Driver] Too few parameters...

Hi, Is it possible to completely remove the borders between table-cells? {border: none} doesn't resolve this, as there is still a 1px line between all <tr>'s and <td>'s (in the bkg colour, if I'm not mistaken). Are there other style tags that effectively remove these borders? Thanks in advance

Hi, In my page I have an image with the float:left attribute. Text neatly flows around it, but is there a way to make sure a portion of text is not displayed next to the image? In other words, does a tag exist that basically says something like "carriage return until image is no longer next to...

Hi, Is there a way to retrieve data from an SQL sheet without defining names first? The problem with names being that either you have to redefine them each time data is added to the column, or that you name a full column, which created too much overhead (ie all NULL values are being returned...

I've got a little login script setup, but I'm stumped when it comes to session handling. The first script collects the data in a form (main.php) and sends it to checklogin.php. This script compares the data entered with what's in the database. If all's ok, it copies the userID and nickname to...

Hi, As my host won't upgrade to PHP5 anytime soon, I'm looking for tutorials on how to be "prepared" for PHP5, while developing in PHP4. Any pointers to what has to be looked out for (ie objects etc)?

Is there a place on the web with Python scripts? Googling doesn't offer a lot, sadly. Thanks in advance.

Hi, When I include an image in a link, like in: <a href=&quot;www.google.com&quot;><img src=&quot;google.gif/>Google!</a> and having defined links like such: a { color:#000000; font-weight:600; text-decoration:none; } Opera does not show a border around the linked image, but IE does... How...

Hi, Suppose I have these tables: user: id, name faq: id, question, answer, q_author, a_author How can I do a SELECT on the faq table, and get the authors of the question and of the answer out of the user table? This (naturally) doesn't work, but it gives an idea of what I'm trying to do...

Hi, Suppose I have these tables: game: game_id, gamename score: user_id, game_id, score user: user_id, username I would want to get a list of how many top scores each user has. I got as far as: SELECT score, username, gamename FROM score, user, game WHERE score.user_id = user.user_id AND...