Php help plzz

Question

kuteinheart 0 Light Poster

14 Years Ago

Hi ppl,

In a drop down box in PHP i want a distinct value of Date from a column in mysql table.

W_Id  FinishedDate  Username
1         2010-01-25     me
2         2010-01-25     you
3         2010-01-25    she
4        2010-01-26      me
5         2010-01-26     you
6         2010-01-26     she

In the dropdown box i want 2010-01-25 and 2010-01-26 to be displayed only once.

But when I select the date (eg:2010-01-25) in the drop down box, in the next step i want

W_Id  FinishedDate  Username
1         2010-01-25     me
2         2010-01-25     you
3         2010-01-25    she

My PHP code for Drop down box:(I think there is some mistake in this code). I have used Ajax to display on the same screen::

$sql="SELECT DISTINCT(FinishedDate), W_Id FROM WD WHERE Project_Id= '$Project_Id' ORDER BY FinishedDate";

$result = mysql_query($sql) or die("Query to get info ended in error:".mysql_error());

echo "<select name=date value=' ' onChange=showDetails(this.value)>Date</option>";
echo "<option>select Date</option>";

while($row = mysql_fetch_array($result))
  {
      echo "<OPTION VALUE=$row[W_Id]>$row[FinishedDate]</option>";
  }

echo "</select>";

Code for displaying the details when selected a date:

$sql="SELECT * FROM WD WHERE W_Id='".$W_Id."'";

$result = mysql_query($sql) or die("Query to get info ended in error:".mysql_error());

echo "<table border='1'>
<tr>
<th>Username</th>
<th>W_Id</th>
<th>FinishedDate</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
echo"<tr>";
  echo "<td>".$row['Username']."</td>"; 
  echo "<td>".$row['W_Id']."</td>";
  echo "<td>".$row['FinishedDate']."</td>";
 
echo "</tr>";
  }

HELP!!!
Thank you in advance

php

Edited 14 Years Ago by Ezzaral because: Added code tags. Please use them to format any code that you post.

6 Contributors
12 Replies
190 Views
2 Days Discussion Span
Latest Post 14 Years Ago Latest Post by manish.s

Bocarius 0 Newbie Poster

14 Years Ago

It's difficult to give you a right answer to the question. But u can look to php tutorials

diafol

14 Years Ago

OH you yukky pup - put some quotes on! The last time I saw naked attribute values I nearly died of fright!

manish.s 0 Light Poster

14 Years Ago

Please try this .....

$sql="SELECT DISTINCT FinishedDate FROM WD WHERE Project_Id= '".$Project_Id."' ORDER BY FinishedDate";

$result = mysql_query($sql) or die("Query to get info ended in error:".mysql_error());

echo "<select name='your_selected_date'  onChange=showDetails(this.value)>Date</option>";
echo "<option>select Date</option>";

while($row = mysql_fetch_array($result))
  {
	  
      echo "<OPTION VALUE='".$row[FinishedDate]."'>".$row[FinishedDate]."</option>";
	  
  }//EO while($row = mysql_fetch_array($result))

echo "</select>";

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

Code for displaying the details when selected a date:

$sql="SELECT * FROM WD WHERE FinishedDate='".$your_selected_date."' order by  FinishedDate asc";

$result = mysql_query($sql) or die("Query to get info ended in error:".mysql_error());

echo "<table border='1'>
<tr>
	<th>Username</th>
	<th>W_Id</th>
	<th>FinishedDate</th>
</tr>";

if(mysql_num_rows($result) > 0)
{
	
	while($row = mysql_fetch_array($result))
	  {
		  
		echo"<tr>";
		  
			echo "<td>".$row['Username']."</td>"; 
			echo "<td>".$row['W_Id']."</td>";
			echo "<td>".$row['FinishedDate']."</td>";	 
		  
		echo "</tr>";
		  
	  }//EO while($row = mysql_fetch_array($result))
	  
}//EO if(mysql_num_rows($result) > 0)

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

kuteinheart 0 Light Poster · Answer 1 · 2010-01-27T17:37:07+00:00

Hi Himanshi,

I cannot pay for the work, if that is what you are expecting.

