PHP - Echo Date Field From Mysql Table

Hi, when I submit a form I want to update a field in the "daterange" table.  In the form the id field (RID) from "daterange" is selected prior to submit.  Basically, I want to change the STATUS field to B (from A).

The structure of daterange table is as follows:

RID (key field)
DEND
MONTH
DATE
SITE
PRICE
STATUS

What is the easiest way to accomplish this?

Here is the code from the form (if it will help)...
Code: [Select]
<?php
//**************************************
//     Page load dropdown results     //
//**************************************
function getTierOne()
{
$result = mysql_query("SELECT DISTINCT MONTH FROM daterange") 
or die(mysql_error());

  while($tier = mysql_fetch_array( $result )) 
  
{
   echo '<option value="'.$tier['MONTH'].'">'.$tier['MONTH'].'</option>';
}

}

//**************************************
//     First selection results     //
//**************************************
if($_GET['func'] == "drop_1" && isset($_GET['func'])) { 
   drop_1($_GET['drop_var']); 
}

function drop_1($drop_var)
{  
    include_once('db.php');
$result = mysql_query("SELECT * FROM daterange WHERE DEND > DATE(NOW()) AND STATUS='A' AND MONTH='$drop_var' ORDER BY DATE, SITE")
or die(mysql_error());

echo '<select name="RID">
      <option value=" " disabled="disabled" selected="selected">Choose a Reservation</option>';

   while($drop_2 = mysql_fetch_array( $result )) 
 
{
 echo '<option value="'.$drop_2['RID'].'">'.$drop_2 ['DATE']. ', '.$drop_2 ['SITE']. ', '.$drop_2 ['PRICE'].'</option>';
}

echo '</select> ';

echo "<br />";

echo "</select><p align=left><label><font size=\"2\" face=\"Arial\">First Name: <input type=\"text\" name=\"FNAME\" size=\"50\" maxlength=\"50\" tabindex=\"1\"<br />";

echo "<p align=left><label>Last Name: <input type=\"text\" name=\"LNAME\" size=\"50\" maxlength=\"50\" tabindex=\"2\"<br />";

echo "<p align=left><label>Address Line 1: <input type=\"text\" name=\"ADDR1\" size=\"50\" maxlength=\"50\" tabindex=\"3\"<br />";

echo "<p align=left><label>Address Line 2: <input type=\"text\" name=\"ADDR2\" size=\"50\" maxlength=\"50\" tabindex=\"4\"<br />";

echo "<p align=left><label>City: <input type=\"text\" name=\"CITY\" size=\"50\" maxlength=\"50\" tabindex=\"5\"<br />";

echo "<p align=left><label>State (abbrev.): <input type=\"text\" name=\"STATE\" size=\"2\" maxlength=\"2\" tabindex=\"6\"<br />";

echo "<p align=left><label>Zip Code: <input type=\"text\" name=\"ZIP\" size=\"5\" maxlength=\"5\" tabindex=\"7\"<br />";

echo "<p align=left><label>Contact Phone Number: (<input type=\"text\" name=\"PHONE1\" size=\"3\" maxlength=\"3\" tabindex=\"8\"";
echo "<label>)<input type=\"text\" name=\"PHONE2\" size=\"3\" maxlength=\"3\" tabindex=\"9\"";
echo "<label>-<input type=\"text\" name=\"PHONE3\" size=\"4\" maxlength=\"4\" tabindex=\"10\"<br />";

echo "<p align=left><label>Email: <input type=\"text\" name=\"EMAIL\" size=\"50\" maxlength=\"50\" tabindex=\"11\"<br />";
echo '<input type="submit" name="submit" value="Book Now!" /><br />';
echo '<input type="reset" name="submit" value="Reset" /><br />';
}
?>

I'm trying to create a search form where members of a site can search other members whose user information is stored in a mysql database.  One of the search parameters is gender which searches for records from a column in the database called gender where members can either have the value "man" or "woman".  The user can choose between 3 options from a pull down menu named gender (man, woman, both).  Then I'm thinking about using a select query to search the database upon submission of the form, which goes something like this:
Code: [Select]

