Articles Tagged with order-by

Hi all I have an Access database Table and one of the columns has a date value the column name is closing. I would like to do an order by closing asc the null values are allways on top and I would like it to be at the bottom. I …

I have a LINQ function to get 3 things :: Line, Average of Duration and Count I have a problem to sort it based on Average Of Duration column. Here is my code: Dim group2 As IEnumerable(Of DataRow) = _ From row In Ds.Tables(0).AsEnumerable() _ Group row By LINENAME = …

I have the following codes.. echo "<form><center><input type=submit name=subs value='Submit'></center></form>"; $val=$_POST['resulta']; //this is from a textarea name='resulta' if (isset($_POST['subs'])) //from submit name='subs' { $aa=mysql_query("select max(reservno) as 'maxr' from reservation") or die(mysql_error()); //select maximum reservno $bb=mysql_fetch_array($aa); $cc=$bb['maxr']; $lines = explode("\n", $val); foreach ($lines as $line) { mysql_query("insert into location_list (reservno, location) …

Hi , I have an xml which is in the following format. <root> <x> <y> <uri>ssomeuri</uri> <date>2012-07-11T10:29:08+00:00</uri> </y> </x> <x> <y> <uri>ssomeuri2</uri> <date>2012-07-11T11:01:08+00:00</uri> </y> </x> </root> I wanted to get uris in the order of date. I am very new to xpath, can any body help me on this. the …

Hi, I have a bit of a strange problem where I am unable to "echo" results from a database - I will show you the code then explaine what im trying to do [code] <?php include_once "connect_to_mysql.php"; $sql = mysql_query("SELECT * FROM table ORDER BY RAND(), LIMIT 1"); while($row = …