sales.triforce 0 Newbie Poster · Answer 2 · 2010-01-27T17:49:02+00:00

Hello
I read your mail and thank you for replying and i will see if ther is any help i can do for you.

rajabhaskar525 1 Junior Poster · Answer 3 · 2010-01-27T17:53:55+00:00

rajabhaskar525 1 Junior Poster

14 Years Ago

try GROUP BY in select query. example see herelink . it helps you.

Edited 14 Years Ago by rajabhaskar525 because: n/a

kuteinheart 0 Light Poster · Answer 4 · 2010-01-27T18:47:37+00:00

Hi raja,

I tried GROUP BY, it didn't work.
Group by displays only one row.
Thanx

try GROUP BY in select query. example see herelink . it helps you.

manish.s 0 Light Poster · Answer 5 · 2010-01-27T22:31:54+00:00

manish.s 0 Light Poster

14 Years Ago

Please try this .....

Edited 14 Years Ago by manish.s because: n/a

rajabhaskar525 1 Junior Poster · Answer 6 · 2010-01-28T11:05:39+00:00

$sql="SELECT FinishedDate, W_Id FROM WD WHERE Project_Id= '$Project_Id' GROUP BY FinishedDate";
       
      $result = mysql_query($sql) or die("Query to get info ended in error:".mysql_error());
       
      echo "<select name=date value=' ' onChange=showDetails(this.value)>Date</option>";
      echo "<option>select Date</option>";
       
      while($row = mysql_fetch_array($result))
      {
      echo "<OPTION VALUE=$row[FinishedDate]>$row[FinishedDate]</option>";
      }
       
      echo "</select>";

$sql="SELECT * FROM WD WHERE FinishedDate='".$FinishedDate."' order by  W_Id asc";

      $result = mysql_query($sql) or die("Query to get info ended in error:".mysql_error());
       
     echo "<table border='1'>
       <tr>
      <th>Username</th>
      <th>W_Id</th>
      <th>FinishedDate</th>
      </tr>";
       
      while($row = mysql_fetch_array($result))
      {
      echo"<tr>";
      echo "<td>".$row['Username']."</td>";
      echo "<td>".$row['W_Id']."</td>";
      echo "<td>".$row['FinishedDate']."</td>";
       
      echo "</tr>";
      }

try above code.

kuteinheart 0 Light Poster · Answer 7 · 2010-01-28T12:30:46+00:00

Hi Manish,

WOW!!! That worked Great!!!!

But I have another Problem...

This is the Table:

W_Id  FinishedDate  Username
  1        2010-01-25     me
  2        2010-01-25     you
  3       2010-01-26      me
  4       2010-01-26     you

In the First Dropdown box, I have the list of Username: me, you

In the second Dropdown box, I have the FinishedDate corresponding to the users...
ie: When i click (me) in first DDbox, I will get 2010-01-25 and 2010-01-26 in the second drop down box...

NOW, When i select the date (eg:2010-01-25)
I want the entire row related to (me and 2010-01-25) to be displayed, like this:

W_Id    Username   FinishedDate
 1              me            2010-01-25

I have used AJAX so that it will be displayed on the same page...
My problem is i don't know how to pass both the variable of Username and FinishedDate in the AJAX Function

function showDetails(Username, FinishedDate)
{
xmlhttp=GetXmlHttpObject();
if (xmlhttp==null)
  {
  alert ("Browser does not support HTTP Request");
  return;
  }
var url="getdetails3.php";
url=url+"?FinishedDate="+FinishedDate ;
url=url+"&Username="+Username;
url=url+"&sid="+Math.random();
xmlhttp.onreadystatechange=stateChanged;
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}

Do u have an idea, how to solve this???
Thanx

kuteinheart 0 Light Poster · Answer 8 · 2010-01-28T20:08:46+00:00

Hi,

Thankyou very much!!!!

I solved the problem.... I GOT ITTTT

I couldn't have done it without your help

Thanx a million

manish.s 0 Light Poster · Answer 9 · 2010-01-28T20:22:11+00:00

You are welcome...

Hi,
Thankyou very much!!!!
I solved the problem.... I GOT ITTTT
I couldn't have done it without your help
Thanx a million