$sql= SELECT* FROM members WHERE gender ='{$_POST['gender']}' ;

Now I can easily assign the value "man" for the option man in the pull down menu and "woman for the option woman, to match their corresponding names in the database.  The problem lies with the "both" option which has to be either man or woman.  I'm thinking about assigning it the value "man OR woman" so that when the form is submitted, the query would read: SELECT*FROM members WHERE gender ='{$_POST[man OR woman']};
I just don't know if this would be a right usage of the OR keyword and if such a query would work.  Before trying it out, I'd like to know if this makes any sense and if not, what's an alternative way to work around this?

Hi,

I'm trying to get a number of different keywords from many table fields, and i want to count them according to the occurrence of each keyword, so it should be like (keyword1 occurred 10 times for example ).

the problem is when i use count in for loop:
 
Code: [Select]

      $tags = explode("|", $row[0]);
     $i=1;
$count = 0;
for($i; $i<count($tags); $i++){
    print "$count {$tags[$i]}<br />";
    $count++;
}
   
it counts the occurrence of key words in each field separately from the rest (i.e.

Code: [Select]
0 day
1 night

0sun
1 moon

0 clouds
1 rain

)

2 keywords in each field (some other fields got more).

I want the count to be more like:
Code: [Select]
1 day
2 night

3 sun
4 moon

5 clouds
6 rain

thanks

Hi all -

I am parsing info from mysql into a php table but the date being returned is in YYYY-MM-DD format and I want it DD-MM-YYYY. How would I do this?

Code at the moment is:

Code: [Select]
$link = connect();

