order by date not ID number help php


Posted on 16th Feb 2014 07:03 pm by admin

I am trying to orginize the following code to order by date not id number.
any help would be great

Code: [Select]<?php
Did you know?Explore Trending and Topic pages for more stories like this.

// Status
// 1. inshop
// 2 in progress
// 3 pending
// 4 to be picked up
// 5 Done. Out of office.

$db = mysql_connect("x","x","x") or die("Couldn't connect");
mysql_select_db("x",$db) or die("Couldn't select database");
$query="SELECT * FROM `calls` WHERE `status` = '1' AND `priority` != 1";
$result=mysql_query($query);
$num=mysql_numrows($result);

print '<table width="100%" border="0">';
print "<tr><td><b>In Shop: $num
</b></td></tr>";
$i=0;
while ($n < $numa) {
$customer=mysql_result($result_customer,$n,"name");
$n++;
};
$id=mysql_result($result,$i,"id");
$date=mysql_result($result,$i,"date");
$time=mysql_result($result,$i,"time");
$customer=mysql_result($result,$i,"customer");
// $worksheetnum=mysql_result($result,$i,"worksheetnum");
// $worksheetnum =mysql_result($result2,$i,"($_POST['worksheetnum'])");
$worksheet=mysql_result($result,$i,"worksheet");
#Find customer name out of customer field
$query_customer="SELECT `name` FROM `customers` WHERE `id` = $customer";
$result_customer=mysql_query($query_customer);
$numa=mysql_numrows($result_customer);
$n=0;

while ($n < $numa) {
$customer=mysql_result($result_customer,$n,"name");
#end
//View Inshop

print '<FORM ACTION="GWS_online_lookup.php" method=post>';
print "<tr><td width=11%><input type="hidden" name="wo" value=$id><input type="submit" value="View"/>";
print "</td>";
print '<td align="left" width="29%">';
// print '<b><h3>';
print "$customer";
// print '</b></h3>';
print '</td><td width="24%">';
// print '<b><h3>';
print "$date";
// print '</b></h3>';
print '</td><td width="20%">';
// print '<b><h3>';
print "$time";
// print '</b></h3>';
print '<td width="16%">';
// print '<b><h3>';
print "WS $id";
// print '</b></h3>';
print '</td>';
print '</form>';
$n++;
};
// $i++;
// };
print "</table>";
$worksheetnum = trim(stripslashes($_POST['worksheetnum']));
$customerid = trim(stripslashes($_POST['customerid']));
$id = $_POST['wo'];
print $worksheetnum;
print "<input type="hidden" name="worksheetnum" value=$worksheetnum>";
print "<input type="hidden" name="customerid" value=$customerid>";
print "<input type="hidden" name="wo" value=$id>";

?>
No comments posted yet

Your Answer:

Login to answer
115 Like 9 Dislike
Previous forums Next forums
Other forums

Setting/Modify Headers using mail() function
I have a question about setting email headers when using mail() in a php script.

When I send

Extending Exception to contain method name
I was wondering, if there's a way to extend Exception in such a way, that it would contain name of a

Serial number of exernal hard disk/Thumbdrive
Hi guys, I am new tio java networking concepts.Please tel me how to get Serial number of exernal

PECL uploadprogress for php5.2
Hey, I just installed PHP5 via .htaccess on my 1and1 Shared Hosting Account.

How would I exac

Accessing element of object array
Hello

My object looks like this:


Array ( [0] => User Object ( [id] =>

Why is my row count 0?
Here's the MySQL query i'm running. It basically pulls data from 2 tables based on some data passed.

Read from a text file after a specific word
Hi all.

I have a text file that looks like the one below.
I know how to open the text fi

How to read CSS message data
Hi,
I have a requirement here. When working as a Dev angel for multiple customers its really di

How to change www in url with a specified name
Hi
I'm trying to change the url http://www.sitename.com/apparels to something like below
http:

HOW to get the bind variables list.
I've the following problem : I've some SQL queries stored in my DB as VARCHAR2 values.
I need t

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash