PHP - Date Not Posting In Mysql Database From Php Script

hi all,   Firstly I am new to the php language, hopefully this is not a silly question or a no brainer.   I have looked over my code.. and for some reason when I insert data from a cms into a mySql database thers two fields that swop around..   HERES THE CODE IM WORKING WITH :

<?php

//if form has been submitted process it
if(isset($_POST['submit'])){

		$_POST = array_map( 'stripslashes', $_POST );

		//collect form data
		extract($_POST);

		//very basic validation
		if($title ==''){
			$error[] = 'Please enter the title.';
		}


		if(!isset($error)){

			try {

				//insert into database
				$stmt = $handler->prepare('INSERT INTO event_calendar (title,event_date,description) VALUES (:title, :description, :event_date)') ;
				$stmt->execute(array(
					':title' => $title,
					':description' => $description,
					':event_date' => date('Y-m-d')
				));

				//redirect to index page
				header('Location: index.php?action=added');
				exit;

			} catch(PDOException $e) {
			    echo $e->getMessage();
			}

		}

	}

	//check for any errors
	if(isset($error)){
		foreach($error as $error){
			echo '<p class="error">'.$error.'</p>';
		}
	}
	?>
	<form action='' method='post'>

		<p><label>Title</label>	<input type='text' name='title' value='<?php if(isset($error)){ echo $_POST['title'];}?>'></p>

		<p><label>Description</label><br />
		<textarea name='description' cols='50' rows='5'><?php if(isset($error)){ echo $_POST['description'];}?></textarea></p>

		<p><label>Date of Event : (y-m-d) :</label><input name="event_date" type="date" value='<?php if(isset($error)){ echo $_POST['event_date'];}?>'></p>

		<p><input type='submit' name='submit' value='Submit'></p>

	</form>

Could anyone please just look through it.. My database structure is simple.. id, title, description, event_date Thanks in advance  

Maybe some of the great coders here can help this noob out.
So here is what I have so far:

Code: [Select]
//set age criteria for deletion
$age = 60;

//get current date
$datenow  = date("Y-m-d");

//set the range we want to delete
$delete_range = $datenow - $age;

//get old user_id from users table
$oldusers_users = mysql_query ("SELECT user_id FROM users WHERE lastvisit < $delete_range ");

//get user_id from images table that correspond to users table
$oldusers_images = mysql_query ("SELECT user_id FROM images WHERE $oldusers_users=user_id.images ");

//find folders that correspond to the usernames and delete
$oldusers_files = mysql_query ("SELECT username FROM users WHERE lastvisit < $delete_range ");
//print out username
//$result = mysql_($oldusers_files);
$foldername = mysql_result($oldusers_files, 0);

$sigspath = "sigs/";
unlink($sigspath . $foldername . ".gif/index.php");
rmdir($sigspath . $foldername . ".gif");
//now delete user_id's from database
mysql_query("DELETE * FROM users WHERE user_id=$oldusers_users");
mysql_query("DELETE * FROM images WHERE user_id=$oldusers_images");
unset($oldusers_users, $oldusers_images, $oldusers_files, $foldername, $sigspath );
mysql_close($link);
Right now it is only returning the first entry, not the entire list that meets the criteria.  It does delete that one file though but does not remover the rows from the database.

I am sure the database stuff is jacked up I am really new to that part.  What am I doing wrong here or is there a better way to do this perhaps

Hi,
Im just in the middle of creating an update script for my mysql database but don't know why it's not working. p.s. I'm a little new to PHP, but know quite a bit, it's probably something really small.. *facepalm*

Here's the script:

the form (update.php)
<?
// Connect to the database
$link = mysql_connect('###', '###', '###');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('###', $link);

$id = $_GET['id'];

// Ask the database for the information from the links table
$query="SELECT * FROM orders WHERE id='$id'";
$result = mysql_query("SELECT * FROM orders");
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num) {
$name=mysql_result($result,$i,"Name");
$location=mysql_result($result,$i,"Location");
$fault=mysql_result($result,$i,"Fault");

?>

<form action="updated.php" method="post">
<input type="hidden" name="ud_id" value="<? echo "$id";?>">
Name: <input type="text" name="ud_name" value="<? echo "$name"?>"><br>
Location: <input type="text" name="ud_location" value="<? echo "$location"?>"><br>
Fault: <input type="text" name="ud_fault" value="<? echo "$fault"?>"><br>

<input type="Submit" value="Update">
</form>

<?
++$i;
}
?>

------------------------------------------------------
(processor) updated.php

<?php
// Connect to the database
$link = mysql_connect('###', '###', '###');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('###', $link);

