|
Probably using a session would be the best way to do it
|
|
|
|
|
Hi
i have a mysql database which i use to update a soccer league table when i enter in results from a form, works fine, however i would like to be able to enter latest scores and update table based on latest scores entered but i cant work out how to do this as at the moment when i enter an update in the score for a match it will treat it as a new match and allocate points etc all over again
Example
teama 1 teamb 0 would give the following teama goals for 1, teamb goals for 0, goaldifference = teama goals for - teamb goals for which in thiscase would be 1
if it changed to
teama 3 teamb 0 would give the following teama goals for 3, teamb goals for 0, goaldifference = teama goals for - teamb goals for which in thiscase would be 3 but it adds the 3 from this update to the 1 from previous update giving 4.
so i need a way to stop it treating each update as a new result and only update with new data - the previous data so in my example
3 goals - 1 goal from first update = 2 goals , i have other fields like points that need to be treated same way.
hope someone can helpout with this and point me in right direction
kenny
|
|
|
|
|
Okay, how are you storing the data in the table (which I'll call Results). I'm imagining something like this after the first result:
RowId Team1Id Team2Id Team1Score Team2Score
0 1 2 1 0
It sounds like you are doing an INSERT when you submit the data, which will give you:
RowId Team1Id Team2Id Team1Score Team2Score
0 1 2 1 0
1 1 2 3 0
When you want to update the score, use an UPDATE command instead of a INSERT command. You'll need the row's Primary Key (RowId in my example), and you'll end up with this:
RowId Team1Id Team2Id Team1Score Team2Score
0 1 2 3 0
As you want.
|
|
|
|
|
Is it possible to access local machine form webpage without IE/ActiveX? For example, can I execute an exe file on a local machine? Or, If viewer's machine hosts a webservice, can i invoke it through webpage?
|
|
|
|
|
Please do not post the same question in multiple forums.
I must get a clever new signature for 2011.
|
|
|
|
|
Like a virus or tracker. Can I have the link please!!
|
|
|
|
|
Dear all,
I am off because my program is not working. I tried to combine the three arrays of gene expression to get single array. Then I tried to get a subset of array from the single combined array. So I wrote the following code:
But the problem is this:
Use of uninitialized value $val in scalar chomp at C:\manoj_bioinform\expression.pl line 33, <DIAMIDE> line 8808.
Please help me what's wrong with my program..........!!!
#!/usr/bin/perl -w
#Open the three .txt file to the FILEHANDLE
#and create the arrays for all the three file
open (HYPEROSMOTIC, "hyperosmotic.txt")|| die "can't open the hyperosmotic file: $!\n";
@hyperosmotic = <HYPEROSMOTIC>;
open (HEATSHOCK, "heatshock.txt")|| die "can't open the file heatshock: $!\n";
@heatshock = <HEATSHOCK>;
open (DIAMIDE, "diamide.txt")|| die "can't open the file diamide: $!\n";
@diamide = <DIAMIDE>;
#store all the expression data on the three array
#into single @excomb array
@excomb = (@hyperosmotic,@heatshock,@diamide);
#print @excomb;
#loop to split each line from the @expdata into a new tiny array
#the columns of data in the original file are
#separated by tabs as denoted by the /\t/
#then save only the info from column 0 and 2 as separate variable
#also "chomp" each variable to remove unseen characters
foreach $excomb(@excomb)
{
@tarray=split(/\t/, @excomb);
$genename=$tarray[0];
$val=$tarray[1];
chomp $genename;
chomp $val;
}
print @tarray;
|
|
|
|
|
Old school so I don't know specifically what the following expression does
foreach $excomb(@excomb)
But I certainly can guess. It iterates through the array putting a value into $excomb
And it would certainly seem reasonable to me that you would want to actually use $excomb somewhere. Say in the following statement. But you don't.
@tarray=split(/\t/, @excomb);
(Even if the specifics are wrong I am almost certain that using the array there is not what you want.)
|
|
|
|
|
Hi , have a good day !
I am peaceful person , I need to download flash plug in , open source projects , watch youtube , join facebook !
But Those web sites restrict my country ( Adobe , GNU hate us ) ! Plus my country restricted any page contains the word "P r o k s y" That's why I mess spelling it !
So I am asking you kindly , To upload for me a good "PHP Proksy" , with masked name "Proksy" or any other name !
So I can Combine it with my web site , and surf the internet freely !
Kind regards
I know nothing , I know nothing ...
|
|
|
|
|
You can use VPN it change your ip that site think you national US
And Proksy is false, you should search proxy it free in this sitephpproxy[]
Regard
|
|
|
|
|
<big>
You can install flash player adobe. It is very good. You can use version 10.12 .
If you can't see video in youtube, you will use Google Chrome version 10.0. About facebook, you must change DNS :
208.67.220.220
208.67.222.222
You want design php . You should install Server for your PC. I think you use <b>Wamp server 2.0 </b>
It have phpMyAdmin to can help you.
</big>
|
|
|
|
|
|
How can I insert image into toolbar? like code project show small picture on toolbar
Regard.
|
|
|
|
|
if you're interested in having your own little icon on the browser's tabs, Google for favicon.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Thanks I found favicon code it's below but it didn't work why?
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head profile="ico.htm">
<link rel="shortcut icon" type="image/x-icon" href="/3.ico">
<title>icon</title>
</head>
Is it take several time to work exactly?
|
|
|
|
|
This one line of code in the head part of the HTML works for me:
<link rel="shortcut icon" href="images/favicon.ico" type="image/x-icon" />
assuming the icon file "favicon.ico" (IIRC the name matters) is in the server's "images" folder.
When in doubt, look at the "page source" of any web page that gets you interested.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
You can look at the page source of codeproject.com and search for favicon:
I recommend to use the whole path to the image like "http://www.codeproject.com/favicon.ico" if you want to work in subdirectories and you want to use .htaccess.
|
|
|
|
|
Thank you very much, however I discovered that many years ago and am using it myself, see my reply above.
You are replying to the wrong person.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
You can look at the page source of codeproject.com and search for favicon:
<link rel="icon" href="/favicon.ico" type="image/ico">
I recommend to use the whole path to the image like "http://www.codeproject.com/favicon.ico" if you want to work in subdirectories and you want to use .htaccess.
I hope that I am answering to the right person now
|
|
|
|
|
Thank alot for your help
it work right
|
|
|
|
|
<b> I have an exercise in python but I have any Idea to do it : </b>
It is about the last two exercise of chapter 4 of the book how to think like a computer scientist.
the adress is <a href="http://openbookproject.net/thinkCSpy/ch04.html">http://openbookproject.net/thinkCSpy/ch04.html</a>[<a href="http://openbookproject.net/thinkCSpy/ch04.html" target="_blank" title="New Window">^</a>]
|
|
|
|
|
i got an simple code as below, after run once, it results insert twice in mysql database.
I had googled for the whole day struggling for this, I couldnt figured out what happen to this code. It runs perfectly at localhost but after move to server, problem occured. Anyone faced it before? Got some idea on how to resolve this problem?
***FULL CODES***:
***RESULT***:
result=1
1 -- testing -- 1298185509
2 -- testing -- 1298185511
|
|
|
|
|
i think code is right ....try to remove
$result=mysql_query($sql);
echo "result=".$result;
before INSERT any data check the total record in database maybe added something and you don't know...
and use this only
mysql_query($sql);
if it works let me know ...
|
|
|
|
|
Subject is pretty self explanatory. This is what I have for code and then I'll try to explain it.
<?php
echo "Login page";
?>
<form action="rememberMe.php" method="post">
<div style="width: 30em;">
<label for="name">Please Enter Your Name:</label>
<input type="text" name="name" id="name" value="" />
<br />
<label for="location">In what location do you work<br />(Portland/Brewer)?</label>
<input type="text" name="location" id="location value="" />
<div style="clear: both;">
<input type="submit" name="sendInfo" value="sendInfo" />
</div>
</div>
</form>
and then
<?php
$name = $_POST["name"];
$location = $_POST["location"];
$cookie = $name. "," . $location;
setcookie( "thomasEmployee", $cookie, time() + 60 * 60 * 24 * 365), "/", ".linuxserver", false, true);
if (isset($_COOKIE['thomasEmployee'])) {
var_dump($_COOKIE);
}
else {
header( 'Location: index.html' ) ;
}
?>
This is the page where I'm trying to "write" the cookie. The name I'm trying to use for the cookie is thomasEmployee, using the variable I created ($cookie) to hold the value, setting it for a year (though I'm sure it'll get deleted before then), and the domain (part I'm not sure about) is linuxserver. This is for a intranet site, the url for the indexpage is typed linuxserver/index.html so I'm guessing the domain is linuxserver?
What I have right now doesn't seem to be writing anything as when I go to look for it, it's not there and when I try to get to my test page, it brings me right back to the login page.
<?php
if (isset($_COOKIE["thomasEmployee"])) {
}
else {
header( 'Location: login.php' ) ;
}
?>
<html>
<head>
That's the top of the page where I currently have it checking for the cookie.
I'm sure it's something stupid, so thanks in advance!!!
|
|
|
|
|
First guess is that you've run into the old "too late to send headers" problem. Quoting from the PHP manual:
setcookie() defines a cookie to be sent along with the rest of the HTTP headers. Like other headers, cookies must be sent before any output from your script (this is a protocol restriction). This requires that you place calls to this function prior to any output, including <html> and <head> tags as well as any whitespace. <br />
Note the last few words. A single space or newline can break your code.
HTH
Peter
Software rusts. Simon Stephenson, ca 1994.
|
|
|
|