AdGuru.org Your own Forum http://www.adguru.org/index.php Fri, 20 Nov 2009 15:11:12 -0500 120 AdGuru.org http://www.adguru.org/style_images/ip.boardpr/logo4.gif http://www.adguru.org/index.php Help with Updating Database via HTML Form http://www.adguru.org/index.php?showtopic=65414 Step 1: Pull a record from a database (which is done)
Step 2: Give the user the ability to edit the record information via text and textarea boxes (html forms, done.)
Step 3: When the form is submitted, the database should be updated with the user's changes via a SQL update statement. I am not receiving an error, but the record is not being updated. Please let me know your thoughts. The column/field names are all correct.

HTML FORM with PHP values being pulled in


Code:
<?php include("connect.php"); // connection to database

mysql_select_db("mmpprojects", $con);


$taskNo = "$_POST[task]";
$assignTo = "$_POST[assignTo]";
$open = "Open";
$closed = "Closed";

$result = mysql_query("SELECT * FROM Tasks
WHERE taskNo = '$taskNo' AND assignTo = '$assignTo'");

echo "<form action='editTask.php' method='post'>";

while($row = mysql_fetch_array($result))
{
$taskNumber = $row['taskNo'];
$project = $row['project'];
$manHours = $row['manHours'];
$dueDate = $row['dueDate'];
$createDate = $row['creationDate'];
$taskMessage = $row['taskMessage'];
$assignee = $row['assignTo'];
$status = $row['Status'];
}
echo "<strong>Project Name:</strong> <input name='project' type='text' value='" . $project . "' />";
echo "      ";
echo "<strong>Task No#</strong> <input name='taskNo' style='background-color:#006633' type='text' disabled size='2' value='" . $taskNumber . "' />";
echo "      ";
echo "<strong>Est* Man Hours:</strong> <input name='manHours' style='background-color:#006633' type='text' disabled size='2' value='" . $manHours . "' />";
echo "      ";
echo "<strong>Creation Date:</strong> <input name='createDate' style='background-color:#006633' type='text' disabled value='" . $createDate . "' />";
echo "<br />";
echo "<strong>Assigned To:</strong> <input name='assignTo' type='text' value='" . $assignee . "' />";
echo "<br />";
echo "<strong>Due Date:</strong> <input name='dueDate' type='text' value='" . $dueDate . "' />";
echo "<br />";
echo "<strong>Status:</strong> <input name='notNeeded' type='text' style='background-color:#006633' disabled value='" . $status . "' />";
echo " ";
echo "<strong>Change Task Status To:   </strong><select name='status'>
<option value='Open'>Open</option>
<option value='Closed'>Closed</option>
</select>";
echo "<br />";
echo "<br />";
echo "<strong>Message:</strong>" ;
echo "<br />";
echo "<textarea name='message' cols='40' rows='10'>" . $taskMessage . " </textarea>";
echo "      ";

echo "<input name='save' type='submit' value='Save Changes' />
<input name='reset' type='reset' value='Reset' />";

echo "</form>";

?>

EDIT TASK.PHP


Code:



<?php
<?php include("connect.php"); // connection to database

mysql_select_db("mmpprojects", $con);
$taskNo = "$_POST[taskNo]";
$dueDate = "$_POST[dueDate]";
$assignTo = "$_POST[assignTo]";
$project = "$_POST[project]";
$message = "$_POST[message]";
$status = "$_POST[status]";
$manHours = "$_POST[manHours]";
$createDate = "$_POST[createDate]";
$open ="Open";
$closed = "Closed";


mysql_query("UPDATE Tasks SET taskNo = '$taskNo',dueDate = '$dueDate',assignTo = '$assignTo',project = '$project',taskMessage = '$message',Status = '$status',manHours = '$manHours',creationDate = '$createDate' WHERE taskNo = '$taskNo'");


?>
]]> Fri, 20 Nov 2009 12:17:50 -0500 http://www.adguru.org/index.php?showtopic=65414 checkbox, MySql and PHP http://www.adguru.org/index.php?showtopic=65415
To check my results I use:
$box = $_POST[box];
print_r(box);
in the next script

My array gets filled when I use:
$table .= '<td><input type="checkbox" name="box[]" value="here is one"></td>';

My array has nothing, when I use:
$login = 'something';
$table .= '<input type="checkbox" name="box[]" value="<?php echo($login); ?>"></td>';

My array has nothing, when I use:
$table .= '<input type="checkbox" name="box[]" value="<?php echo($row['LoginID']; ?>"></td>';

So, what am I doing wrong?]]> Fri, 20 Nov 2009 12:14:14 -0500 http://www.adguru.org/index.php?showtopic=65415 From: S19: Laura http://www.adguru.org/index.php?showtopic=65407
QUOTE
I also have to wonder how much Laura's disdain and hatred of Shambo stems from her lesbianism? I don't know if she has come out to anyone but even if she hasn't, she strikes me as the type to inadvertently reveal it in conversations to others (or others have picked up on it). Laura strikes me as the type of Christian that would hate gay people (and give most other Christians a bad name).


I'm not sure if it's funny or sad that you, and several others here who have said the same thing, have nothing to base this on but your intolerance towards Christians.]]> Fri, 20 Nov 2009 12:11:45 -0500 http://www.adguru.org/index.php?showtopic=65407 Miley Is A Prosti-Tot! http://www.adguru.org/index.php?showtopic=65398


Oh, she's just bein' Miley!


Miley Cyrus had an '80s-themed 17th birthday bash in New York at the Canal Room on Thursday night and the Disney star dressed up as Julia Roberts' character in Pretty Woman - Vivian Ward, the hooker with the heart of gold!