$query="UPDATE orders SET Name='" . $_POST['ud_name'] . "', Location='" . $_POST['ud_location'] . "', Fault='" . $_POST['ud_fault'] . "' WHERE $id='" . $_POST['ud_id'] . "'";
echo $query;
$checkresult = mysql_query($query);
if ($checkresult) echo '<p>update query succeeded';
else echo '<p>update query failed';

mysql_close();
?>


------------------------------------------------------

Every time I want to update, it comes up with:

UPDATE orders SET Name='TEST', Location='TEST', fault='jbjh' WHERE =''
update query failed

Any help would be appreciated.

I have an issue with my script, the date for some reason stopped posting after I changed the format in the date() section, I wanted it to post so it shows month-day-year, and it seems for some reason all it accepts is Y-m-d...

Can someone help me out here please?

Code: [Select]
<?php
require_once('connectvars.php');

  if (isset($_POST['submit'])) {
    // Connect to the database
    $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$PO_Date = date('MM "/" DD "/" YY',strtotime($_POST['PO_Date']));
$query = "INSERT INTO ncmr (PO_Date) VALUES ('$PO_Date')";
            mysqli_query($dbc, $query);



// Confirm success with the user
        echo '<p>The date have been successfully entered</p>';
mysqli_close($dbc);

// Clear the score data to clear the form
            $PO_Date = "";
}
echo'<form form id="all" method="post">';
echo '<div id="abd"><span class="b">On:&nbsp;&nbsp;</span><input type="text" name="Added_By_Date" value="" /></div>';
echo '<div id="button"><input type="submit" value="Submit Edits" name="submit" /></div>';
echo '</form>'
?>

Hi there,

I am using this code to send the users email address to the database. That works fine, but i keep getting blank info added to the database. Does anyone know how i can stop this?

<?php
$con = mysql_connect("*","*","*");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("ogs_mailinglist1", $con);

$sql="INSERT INTO mailinglist (email)
VALUES
('$_POST[rec_email]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }

mysql_close($con);
?>



Thanks,

Hi, this is my first post:) pretty sure i will be posting here in the future. Anyway i am having trouble with a php script which downloads a file from a mysql database.

This php script works for text files and should work for most files from what i understand. When downloading a text file, the whole file is downloaded from the server. When downloading an mp3 file, only 16kb are downloaded and the file does not play. When looking at the data in the database, it displays that the full file is there (correct amount of bytes, so there is nothing wrong with my upload php script). Does anyone have any suggestions as to what I can change to make this work?

Code: [Select]
<?php
if(isset($_GET['id'])) 
{
// if id is set then get the file with the id from database
$link=mysql_connect('localhost', 'root', '');
@mysql_select_db('filemgr') or die ("<p>Could not connect to mysql!</p>");

$id    = $_GET['id'];
$query = "SELECT name, type, size, content " .
         "FROM upload WHERE id = '$id'";

$result = mysql_query($query) or die('Error, query failed');
list($name, $type, $size, $content) =  mysql_fetch_array($result);

header("Content-length: $size");
header("Content-type:$type");
header("Content-Disposition: attachment; filename=$name");
echo $content;

mysql_close($link);
exit;
}
?>

After spending 3 days on internet and struggling with so many different forums , i have found this forum where i believe i will get the solution for my problem.

Friends, I am zero in PHP, but still i have managed to do something to fulfill my requirement.

I am stuck with one thing now..So i need help on....

I am using one html+php form to submit database into mysql.
I created a display of that table through php script on a webpage.
Now i want a datepicker option on that displayed page by which i should able to select the date range and display the data of that date range from my mysql table.
And then take a export of data displayed of selected date range in excel.

This displayed page is login protected, so i want after login the next thing comes in should show a sate selection option which should be fromdate to to date , and then records should displayed from the database and i can take export of those displayed results in excel file.
The code i am using on this page is below which do not have any thing included for excel export and datepicker script, I am pasting the code here and request you to please include the required code in it as required.

Thanks In advance

    <?php
    //database connections
    $db_host = 'localhost';
    $db_user = '***********';
    $db_pwd = '*************';
   
    $database = 'qserves1_uksurvey';
    $table = 'forms'; 
    $file = 'export';
    if (!mysql_connect($db_host, $db_user, $db_pwd))
        die("Can't connect to database");
   
    if (!mysql_select_db($database))
        die("Can't select database");
   
    // sending query
    $result = mysql_query("SELECT * FROM {$table} ORDER BY date desc");
    if (!$result) {
        die("Query to show fields from table failed");
    }
    $num_rows = mysql_num_rows($result);
    $fields_num = mysql_num_fields($result);
   
    echo "$num_rows";
    echo "<h1></h1>";
    echo "<table border='1'><tr>";
    // printing table headers
    for($i=0; $i<$fields_num; $i++)
    {
        $field = mysql_fetch_field($result);
        echo "<td>{$field->name}</td>";
    }
    echo "</tr>\n";
    // printing table rows
    while($row = mysql_fetch_row($result))
    {
        echo "<tr>";
   
        // $row is array... foreach( .. ) puts every element
        // of $row to $cell variable
        foreach($row as $cell)
            echo "<td>$cell</td>";
   
        echo "</tr>\n";
    }
    mysql_free_result($result);
    ?>
    </body></html>

Hi All,

I've searched long and hard accross the web for an answer to this and finnally given in and requesting help. Here's what i have, i have a database setup and working fine. What i would like to do is for an administrator to be able to update my users details. It may sound odd, why don't you let your users update their own details? Well the administrators are dispatchers if you like, and my users are the 'dispatchees', for want of a better word. So i would like my administrators to be able to dispatch my users with routes and my users be able to see the routes that have been dispatched to them. I've setup a login area and a page that pulls there routes off the database, depending on their login details, i.e. jack will see his routes and jill will see her's independantly. This works by me editing the appropriate columns/rows of my database using phpmyadmin. What i'd like now is for administrators (who are directed to a seperate page, with more controls) to be able to do the same as me (updating the database) but by using a php form/script.

I'd like to be able to select the routes from a second table on the same database if possible, to try and keep everything tidy. So my dispatcher would select Route001 from a drop down list, this would fill in the text fields next to the route field with From To, so my dispatcher would know what route001 actually is from/ too, choose a username (now being driven from my other table) and hit dispatch. My user would login to their area, hit view dispatched routes and it would display Route 001 with the correct information.

The login area was a downloaded script i modified to suit and is called Login-Redirect_v1.31_FULL

Many thanks in advance, hope you can sort of understand what i want 

Josh

PHP/MySQL ability:Novice

You guys helped me create a function to gather information for my database. Now I need some help with posting that information.

Function code and Form:
<?php include("opendatabase.php"); ?>

<?php
function createMatchup($week, $game)
{
$query1 = "SELECT team_name 
FROM schedule, teams 
WHERE schedule.week_id = $week 
AND schedule.game_id = $game 
AND schedule.A_team = teams.team_id";

$query2 = "SELECT team_name 
FROM schedule, teams 
WHERE schedule.week_id = $week 
AND schedule.game_id = $game 
AND schedule.H_team = teams.team_id";

$result1 = mysql_fetch_assoc(mysql_query($query1));
$result2 = mysql_fetch_assoc(mysql_query($query2));

$output = "
<input type=\"text\" size = \"3\" name=\"w$weekg$gameA\"> {$result1['team_name']} vs. {$result2['team_name']} 
<input type=\"text\" size = \"3\" name=\"w$weekg$gameH\">";

return $output;

}

$game1 = createMatchup(1, 1);
$game2 = createMatchup(1, 2);
$game3 = createMatchup(1, 3);
$game4 = createMatchup(1, 4);
$game5 = createMatchup(1, 5);
$game6 = createMatchup(1, 6);
$game7 = createMatchup(1, 7);
$game8 = createMatchup(1, 8);
$game9 = createMatchup(1, 9);
$game10 = createMatchup(1, 10);
$game11 = createMatchup(1, 11);
$game12 = createMatchup(1, 12);
$game13 = createMatchup(1, 13);
$game14 = createMatchup(1, 14);
$game15 = createMatchup(1, 15);
$game16 = createMatchup(1, 16);

mysql_close($con);

?>

<form action="insert_spreads.php" method="post">
<?php echo $game1; ?>
<br>
<?php echo $game2; ?>
<br>
<?php echo $game3; ?>
<br>
<?php echo $game4; ?>
<br>
<?php echo $game5; ?>
<br>
<?php echo $game6; ?>
<br>
<?php echo $game7; ?>
<br>
<?php echo $game8; ?>
<br>
<?php echo $game9; ?>
<br>
<?php echo $game10; ?>
<br>
<?php echo $game11; ?>
<br>
<?php echo $game12; ?>
<br>
<?php echo $game13; ?>
<br>
<?php echo $game14; ?>
<br>
<?php echo $game15; ?>
<br>
<?php echo $game16; ?>
<br /><br />
<input type="Submit" value="Submit Spreads">
</form>
I'm wondering if I can use this code for posting to the database (insert_spreads.php):
<?php

header("Location: admin_schedule.php");