function get_user_posts(){

$getPosts = mysql_query('SELECT a.id as id,a.post as question, a.answer as answer, a.created as created, a.updated as updated, b.vclogin as admin
FROM user_posts as a, admin as b WHERE a.admin_id=b.adminid',connect());
return $getPosts;
}


Code: [Select]
<table class="list">
<tr>
<th><?php echo getlocal("upost.post") ?></th>
<th><?php echo getlocal("upost.answer") ?></th>
<th><?php echo getlocal("upost.admin") ?></th>
<th><?php echo getlocal("upost.created") ?></th>
<th><?php echo getlocal("upost.updated") ?></th>
<th></th>
<th></th>
</tr>
<?php 
$all_questions = get_user_posts();

while ($question = mysql_fetch_assoc($all_posts)):
?>

<tr>
<td><?php echo $post['post']?></td>
<td><?php echo $post['answer']?></td>
<td><?php echo $post['admin']?></td>
<td><?php echo $post['created']?></td>
<td><?php echo $post['updated']?></td>
<td><a href="javascript:user_post('<?php echo $post['id']?>')">edit</a></td>
<td><a href="javascript:delete_post('<?php echo $post['id']?>')">delete</a></td>
</tr>


THANKS!

I want to loop through a MySQL table, and perform a calculation based on the current row the loop is on and the previous loop.

Say my table has 2 columns - Film_id and FilmRelease, how would I loop through and echo out a calculation of the current FilmRelease and the previous row's column value?

Thanks guys

I have got to this stage, but for some reason it's not printing out anything

Code: [Select]
<?php
 mysql_connect("localhost", "****", "*****") or die(mysql_error()); 
 mysql_select_db("*****") or die(mysql_error()); 

 $sql = mysql_query("SELECT FilmRelease FROM Films_Info") 
 or die(mysql_error()); 

 $last_value = null;

while ($row = mysql_fetch_assoc($sql)) {

  if (!is_null($last_value)) {

    print date_diff($row['FilmRelease'], $last_value) . "<BR>";
  }

  $last_value = $row['FilmRelease'];
}

I am looking for a way to have my 'start_date', echo ('start_date' + 1 month).  I am looking at the line that reads .... date("F Y",strtotime($row['start_date'])).  Does anyone have a suggestion.  The date format read, July 2014 or alphabetical full month, numerical full year.  Thank you in advance.

    <?php

$query = sqlsrv_query($conn, $sql);if ($query === false){  exit("<pre>".print_r(sqlsrv_errors(), true));}while ($row = sqlsrv_fetch_array($query)){  echo "<tr>
    <td><a href='view_invoice.php?meter_id=$meter_id&subaccount=$subaccount&start_date=$row[start_date]'>$row[meter_id]</a></td>
    <td>" . date("F Y",strtotime($row['start_date']))  . "<td>$row[invoice_no]</td><td>" . date_format($row['invoice_date'],'Y-m-d') . "<td>$row[amount_paid]</td>" . "<td>$row[payment_date]</td>" . "<td>$row[check_number]</td>" 
  ;}sqlsrv_free_stmt($query);
  ?>

Edited by Butterbean, 11 January 2015 - 08:19 PM.

Hi:
I'm going crazy trying to do the following:
I'm making a job registration process where the user registers on one php page to the website, must acknowlege and email receipt using an activate php page, then is directed to upload their C.V. (resume) based on the email address they enter in the active page output. I then run an upload page to store the resume in teh MySQL db based on the users email address in the same record.

If I isolate the process of the user registering to the db, it works perfectly.
If I isolate the file upload process into the db, it works perfect.
I simply cannot upload teh file to the existing record based on teh email form field matching the user_email field in the db.
With the processes together, teh user is activated, but teh file is not uploaded.

Maybe I've simply been at this too long today, but am compeled to get through it by end day.
If anyone can help sugest a better way or help me fix this, I will soo greatly appreciate it.

My code is as follows for the 2 pages.

---------activate.php-------
<?php
session_start();
include ('reg_dbc.php');
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
$rsCode = mysql_query("SELECT activation_code from subscribers where user_email='$_GET[usr]'") or die(mysql_error());
list($acode) = mysql_fetch_array($rsCode);
if ($_GET['code'] == $acode)
{
mysql_query("update subscribers set user_activated=1 where user_email='$_GET[usr]'") or die(mysql_error());
echo "<h3><center>Thank You! This is step 2 of 3. </h3>Your email is confirmed. Please upload your C.V. now to complete step 3.</center>";
} else
{ echo "ERROR: Incorrect activation code... not valid"; }

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Job application activation</title>
</head>
<body>
<center>
<br/><br/><br/>
<p align="center">
        <form name="form1" method="post" action="upload.php" style="padding:5px;">
        <p>Re-enter you Email : <input name="email" type="text" id="email"/></p></form>
          <form enctype="multipart/form-data" action="upload.php" method="POST">
          <input type="hidden" name="MAX_FILE_SIZE" value="4000000">
          Upload your C.V.: <input name="userfile" type="file" id="userfile">
          <input name="upload" type="submit" id="upload" value="Upload your C.V."/></form>
</p>
</center>
</body>

</html>
--------upload.php----------
<?php
session_start();
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$email = $_POST['email']['user_email'];

$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
    $fileName = addslashes($fileName);
}

include 'reg_dbc.php';

$query = "UPDATE subscribers WHERE $email = user_email (name, size, type, content ) ". "VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

mysql_query($query) or die('Error, query failed');
mysql_close($dbname);
}
?>
<center>
<br/>
<br/>
<br/>
<br/>
Thank you for uploading your <?php echo "$fileName"; ?> file, completing your registration, and providing us your C.V. for this position.
<br/>
<br/>
<br/>
We will contact you if your canditature qualifies.
</center>

Sorry for the topic title not explaining much, but I did not now how to word it!

I was previous given some code at http://www.phpfreaks.com/forums/php-coding-help/streamlining-dreamweaver-generated-php-code/msg1459677/#msg1459677 that created a header every time a crtieria changed, in this case a players position.

I have tried to tailor this to another page but have got it wrong somewhere. In this instance I was a change of date to be the determining factor. For example, with what I have tried so far, the output is
2011-04-02
Lowestoft Town v Tonbridge Angels

2011-04-02
Tooting & Mitcham United v Maidstone United

2011-04-02
Wealdstone v Concord Rangers

2011-04-09
Hastings United v Margate

2011-04-09
AFC Hornchurch v Carshalton Athletic

2011-04-09
Billericay Town v Aveley

when I actually want

2011-04-02
Lowestoft Town v Tonbridge Angels
Tooting & Mitcham United v Maidstone United
Wealdstone v Concord Rangers

2011-04-09
AFC Hornchurch v Carshalton Athletic
Billericay Town v Aveley

I have tried to adjust the code to reflect the different query etc but something is missing.

Thinking further ahead, there will also be a second criteria, in that games in different competitions could be played on the same day so I would also want to group the output by the competition ('comp' in the table) to get

2011-04-02
League
Lowestoft Town v Tonbridge Angels
Tooting & Mitcham United v Maidstone United
Cup
Wealdstone v Concord Rangers

2011-04-09
League
AFC Hornchurch v Carshalton Athletic
Cup
Billericay Town v Aveley

I would imagine that would just mean drilling down one more level in the code once I get this bit right.

The tables, with a sample of data are
Code: [Select]
CREATE TABLE `all_games` (
  `all_games_id` int(11) NOT NULL auto_increment,
  `date` date default NULL,
  `time` time default NULL,
  `comp` int(11) NOT NULL default '1',
  `round` tinyint(4) default NULL,
  `replay` char(1) default NULL,
  `home_team` int(11) NOT NULL default '1',
  `away_team` int(11) NOT NULL default '1',
  `home_goals` int(11) default NULL,
  `away_goals` int(11) default NULL,
  `home_ht` int(11) default NULL,
  `away_ht` int(11) default NULL,
  `attendance` int(11) default NULL,
  PRIMARY KEY  (`all_games_id`)
) TYPE=MyISAM AUTO_INCREMENT=732 ;