We wonder which outfit she chose?


Who wants to bet it's the one from the beginning with blonde wig and thigh-high boots filled with condoms!?


Miley's mama Tish arranged for Constantine Maroulis and the rest of the cast from Rock of Ages to perform at the party.


A source reveals:


"Miley had seen the show two weeks ago and loved it, so her mom Tish brought the cast in to surprise her. But I'm not sure who was more into Constantine — Miley or her mother. Between songs from the musical, Miley grabbed Constantine and danced with him at the front of the stage and then Tish joined in."


Sounds like quite the hootenanny!


And we hate to break it to you, Miles, but Pretty Woman is from 1990!


[Image via Ray Garbo / WENN.]


]]> Fri, 20 Nov 2009 12:00:30 -0500 http://www.adguru.org/index.php?showtopic=65398 Oprah Announces The End In Her Own Words http://www.adguru.org/index.php?showtopic=65399


On today's episode of The Oprah Winfrey Show, the Queen of Daytime TV announced the end of her reign.


Oprah explained the decision came "after much prayer and careful thought," but ultimately, it was the best choice for her. Holding back tears, she thanked her viewers who have vigilantly watched her show for over 20 years. She recalled how nervous she was when she started back in 1986 but revealed that she never believed it would lead down a "yellow brick road of blessings."


How emotional!


[Image via AP Images.]

]]> Fri, 20 Nov 2009 11:45:00 -0500 http://www.adguru.org/index.php?showtopic=65399 Is Dustin Hoffman A Focker No More? http://www.adguru.org/index.php?showtopic=65400


Ben Stiller and the gang have begun filming the third installment of the Meet the Parents franchise, Little Fockers, but rumor has it that Dustin Hoffman won't be reprising his role as Bernie Focker!


Supposedly, Hoffman was going to make a cameo at the end of the film, but it appears he may have pulled out due to scheduling conflicts or because the part wasn't big enough for him!


Diva!


As for Barbra Streisand, she's still playing a big role in the film as Ben Stiller's mother.


We'll just have to wait and see if Dustin and Universal can come to some sort of agreement or it looks like Roz Focker will be going grandma alone!


[Image via Andres Otero / WENN.]


]]> Fri, 20 Nov 2009 11:30:52 -0500 http://www.adguru.org/index.php?showtopic=65400 SuBo Breaks Records! http://www.adguru.org/index.php?showtopic=65401


Sharon Osbounre is going to be eating her words once she hears this news!


Beloved Scottish sensation, Susan Boyle, has just broken the record for most pre-order albums on Amazon.com.


We hear the website has been "inundated" with requests for SuBo's debut cd, I Dreamed A Dream, and the numbers have "far surpassed" anything anyone had imagined.


That's how SuBo rolls!


Work it out girl!


[Image via WENN.]

]]> Fri, 20 Nov 2009 11:15:01 -0500 http://www.adguru.org/index.php?showtopic=65401 Divorcing! Poor Dawson Leery Never Gets the Girl http://www.adguru.org/index.php?showtopic=65402


James Van Der Beek has filed for divorce from his wife, non-celeb Heather McComb, after six years of marriage.


No reason has been released, but his rep insists that the duo remain "good friends."


That is exactly what Joey Potter told Dawson when Creek ended!


Geez, this guy can't catch a break!


[Image via WENN.]

]]> Fri, 20 Nov 2009 11:00:40 -0500 http://www.adguru.org/index.php?showtopic=65402 <![CDATA[Celebs React To Oprah's Departure]]> http://www.adguru.org/index.php?showtopic=65403


After a quarter of a century, Oprah Winfrey will be leaving you stay-at-home moms to your own devices as she is ending her daytime reign in September of 2011.


Many of her close friends and colleagues took a moment to respond to the news and, as you would imagine, they all have nothing but the best to say.


Her life partner in crime, Gayle King, assured the press that the decision to leave her daytime days behind was hers and hers alone. Furthermore, she has no doubt that Oprah will find a way to fill the void left behind:


" I think that Oprah always makes the best decision for herself. I really do. And I have a feeling she will come up with some things to do. She has a very full life … We don't need to worry about her filling her time, I promise you that! Life is good for her."


New bestie Ellen DeGeneres made similar comments when addressing her in-studio audience last night, saying:


"Hey listen, I'm going to tell you some news you're going to hear as soon as you go out into the world, when you leave here. Right before I came out here, I got a call from Oprah and she told me that she is announcing that next year will be her last year. It will be her 25th year, and she feels like it's time for her to stop…I don't think I could be here without her. I think she has blazed a trail … She is an amazing woman…She will always be the Queen of Daytime Television."


Ah, but there is another Queen of Daytime who's doesn't think we have seen the last of O. Martha Stewart told reporters that she believes Oprah will be back, once she has had some time off:


"She'll do another show. She's evolving. She's fabulous."


We're sure she will do another show as well. Question is, will she have it air on network TV or her new cable network, OWN?


We'll have to wait and see.


What do U think of O's big move?


[Image via AP Images.]


]]> Fri, 20 Nov 2009 10:45:12 -0500 http://www.adguru.org/index.php?showtopic=65403 Using CSS Variables Style Sheet with PHP http://www.adguru.org/index.php?showtopic=65416
Here is one example that seems to be good:

http://sperling.com/examples/pcss/

Q : Any other favorite methods?]]> Fri, 20 Nov 2009 10:44:47 -0500 http://www.adguru.org/index.php?showtopic=65416