PHP - Get All Of The Today's Items From Mysql

Hi,

I have a table that contains posts and each post has a datetime field.

Im trying to work out how I can show entries from today, this week and this month so I can have a link that shows all posts from today or this month etc.

Any one know how I can do this ? My current piece of code that pulls the data from the db looks like this :

Code: [Select]
$texts= mysql_query("SELECT * FROM submittedtexts Order by id DESC LIMIT " . (($page - 1) * 6) . ", 6");
I want to add a bit that acts like : WHERE date = today


Hope that makes sense, Im a bit of a newbie

Thanks in advance,

Scott

This is probably some obvious error I have made, but I cannot figure it out. I have made a few pages and now I am debugging them. My first page is called insert_purchase_order.php; on this page a person will enter some data in fields and hit the insert button. Then, the data is passed to another page, but when I try to insert into mysql it does not give me any errors, but I have no new rows either. The code for my 2nd page:

Code: [Select]
<?php
session_start();
$action=$_GET[action];
if ($action==insert){

$randid=$_POST['randid'];
$vendor=$_POST["vendor"];
$purchase_order_date=$_POST["purchase_order_date"];
$ship=$_POST["ship"];
$fob=$_POST["fob"];
$terms=$_POST["terms"];
$buyer=$_POST["buyer"];
$freight=$_POST["freight"];
$req_date=$_POST["req_date"];
$confirming_to=$_POST["confirming_to"];
$remarks=$_POST["remarks"];
$tax=$_POST["tax"];


$con = mysql_connect("localhost","root","pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("main", $con);

mysql_query("INSERT INTO purchase_order (randid, vendor, purchase_order, ship, fob, terms, buyer, freight, req_date, confirming_to, remarks, tax)
VALUES ($randid, $vendor,$purchase_order_date,$ship, $fob, $terms, $buyer, $freight, $req_date, $confirming_to, $remarks, $tax)");

mysql_close($con);

echo 'Data Accepted...'; 
echo '<br/>';
echo 'P.O. Inserted Successfully';


}else{
echo 'Error... Please Contact Bruce.';
echo 'Bruce, no data was passed from the insert_purchase_order.php page.';
}


?>
<a href="http://localhost/insert_purchase_order_items.php?po= <?php echo $randid; ?>">Insert Purchase Order Items</a>
I have permissions and everything.

Thanks

I currently have a page where I have each row in my table listed using:

Code: [Select]
$getinfo="SELECT * FROM tablename WHERE Closed='n'";
$result=mysql_query($getinfo);
while ($row=mysql_fetch_array($result)){

... // list of user information

}

That successfully displays my content. What I am trying to do is have a checkbox next to each user (row) that when I check them and hit submit at the bottom, it will change the value of each row on the 'Closed' column to 'y' so it will not be displayed when the page is refreshed. I want to be able to select multiple items to "close". And I would like it to come back to this page. I think I can use this page as the form action and have the code above my while loop to change the Closed column so it then would not be displayed when the while loop is called... is that right?

How do I set this up? Not sure where to start the form tag and where to end it, and not sure how to...well...do any of it.

I've been playing around with this code from http://v3.thewatchmakerproject.com/journal/276/building-a-simple-php-shopping-cart

Objective: I'm trying to make the scripts work but without pulling the data from MySQL Database.
Instead, I created an array and inserted some info there and trying to replicate the same results but getting confused.

For example, on the Index.php file, I made the following changes:


<?php

// Start the session
session_start();

// Include functions
require_once('inc/functions.inc.php');

// Products multidimensional Array
$products = array("book" => array(  'id' => '1',
                                    'title' => 'Learn Your ABC\'s',
                                    'author' => 'John Doe',
                                    'price' => '14.95'),
                    "video" => array('id' => '2',
                                    'title' => 'Visual Guide to learn',
                                    'author' => 'Adam Smith',
                                    'price' => '21.38'),
                    "puzzle" => array('id' => '3',
                                    'title' => 'Can You Solve?',
                                    'author' => 'Sara Brown',
                                    'price' => '9.41'),
                    "exam" => array('id' => '4',
                                    'title' => 'Test Your Knowledge',
                                    'author' => 'Kim Carver',
                                    'price' => '11.15'));


?><!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" xml:lang="en" lang="en">
<head>
<title>PHP Shopping Cart Demo &#38;#0183; Bookshop</title>
<link rel="stylesheet" href="css/styles.css" />
</head>

<body>

<div id="shoppingcart">

<h1>Your Shopping Cart</h1>

<?php
echo writeShoppingCart();
?>

</div>

<div id="booklist">

<h1>Books In Our Store</h1>

<?php
/*
 $sql = 'SELECT * FROM books ORDER BY id';
 $result = $db->query($sql);
$output[] = '<ul>';
while ($row = $result->fetch()) {
$output[] = '<li>"'.$row['title'].'" by '.$row['author'].': $'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
}
$output[] = '</ul>';
echo join('',$output);
*/
?>

<?php
$output[] = '<ul>';
foreach ($products as $product => $product_item) {
// $flavor is the key and $piece is the value
foreach ($product_item as $item => $piece) {

    if ($item == "id") {                            # Conditional logic defined to map specific keys to specified name value
        $row['id'] = $piece;
//        echo "The id is ". $id."<br />";                            // set just to confirm value correct for variable
    }  elseif ($item == "title")  {                        # Conditional logic defined to map 1st key to price value
        $row['title'] = $piece;
//        echo "The title is ". $title."<br />";                            // set just to confirm value correct for variable
    }  elseif ($item == "author")  {                        # Conditional logic defined to map 1st key to price value
        $row['author'] = $piece;
//        echo "The author is ". $author."<br />";                            // set just to confirm value correct for variable
    }  elseif  ($item == "price")   {                    # Conditional logic defined to map 1st key to shipping value
        $row['price'] = $piece;
//        echo "Price: ". $price."<br /><br />";                        // set just to confirm value correct for variable
    }

$output[] = '<li>"'.$row['title'].'" by '.$row['author'].': $'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
$output[] = '</ul>';
echo join('',$output);

}
}

?>
</div>

</body>
</html>


And here's the original index.php before my edits which show the sql query to the db:


<?php
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions
require_once('inc/functions.inc.php');
// Start the session
session_start();
?><!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" xml:lang="en" lang="en">
<head>
<title>PHP Shopping Cart Demo &#38;#0183; Bookshop</title>
<link rel="stylesheet" href="css/styles.css" />
</head>

<body>

<div id="shoppingcart">

<h1>Your Shopping Cart</h1>

<?php
echo writeShoppingCart();
?>

</div>

<div id="booklist">

<h1>Books In Our Store</h1>

<?php
$sql = 'SELECT * FROM books ORDER BY id';
$result = $db->query($sql);
$output[] = '<ul>';
while ($row = $result->fetch()) {
$output[] = '<li>"'.$row['title'].'" by '.$row['author'].': &pound;'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
}
$output[] = '</ul>';
echo join('',$output);
?>

</div>

</body>
</html>


Also, I included the zipped file of the entire script setup.

Again, I'm trying to figure out how to make the cart work with using an array for the product instead of MySQL database.
My goal is to remove ALL SQL statements from the scripts but stuck with the looping portion to display the title, author, and price from the array as shown above.

I have a webpage where all the database items are displyes in a table format.The table also has a check box.Upon clicking the delete button i need to delete all the items whish has the checkbox checked.
How will i do that