INSERT INTO `all_games` VALUES (700, '2011-04-23', '00:00:00', 1, NULL, '', 11, 20, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (701, '2011-04-23', '00:00:00', 1, NULL, '', 12, 13, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (702, '2011-04-23', '00:00:00', 1, NULL, '', 15, 22, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (703, '2011-04-23', '00:00:00', 1, NULL, '', 21, 7, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (704, '2011-04-25', '00:00:00', 1, NULL, '', 1, 14, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (705, '2011-04-25', '00:00:00', 1, NULL, '', 4, 6, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (706, '2011-04-25', '00:00:00', 1, NULL, '', 8, 15, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (707, '2011-04-25', '00:00:00', 1, NULL, '', 13, 2, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (708, '2011-04-25', '00:00:00', 1, NULL, '', 16, 21, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (709, '2011-04-25', '00:00:00', 1, NULL, '', 17, 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (710, '2011-04-25', '00:00:00', 1, NULL, '', 18, 9, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (711, '2011-04-25', '00:00:00', 1, NULL, '', 19, 5, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (712, '2011-04-25', '00:00:00', 1, NULL, '', 20, 12, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (713, '2011-04-25', '00:00:00', 1, NULL, '', 22, 11, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (714, '2011-04-30', '00:00:00', 1, NULL, '', 14, 18, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (715, '2011-04-30', '00:00:00', 1, NULL, '', 2, 19, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (716, '2011-04-30', '00:00:00', 1, NULL, '', 3, 22, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (717, '2011-04-30', '00:00:00', 1, NULL, '', 5, 13, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (718, '2011-04-30', '00:00:00', 1, NULL, '', 6, 8, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (719, '2011-04-30', '00:00:00', 1, NULL, '', 9, 17, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (720, '2011-04-30', '00:00:00', 1, NULL, '', 11, 7, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (721, '2011-04-30', '00:00:00', 1, NULL, '', 12, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (722, '2011-04-30', '00:00:00', 1, NULL, '', 15, 20, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `all_games` VALUES (723, '2011-04-30', '00:00:00', 1, NULL, '', 21, 4, NULL, NULL, NULL, NULL, NULL);



CREATE TABLE `competitions` (
  `comp_id` int(11) NOT NULL auto_increment,
  `comp_name` varchar(45) default NULL,
  `comp_short_name` varchar(4) default NULL,
  `logo` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`comp_id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;


INSERT INTO `competitions` VALUES (1, 'Isthmian League Premier Division', 'ILP', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/tRymanLeague.png');
INSERT INTO `competitions` VALUES (2, 'FA Cup', 'FAC', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/facup.png');
INSERT INTO `competitions` VALUES (3, 'FA Trophy', 'FAT', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/fattophy.png');
INSERT INTO `competitions` VALUES (4, 'Kent Senior Cup', 'KSC', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/kentseniorcup.png');
INSERT INTO `competitions` VALUES (5, 'Isthmian League Cup', 'ILC', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/isthmianleaguecup.png');
INSERT INTO `competitions` VALUES (6, 'Friendly', 'FR', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/friendly.png');
INSERT INTO `competitions` VALUES (7, 'Kent Messenger Cup', 'KMC', '');



CREATE TABLE `teams` (
  `team_id` int(11) NOT NULL auto_increment,
  `team_name` varchar(45) default NULL,
  `short_name` varchar(5) default NULL,
  `badge` varchar(255) default NULL,
  `year_formed` int(11) default NULL,
  `nickname` varchar(255) default NULL,
  `previous_names` varchar(255) default NULL,
  `website` varchar(255) default NULL,
  `twitter` varchar(255) default NULL,
  `facebook` varchar(255) default NULL,
  `telephone_number` varchar(255) default NULL,
  `chairman` varchar(255) default NULL,
  `manager` varchar(255) default NULL,
  `home_colours` varchar(255) default NULL,
  `away_colours` varchar(255) default NULL,
  `stadium` int(11) default NULL,
  `2009/10` varchar(255) default NULL,
  PRIMARY KEY  (`team_id`)
) TYPE=MyISAM AUTO_INCREMENT=74 ;


INSERT INTO `teams` VALUES (1, 'Aveley', 'Ave', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/aveley.png', 1927, 'The Millers', 'None', 'http://www.aveleyfc.net/', NULL, NULL, '01708865940', 'Graham Gennings', 'Alan Kimble', 'Black & Blue/Blue/Blue', 'Black & White/White/White', 3, 'Isthmian League Premier Division, 3rd');
INSERT INTO `teams` VALUES (2, 'Billericay Town', 'Bill', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/billericaytown.png', 1880, 'Ricay, The Blues', 'None', 'http://www.billericaytownfc.co.uk/', 'http://twitter.com/BTFC', 'http://www.facebook.com/billericaytownfc', '01277652188', 'Steve Kent', 'Craig Edwards', 'Blue/White/Blue', 'White/Black/White', 2, 'Isthmian Premier, 13th');
INSERT INTO `teams` VALUES (3, 'Bury Town', 'Bur', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/burytown.png', 1872, 'The Blues', 'Bury St Edmunds, Bury United', 'http://www.burytownfc.co.uk', NULL, NULL, '01277999999', 'Russell Ward', 'Richard Wilkins', 'Blue & Red/Blue/Blue', 'White/Black/White', 10, 'Southern League Division One Midlands, 1st');
INSERT INTO `teams` VALUES (4, 'Canvey Island', 'Can', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/canveyisland.png', 1926, 'The Gulls', 'None', 'http://www.canveyislandfc.com', 'http://twitter.com/CIFC', NULL, NULL, 'George Frost', 'John Batch', 'Yellow/Blue/White', 'White/White/White', 11, 'Isthmian League Premier Division, 16th');
INSERT INTO `teams` VALUES (5, 'Carshalton Athletic', 'Car', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/carshaltonathletic.png', 1905, 'The Robins', 'Mill Lane Misson', 'http://www.carshaltonathletic.co.uk/', 'http://twitter.com/carshaltonath', NULL, '02086428658', 'Harry Driver', 'Mark Butler', 'Red/Red/Red', 'Maroon/White/Maroon', 9, 'Isthmian League Premier Division, 17th');
INSERT INTO `teams` VALUES (6, 'Concord Rangers', 'Con', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/concordrangers.png', 1967, 'Beach Boys', 'None', 'http://www.concordrangers.co.uk/', 'http://twitter.com/ConcordRangers', NULL, '01268691780', 'Antony Smith', 'Danny Scopes / Danny Cowley', 'Yellow/Blue/Blue', 'TBA', 12, NULL);
INSERT INTO `teams` VALUES (7, 'Cray Wanderers', 'Cray', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/craywanderers.png', 1860, 'The Wands', 'None', 'http://www.craywands.co.uk', 'http://twitter.com/craywanderers', NULL, '02084605291', 'Gary Hillman', 'Ian Jenkins', 'Amber/Black/Amber', 'Blue/White/White', 13, 'Isthmian League Premier Division, 15th');
INSERT INTO `teams` VALUES (8, 'Croydon Athletic', 'Croy', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/croydonathletic.png', 1986, 'The Rams', 'Wandsworth & Norwood', 'http://croydonathletic.net', NULL, NULL, '0208664834', 'TBA', 'Dave Garland & Bob Langford', 'Maroon & White/Maroon/Maroon', 'Yellow/Blue/Blue', 14, 'Isthmian League Division One South, 1st');
INSERT INTO `teams` VALUES (9, 'Folkestone Invicta', 'Fol', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/folkestoneinvicta.png', 1936, 'Invicta, The Seasiders', 'None', 'http://www.folkestoneinvicta.co.uk/', 'http://twitter.com/FIFC', NULL, '01303257461', 'TBA', 'Neil Cugley', 'Amber/Black/Amber', 'Red/White/Red', 15, 'Isthmian League Division One South, 2nd');
INSERT INTO `teams` VALUES (10, 'Grays Athletic', 'Gra', 'N/A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `teams` VALUES (11, 'Harrow Borough', 'Har', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/harrowborough.png', 1933, 'The Boro, The Reds', 'Roxoinian, Harrow Town', 'http://www.harrowboro.com/', 'http://twitter.com/harrowboro_fc', NULL, '08706091959', 'Peter Rogers', 'David Howell', 'Red/Red/Red', 'White/White/Black', 16, 'Isthmian League Premier Division, 14th');
INSERT INTO `teams` VALUES (12, 'Hastings United', 'Has', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/hastingsunited.png', 1894, 'The Arrows, The U''s', 'Hastings Town, Hastings & St. Leonards', 'http://www.hastingsunitedfc.co.uk/', 'http://twitter.com/hastingsufc', NULL, '01424444635', 'David Walter', 'Tony Dolby', 'Maroon/Maroon/Maroon', 'White/White/White', 17, 'Isthmian League Premier Division, 7th');
INSERT INTO `teams` VALUES (13, 'Hendon', 'Hen', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/hendon.png', 1908, 'The Greens, The Dons', 'Christ Church Hampstead, Hampstead Town, Hampstead, Golders Green', 'http://www.hendonfc.net/', 'http://twitter.com/HendonFC', NULL, '02089083553', 'TBA', 'Gary McCann', 'Green/Green/Green', 'Blue/Blue/Blue', 18, 'Isthmian League Premier Division, 10th');
INSERT INTO `teams` VALUES (14, 'AFC Hornchurch', 'AFC', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/afchornchurch.png', 1923, 'The Urchins', 'Upminster Wanderers, Hornchurch & Upminster', 'http://www.afchornchurch.com/', 'http://twitter.com/AFCHornchurch', 'http://www.facebook.com/AFCHornchurch', '01708220080', 'TBA', 'Colin McBride', 'Red & White/Black/Red', 'Blue & White/Blue/Blue', 1, 'Isthmian League Premier Division, 9th');
INSERT INTO `teams` VALUES (15, 'Horsham', 'Hor', 'http://www.margate-fc.com/edit/news/data/upimages/images/Badges/horsham.png', 1871, 'The Hornets', 'None', 'http://www.hornetsreview.co.uk/', NULL, NULL, '01403266888', 'Kevin Borrett', 'John Maggs', 'Yellow & Green/Yellow/Yellow', 'Blue/Black/White', 19, 'Isthmian League Premier Division,11th');
The query is
$all_games = mysql_query("SELECT *, HT.team_name as HomeTeam, VT.team_name as AwayTeam, COMP.comp_short_name as CP
FROM all_games
JOIN teams as HT ON all_games.home_team = HT.team_id
JOIN teams as VT ON all_games.away_team = VT.team_id 
JOIN competitions as COMP ON all_games.comp = COMP.comp_id  ORDER BY date ASC 
");
if (!$all_games) {
    die("Query to show fields from table failed");
And the code that echoes the right values, but does not seperate the the dates is
if($all_games)
{
 if(mysql_num_rows($all_games)) 
 {
    $lastdate = 0;
    while ($row_all_games = mysql_fetch_assoc($all_games))
{

// when the date changes output a new heading
            if($lastdate = $row_all_games['date'])
            {
                echo "<h1>".strtoupper($row_all_games['date'])."</h1>";
                $lastdate = $row_all_games['date'];
               
            }
    echo $row_all_games['HomeTeam']." v ".$row_all_games['AwayTeam'];
        }
    }

  else
    {
        echo "No results!";
    }
}

I must admit that I have tried a few variations but the nearest I have got is for the page to echo "No results!"

I may be a fraction off getting it right or a million miles away so if anyone can give any pointers I will be very grateful.

Thanks in advance
Steve

i hav dis checkstatus.php page where the user enters a random number sms to him..but after tht he shud be able to see d reply given by admin ..d problem over here is d user only views half of the field called 'anything'
(my database is named "proj")
heres my code
jst cant understand why dis is happening...pls help

I have tried a large number of "solutions" to  this but everytime I use them I see 0000-00-00 in my date field instead of  the date even though I echoed and can see that the date looks correct.

Here's where I'm at:
I have a drop down for the month (1-12) and date fields (1-31) as well as a text input field for the year.  Using the POST array, I  have combined them into the xxxx-xx-xx format that I am using in my field as a date field in mysql. 

<code>
$date_value =$_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];
echo $date_value;
</code>

This outputs 2012-5-7 in my test echo but 0000-00-00 in the database.

I have tried unsuccessfully to use in a numberof suggested versions of:
strtotime()
mktime

Any help would be extremely appreciated.
I am aware that I need to validate this data and insure  that it is a valid date. That I'm okay with. I would like some help on getting it into the database.

What I'm basically trying to accomplish is, that the datetime of the user posted information is registered with the Now() function in the query, BUT that the user entered information gets echo'd out with the Date showing ONLY.

What I have is this:
-Just as an example-

INSERT INTO db (date_created) VALUES (now())

 while ($row = mysqli_fetch_array($data)) {

echo '<tr><td>' . $row['date_created'] . '</td></tr>';

}
mysqli_close($dbc);

With this way of course I get Date and Time showcased just like it's inserted into the DB.

What would be a legit way of showcasing just date.

Thanks for help.

EDIT: or is there a better way than using now() to showcase the date when the user entered information was posted?

Hello fellow php friends, Im having abit of trouble trying to echo out a statement at certain times of the day.
for example
how would you echo out 'Good Morning' between the times of 01am to 11.59am
then echo out 'Good afternoon' between times of 12pm and 6pm and so on.

Please  help!!!!!

Hi,
I'm developing an app using flash AS2 as the front end via PHP and a mySQL database at the backend on my server.

what i'm looking to do is update/insert into a table called 'cards' and at the same time update/insert into another table called 'jingle'. There is a field called 'cardID' in jingle that should be the same as the ID number created in 'cards' thus creating a link between entries in the different tables that can be called up as i choose.

hope i've been clear i just wouldn't know where to start any help would be appreciated.

MySQL client version: 5.0.91
PHPmyAdmin Version information: 3.2.4


thanks in advance

Hello,

I want to display a weekly events day and time. This event will always be on Saturday @ 10:45 am however, I want to output:
2011-09-17 10:45
then when that date is passed - I want it to change to the next Saturday:
2011-09-21 10:45
etc.

Any ideas?

Hi there,

I have a string '12/04/1990', that's in the format dd/mm/yyyy.

I'm attempting to convert that string to a Date, and then insert that date into a MySQL DATE field.

The problem is, every time I try to do so, I keep getting values like this in the database: 1970-01-01.


Any ideas?


Much appreciated.