include("opendatabase.php");

$w$weekg$gameA=("$_POST['w$weekg$gameA']");
$w$weekg$gameH=("$_POST['w$weekg$gameH']");

$sql="
UPDATE schedule 
SET A_pt_spread= '$w$weekg$gameA',H_pt_spread= '$w$weekg$gameH'
WHERE week_id = '$week'
AND game_id = '$game';

$result = mysql_query($sql) or die(mysql_error().$sql);

mysql_close($con)

?>



Thanks for helping.

I'm trying to figure out how to post an array into my database. I am able to post single entries without a problem, but trying to post several entries at once is causing me some headaches. Can anyone check this code and hopefully give me some insight as to where I'm going wrong?

Here's the form:
Code: [Select]
<?php include("opendatabase.php"); ?>

<FORM Method = "POST" action ="insert_spreads.php">
 
<?php
$weekID = $_POST[Week];
echo "<h2>Enter Spreads for Week $weekID</h2>";
print ("<br /><br />");

$result = mysql_query("
SELECT S.game_id, TH.team_name AS HomeTeam, TA.team_name AS AwayTeam
FROM schedule AS S 
JOIN teams AS TH ON S.H_team = TH.team_id
JOIN teams AS TA ON S.A_team = TA.team_id
WHERE S.week_id = '$weekID'
ORDER BY S.game_id;");

while ($row = mysql_fetch_array($result)) {
printf('<input type="text" size="4" name="w%dg%dAspread">', $weekID, $row['game_id']);
printf(" %s vs. %s  ", $row['AwayTeam'], $row['HomeTeam']);
printf('<input type="text" size="4" name="w%dg%dHspread">', $weekID, $row['game_id']);
print("<br /><br />");
} 
mysql_close($con);
?>
<br /><br />

<input type="Submit" value="Submit Spreads">
</FORM>

And here's the "insert_spreads.php
Code: [Select]
<?php

header("Location: admin_main_entry.php");

include("opendatabase.php");

$aspread=$_POST['w%dg%dAspread'];
$hspread=$_POST['w%dg%dHspread'];
$row=$_POST[$row['game_id'];

$sql="
UPDATE schedule 
SET A_pt_spread= '$aspread',H_pt_spread= '$hspread'
WHERE week_id = '$weekID'
AND game_id = '$row'";

$result = mysql_query($sql);

mysql_close($con)

?>
Thanks!

I'm not much of a PHP programmer so please excuse the mess but I'm having a problem with some code. I am able to successfully build a table and assign values to radio buttons based one information in a database. The problem comes when I want to update the database when someone changes a radio button. Everthing works up until the foreach statment. Nothing in the database is being updated, if I replace the sql statement with echo $v; all I get is the word Submit so it's like the rest of the values aren't being included in the form.
<link href="css/demo.css" rel="stylesheet" type="text/css">

<?php
session_start();
// dBase file
        include "dbconfig.php";
if (!$_SESSION["valid_user"])
        {
        // User not logged in, redirect to login page
        Header("Location: index.php");
        }
 //Grab GUID passed in the URL
 $guid=$_GET['guid'];
 // Create query for student name
  $sql = "SELECT FirstName, LastName FROM Students where GUID ='". $guid . "'";
  // Run query
  $result = mssql_query($sql);
  $row= mssql_fetch_assoc($result);
  
// Member only content
//Title and main page information
echo "<div align=\"center\"><p><img src=\"images/EFCTS Logo.jpg\" width=\"600\" height=\"144\" /></p><h1>OCAP DATABASE</h1></div>";
echo "<p><a href=\"logout.php\">Logout</a></p>";
//Build sortable table of student data.
echo "<table id=\"test1\" class=\"sortable-onload-3-reverse rowstyle-alt no-arrow\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">";

//query database for table information
$SQLcommand = "SELECT convert(varchar(36), StudentGUID) as StudentGUID, CompetencyLevel, CompetencyName, CompetencyID, Category, convert(varchar(36), CompetencyGUID) as CompetencyGUID FROM VW_StudentSkills WHERE StudentGUID ='". $guid ."'";
$SQLresult = MsSQL_QUERY($SQLcommand);

//Continue building table
echo "<caption>".$row[FirstName]." ".$row[LastName]."</caption>";
echo "<th style=\"-moz-user-select: none;\" class=\"sortable-numeric fd-column-0\"><a title=\"Sort on \"Competency ID\"\" href=\"#\">Competency ID</a></th>";
echo "<th style=\"-moz-user-select: none;\" class=\"fd-column-1 sortable-text reverseSort\"><a title=\"Sort on \"Catagory\"\" href=\"#\">Catagory</a></th>";
echo "<th style=\"-moz-user-select: none;\" class=\"fd-column-2 sortable-text reverseSort\"><a title=\"Sort on \"Competency Name\"\" href=\"#\">Competency Name</a></th>";
echo "<th style=\"-moz-user-select: none;\" class=\"sortable-numeric fd-column-3\"><a title=\"Sort on \"Competency Level\"\" href=\"#\">Competency Level</a></th>";
echo "</tr></thead>";
//Set variables for radio buttons
$a="";
$b="";
$c="";
$d="";

//count the number of rows returned
$count=mysql_num_rows($SQLresult);
//Start form
echo "<form name=\"form1\" method=\"post\" action=\"".$_SERVER['REQUEST_URI']."\">";

$groupnum = 0;
//Build table with SQL data
while($row2=mssql_fetch_array($SQLresult)) 
{

//find the competency level
$complevel = $row2[CompetencyLevel];
if($complevel=="1") $a="checked";
if($complevel=="2") $b="checked";
if($complevel=="3") $c="checked";
if($complevel=="4") $d="checked";
//build the table
echo "<tr class=\"\"><td>".$row2[CompetencyID]."</td><td>".$row2[Category]."</td>";
echo "<td>".$row2[CompetencyName]."</td>";
echo "<td class=\"lft\"><input type=\"radio\" name=\"".$row2[CompetencyID]."\" value=\"1\"".$a."> 1";
echo "<input type=\"radio\" name=\"".$row2[CompetencyID]."\" value=\"2\"".$b."> 2";
echo "<input type=\"radio\" name=\"".$row2[CompetencyID]."\" value=\"3\"".$c."> 3";
echo "<input type=\"radio\" name=\"".$row2[CompetencyID]."\" value=\"4\"".$d."> 4";
$idarray[]=$row2[CompetencyGUID];
echo "</td></tr>";
$groupnum++;
//clear the variables
$a="";
$b="";
$c="";
$d="";
}

echo "</tbody>";
echo "<input type=\"submit\" name=\"Submit\" value=\"Submit\">";
echo "</form></table>";
echo "<script type=\"text/javascript\" src=\"javascript/tablesort.js\"></script>";

                  if($_POST['Submit'])
                        {
                           echo"submit button detected";
   foreach($_POST as $k=>$v)
                           {                               
                             if($k!="Submit") { 
                              $sqlUpdate = "UPDATE DATA SET COMPETENCYLEVEL = '".$v."' WHERE COMPETENCYGUID = '".$idarray."' AND STUDENGUID = '".$guid."' ";
                              $resultUpdate = mssql_query($sqlUpdate);
  }

                           }
                        }
if($resultUpdate)
                        {    print_r ($_POST); 
echo $resultUpdate;     
echo $sqlUpdate;                  
                                                      
                        }
                        else
                        {
                           echo "Your entry is not completed at this time.............";
   echo $sqlUpdate;
   echo $resultUpdate;
                        }
                    
// Display Member information
//echo "<p>User ID: " . $_SESSION["valid_id"];
//echo "<p>Username: " . $_SESSION["valid_user"];
//echo "<p>Logged in: " . date("m/d/Y", $_SESSION["valid_time"]);

?>

In my app, the users will take a multiplication test with 10 problems... I'm not sure how I would post the grade that the user got to the database.

When the user finishes the test and hits score it should post their Name/Date & Time/ and Score to the database. I have the name and date & time working. Just not sure how I would approach the score.

This is my application... It is small and simple to run in browser.


Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Lab 5</title>
</head>

<body>

<?php

require_once('database.php');






define ('ROWS', 3);
define ('COLS', 3);
define ('MAX_NUMBER', 12);
date_default_timezone_set('America/New_York');



if (isset($_POST['btn_score']))
{

$result_name=$_POST['result_name'];

$sql = "INSERT INTO results (result_name, result_score, result_date_time) VALUES ('$result_name', 100, NOW());";


$db->exec($sql);





//print_r ($_POST);
$time1 = $_POST['ts'];
$time1_object = new DateTime($time1);
$now = new DateTime();
$time_span = $now->diff($time1_object);

$minutes = $time_span->format('%i');
$seconds = $time_span->format('%s');
$seconds+= $minutes * 60;

echo "It took $seconds seconds to complete the test<hr />";



foreach ($_POST as $problem => $answer)
{
if ($problem <> "btn_score" && $problem <> "ts")
{
//echo "$problem -- $answer <br />";
$problem = explode('_', $problem);
$num1 = $problem[2];
$num2 = $problem[3];



$right = $num1 * $num2;

if ($answer != $right)
{
echo "$num1 * $num2 = $answer , The right answer is $right<br />";
}
}
}
}









?>

<h1>Lab 5</h1>

<form name="lab5" method="post" action="lab5b.php">
<?php
$now = new DateTime();
//echo $now->format('Y-m-d H:i:s');
echo "<input type='hidden' name='ts' value='" . $now->format('Y-m-d H:i:s') . "'>";
?>
<table border="1" cellspacing="5" cellpadding="5">

<?php


$no_of_problems = 0;
for ($row=0; $row<ROWS; $row++)
{
echo "<tr>";
for ($col=0; $col<COLS; $col++)
{
$num1 = mt_rand(1,MAX_NUMBER);
$num2 = mt_rand(1,MAX_NUMBER);

echo "<td>$num1 * $num2 </td>";
echo "<td><input type='text' size='2' name=${no_of_problems}_mult_${num1}_${num2}></td>";
$no_of_problems++;
}
echo "</tr>";
}
$colspan = 2 * COLS;
echo "<tr><td colspan=$colspan align='right'><input type='submit' value='Score' name='btn_score'></td></tr>";
?>

</table>
<br>
<br>
<label for="result_name">Student Name:</label>
<input type="text" id="result_name" name="result_name" /><br />
</form>
<br>
<br>





</body>
</html>

I have an email form that is working wonderfully. I have a select box that has a list of names of people that you can email. That list is being pulled from a database.

It is currently sending to the email related to the name selected in the dropdown menu. However, in the email that sends, I would like the name of the recipient to show up in the greeting. I.E. Dear "name from dropdown".

How do I go about doing this. My select box that holds the query for the name is as folows:

<?php 
echo '<select name="First_and_Last_Name">';
while( $array = mysql_fetch_assoc($result) ) {
    $text_for_select = $array["First_Name"] . " " . $array["Last_Name"]. " " . $array["District"];
$value_for_select = $array["Email"];
echo "<option></option>\n";
echo "<option value=\"$value_for_select\">$text_for_select</option>\n"; 
}
echo '</select>';?> 

No, this is querying the First and Last Name and another variable called district in to a new variable called "text_for_select". I just want to either print the "text_for_select" after the "Dear", or better yet, just the "First_Name" and "Last_Name".

How would I get this to print there?

Ok, I have one database three tables.

Table 1 is ncmr the main table where everything is to be entered.

Table 2 is companies, where all the companies in pull down menu 1 is located.

Table 3 is fabricators, where all the people who have had hands on the product are residing.

I want the selected choices of table 2 and 3 to be inputed into table 1. I know this has to be possible, but I don't know how.  I thought I wrote the code correctly, but it seems not.

Can someone review my code and show me where my mistake is?

Here is the page:

http://kaboomlabs.com/PDI/post2.php

Thanks.

Code: [Select]
    <?php
    
    require_once('connectvars.php');
     $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
     or die('Error connecting to MySQL server.');
    ?>
   
    <!DOCTYPE html
         PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
         "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
   
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>PDI Non-Conforming Materials Report</title>
    <link rel="stylesheet" type="text/css" href="CSS/postie.css" />
   
    </head>
   
    <body>
    <div id="logo">
    <img src="images/PDI_Logo_2.1.gif" alt="PDI Logo" />
    </div>
   
    <div id="title">
    <h3 id="NCMR2">Non-Conforming Materials Report (NCMR)</h3>
    </div>
    <?php
    //Post Data
     if (isset($_POST['submit'])) {
     $ab = mysqli_real_escape_string($dbc,$_POST['ab']);
     $date = mysqli_real_escape_string($dbc,date('Y-m-d',strtotime ($_POST['date'])));
     $part = mysqli_real_escape_string($dbc,$_POST['part']);
     $rev = mysqli_real_escape_string($dbc,$_POST['rev']);
     $partdesc = mysqli_real_escape_string($dbc,$_POST['partdesc']);
     $ncmrqty = mysqli_real_escape_string($dbc,$_POST['ncmrqty']);
     $comp = mysqli_real_escape_string($dbc,$_POST['comp']);
     $ncmrid = mysqli_real_escape_string($dbc,$_POST['ncmrid']);
     $rma = mysqli_real_escape_string($dbc,$_POST['rma']);
     $jno = mysqli_real_escape_string($dbc,$_POST['jno']);
     $fdt = mysqli_real_escape_string($dbc,$_POST['fdt']);
     $cof = mysqli_real_escape_string($dbc,$_POST['cof']);
     $fab1= mysqli_real_escape_string($dbc,$_POST['fab1']);
     $fab2= mysqli_real_escape_string($dbc,$_POST['fab2']);
     $fab3= mysqli_real_escape_string($dbc,$_POST['fab3']);
     $non= mysqli_real_escape_string($dbc,$_POST['non']);
     $dis= mysqli_real_escape_string($dbc,$_POST['dis']);
     $comm= mysqli_real_escape_string($dbc,$_POST['comm']);
     $caad= mysqli_real_escape_string($dbc,$_POST['caad']);
     $po= mysqli_real_escape_string($dbc,$_POST['po']);
     $pod = mysqli_real_escape_string($dbc,date('Y-m-d',strtotime($_POST['pod'])));
     $dri = mysqli_real_escape_string($dbc,date('Y-m-d',strtotime($_POST['dri'])));
    
     $output_form = 'no';
     if (empty($ab) || empty($date) || empty($part) || empty($partdesc)){
    
    // We know at least one of the input fields is blank 
    echo '<div id="alert">';
    echo 'Please fill out all of the required NCMR information.<br />';
     echo '</div>';
    
    }
     $output_form = 'yes';
    
    }
    
    //Access the Database
     if (!empty($ab) && !empty($date) && !empty($pod)) {
     $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
     or die('Error connecting to MySQL server.');
    
     $query = "INSERT INTO ncmr (ab, date, part, rev, partdesc, ncmrqty, comp, ncmrid, rma, jno, fdt, cof, fab1, fab2, fab3, non, dis, comm, caad, po, pod, dri)
    
     VALUES ('$ab','$date','$part','$rev','$partdesc','$ncmrqty','$comp','$ncmrid','$rma','$jno','$fdt','$cof','$fab1','$fab2','$fab3','$non','$dis','$comm','$caad','$po','$pod','$dri')";
    
     $data = mysqli_query($dbc, $query) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: $query");
    
    
          // Confirm success with the user
     echo '<tr><td class="thank">';
     echo '<p>Thank you for adding the NCRM, the correct person will be informed.</p>';
     echo '<p><a href="post.php">&lt;&lt; Back to the form</a></p>';
     $output_form = 'no';
     echo '</td></tr>';
    
     mysqli_close($dbc);
    }
      if ($output_form == 'yes') {
    echo "<form action='".$_SERVER['PHP_SELF']."' method='post'>";
     echo '<fieldset>';
     //Part, Rev, Part Description, NCMR Qty
     echo '<div id="box1">';
     echo '<div id="ab"><span class="b">Added By:&nbsp;&nbsp;</span><input type="text" name="ab" value="" /></div>';
     echo '<div id="date"><span class="b">Date Filed:&nbsp;&nbsp;</span><input type="text" name="date" value="" /></div>';
     echo '<div id="part"><span class="b">Part Number:&nbsp;&nbsp;</span><input type="text" name="part" value="" /></div>';
     echo '<div id="rev"><span class="b">Part Revision:&nbsp;&nbsp;</span><input type="text" name="rev" value="" /></div>';
     echo '<div id="partdesc"><span class="b">Part Description:&nbsp;&nbsp;</span><textarea name="partdesc" rows="3" cols="22" ></textarea></div>';
     echo '<div id="ncmrqty"><span class="b">NCMR Qty:&nbsp;&nbsp;</span><input type="text" name="ncmrqty" value="" /></div>';
     echo '</div>';
    
    
    //Company, Customer NCMR, Internal RMA, and Job Number
     echo '<div id="box2">';
     echo'<div id="comp">';
     echo '<span class="b">Company:&nbsp;&nbsp;</span>';
     $mysqli->select_db('comp');
     $result = $mysqli->query("SELECT * FROM comp"); 
     $i = 0;
     echo "<SELECT name='comp'>\n";
     while($row = $result->fetch_assoc()) {
     if ($i == 4) echo '<option value="lines">-----</option>';
     echo "<option value='{$row['user_id']}'>{$row['name']}</option>\n";
     $i++;
     }
     echo "</select>\n";
     echo '</div>';
    
     echo '<div id="ncmrid"><span class="b">Customer NCMR ID:&nbsp;&nbsp;</span><input type="text" name="ncmrid" value="" /></div>';
     echo '<div id="rma"><span class="b">Internal RMA #:&nbsp;&nbsp;</span><input type="text" name="rma" value="" /></div>';
     echo '<div id="jno"><span class="b">Job #:&nbsp;&nbsp;</span><input type="text" name="jno" value="" /></div>';
     echo '</div>';
    
    
    //Type of Failure and Class of Failure
     echo '<div id="box3">';
     echo '<h2>Failure</h2>';
     echo '<div id="fdt">';
     echo '<span class="b">Failure Due To:&nbsp;&nbsp;</span><br />';
     echo '<select name="fdt">';
     echo '<option value="none">----None----</option>';
     echo '<option value="In House">In House</option>';
     echo '<option value="Third Party">Third Party</option>';
     echo '</select>';
     echo '</div>';
    
     echo'<div id="cof">';
     echo '<span class="b">Class of Failu &nbsp;&nbsp;</span><br />';
     echo '<select name="cof">';
     echo '<option value="none">----None----</option>';
     echo '<option value="Materials">Materials</option>';
     echo '<option value="Fabrication">Fabrication</option>';
     echo '<option value="Drawing">Drawing</option>';
     echo '<option value="Assembly">Assembly</option>';
     echo '<option value="Testing">Testing</option>';
     echo '<option value="Electrical">Electrical</option>';
     echo '<option value="Programming">Programming</option>';
     echo '<option value="Machining">Machining</option>';
     echo '<option value="Inspection">Inspection</option>';
     echo '<option value="Purchasing">Purchasing</option>';
     echo '<option value="Administrator">Administrator</option>';
     echo '</select>';
     echo '</div>';
     echo '</div>';
    
     //Fabricators
     echo '<div id="box4">';
     echo '<h2>Fabricators</h2>';
     echo'<div id="fab1">';
     $mysqli->select_db('user');
     $result = $mysqli->query("SELECT * FROM user"); 
     echo "<SELECT name='fab1'>\n";
     while($row = $result->fetch_assoc()) { 
     echo "<option value='{$row['user_id']}'>{$row['user']}</option>\n";}
     echo "</select>\n";
     echo '</div>';
    
     echo'<div id="fab2">';
     $mysqli->select_db('user');
     $result = $mysqli->query("SELECT * FROM user"); 
     echo "<SELECT name='fab2'>\n";
     while($row = $result->fetch_assoc()) { 
     echo "<option value='{$row['user_id']}'>{$row['user']}</option>\n";}
     echo "</select>\n";
     echo '</div>';
    
     echo'<div id="fab3">';
     $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
     $mysqli->select_db('user');
     $result = $mysqli->query("SELECT * FROM user"); 
     echo "<SELECT name='fab3'>\n";
     while($row = $result->fetch_assoc()) { 
     echo "<option value='{$row['user_id']}'>{$row['user']}</option>\n";}
     echo "</select>\n";
     echo '</div>';
     echo '</div>';
    
      //Nonconformity, Disposition, Comments and Comments & Additional Details
                echo '<div id="box5">';
     echo '<div id="non"><span class="b">Nonconformity:&nbsp;&nbsp;</span><br /><textarea name="non" rows="3" cols="110" ></textarea><br /></div>';
     echo '<div id="dis"><span class="b">Disposition:&nbsp;&nbsp;</span><br /><textarea name="dis" rows="3" cols="110" ></textarea></div>';
     echo '<div id="comm"><span class="b">Comments:&nbsp;&nbsp;</span><br /><textarea name="comm" rows="3" cols="110" ></textarea></div>';
     echo '<div id="caad"><span class="b">Comments and/or Additional Details:&nbsp;&nbsp;</span><br /><textarea name="caad" rows="3" cols="110" ></textarea></div>';
     //PO, PO Date, and Date Recieved
                echo '<div id="podr">';
     echo '<div id="po"><span class="b">PO:&nbsp;&nbsp;</span><input type="text" name="po"  size="7" value="" /></div>';
     echo '<div id="pod"><span class="b">PO Date:&nbsp;&nbsp;</span><input type="text" name="pod"  size="7" value="" /></div>';
     echo '<div id="dri"><span class="b">Date Received:&nbsp;&nbsp;</span><input type="text" name="dri"  size="7" value=""';
     echo '</div>';
     echo '<div id="button"><input type="submit" value="Submit NCMR" name="submit" /></div>';
     echo '</div>';
     echo '</fieldset>';
    echo '</form>';
     }
    
    
    
    
    ?>
    </body>
    </html>

Hi, Currently I am making a module for joomla. every article has an publish date, if the article was published in 7 days ago, it will displayed as "article in last week", My idea is to use today's date - publish date, if the result is greater than 7 and smaller than 14, the article will be displayed as "article in last week.
Any one know how to write this code?
Here is what I have got, but not working.

<?php
$todays_date = date("Y-m-d"); 

$result = mysql_query("select * from jos_content where $test between $todays_date-14 and $todays_date-7");  
while($row = mysql_fetch_array($result))
  {
echo "$todays_date - $row[title]";
}
?>