Ad:

PHP Discussion Thread
Unsolved
Views: 562

Apr 8th, 2009

order by not working with. help!

Expand Post »

Hello people, i have the following code though it is not giving me the exact results i want. i would like the code to order by the name but the order by doesnt seem to be executed. here is the code;

PHP Syntax (Toggle Plain Text)
$query2 = "select * from jos_categories where id = '".$row['cid']."' ORDER BY name ASC";
		$result2 = mysql_query($query2, $conn);
		$idrow = mysql_fetch_assoc($result2);
		$link = sefRelToAbs('index.php?option=' . $option . '&amp;task=view&amp;limit=0&amp;id=' .$idrow['id'] . '&amp;Itemid=' . $Itemid);
$query2 = "select * from jos_categories where id = '".$row['cid']."' ORDER BY name ASC";
		$result2 = mysql_query($query2, $conn);
		$idrow = mysql_fetch_assoc($result2);
		$link = sefRelToAbs('index.php?option=' . $option . '&amp;task=view&amp;limit=0&amp;id=' .$idrow['id'] . '&amp;Itemid=' . $Itemid);

thanx in advance for any help.

Last edited by swit; Apr 8th, 2009 at 11:42 am.

Similar Threads

.htaccess not working.! in Linux Servers and Apache
javascript onclick is not working in IE7 & IE6 in JavaScript / DHTML / AJAX
Shopping Cart Not Working in ASP.NET
Problems With Xp Boot Loader in Windows NT / 2000 / XP
about:blank hijacked, solutions offered not working in Viruses, Spyware and other Nasties

swit

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Feb 2009

Permalink

Apr 8th, 2009

Re: order by not working with. help!

What is your output then? Also there appears to be a mistake in your query. I presume ID is a number, then there is no need for single quotes. So...

PHP Syntax (Toggle Plain Text)

where id = '".$row['cid']."'

becomes

PHP Syntax (Toggle Plain Text)

where id = ".$row['cid']."

Last edited by brechtjah; Apr 8th, 2009 at 1:17 pm.

brechtjah

Reputation Points: 26

Solved Threads: 9

Junior Poster in Training

Offline

92 posts
since Nov 2008

Permalink

Apr 9th, 2009

Re: order by not working with. help!

Click to Expand / Collapse Quote originally posted by brechtjah ...

What is your output then? Also there appears to be a mistake in your query. I presume ID is a number, then there is no need for single quotes. So...
PHP Syntax (Toggle Plain Text)
where id = '".$row['cid']."'
where id = '".$row['cid']."'
becomes
PHP Syntax (Toggle Plain Text)
where id = ".$row['cid']."
where id = ".$row['cid']."

Thank you for your reply,
well, it appears that with or without the quotes, it works ok.
the output is it brings back a list of all the categories i want thou it doesnt order them by name in alphabetical order as i want them. it seems to be ignoring the order by statement.
Output is
• Secondary Schools
• Primary school
• Special Needs Institutions
• Vocational School
• Nursery school

please, any help will be appreciated.

swit

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Feb 2009

Permalink

Apr 9th, 2009

Re: order by not working with. help!

Click to Expand / Collapse Quote originally posted by swit ...

Hello people, i have the following code though it is not giving me the exact results i want. i would like the code to order by the name but the order by doesnt seem to be executed. here is the code;
PHP Syntax (Toggle Plain Text)
$query2 = "select * from jos_categories where id = '".$row['cid']."' ORDER BY name ASC";
		$result2 = mysql_query($query2, $conn);
 
		$link = sefRelToAbs('index.php?option=' . $option . '&amp;task=view&amp;limit=0&amp;id=' .$idrow['id'] . '&amp;Itemid=' . $Itemid);
$query2 = "select * from jos_categories where id = '".$row['cid']."' ORDER BY name ASC"; $result2 = mysql_query($query2, $conn); $link = sefRelToAbs('index.php?option=' . $option . '&task=view&limit=0&id=' .$idrow['id'] . '&Itemid=' . $Itemid);
thanx in advance for any help.

can you try these 2 options if there is a difference on the output.

PHP Syntax (Toggle Plain Text)
1. $idrow = mysql_fetch_array($result2, MYSQL_ASSOC);
 
or 
 
2. $idrow = mysql_fetch_array($result2);
1. $idrow = mysql_fetch_array($result2, MYSQL_ASSOC);

or 

2. $idrow = mysql_fetch_array($result2);

Last edited by rm_daniweb; Apr 9th, 2009 at 6:34 am.

rm_daniweb

Reputation Points: 13

Solved Threads: 12

Junior Poster

Offline

165 posts
since Jan 2007

Permalink

Apr 9th, 2009

Re: order by not working with. help!

Click to Expand / Collapse Quote originally posted by rm_daniweb ...

can you try these 2 options if there is a difference on the output.
PHP Syntax (Toggle Plain Text)
1. $idrow = mysql_fetch_array($result2, MYSQL_ASSOC);
 
or 
 
2. $idrow = mysql_fetch_array($result2);
1. $idrow = mysql_fetch_array($result2, MYSQL_ASSOC); or 2. $idrow = mysql_fetch_array($result2);

Thanx for your reply,
however i have tried the two options and non of them changes the out put. perhaps i should post some more code to make it clearer. i have a distinct just before the while statement. maybe it is what is messing things up. the code seems to order by the id instead and overlook the orderby name statement.

PHP Syntax (Toggle Plain Text)
$query = "select distinct cid from jos_artband";
	$result = mysql_query($query, $conn);
	$num = mysql_num_rows($result);
 
	while ($row=mysql_fetch_assoc($result))
	{
 
		$query2 = "select * from jos_categories where id = ".$row['cid']." ORDER BY name ASC";
		$result2 = mysql_query($query2, $conn);
		$idrow = mysql_fetch_array($result2, MYSQL_ASSOC);
		$link = sefRelToAbs('index.php?option=' . $option . '&amp;task=view&amp;limit=0&amp;id=' .$idrow['id'] . '&amp;Itemid=' . $Itemid);
 
 		if($idrow['name'] != "")
			{
				echo '<tr>';
				echo '<td align="center"><a href="' . $link . '">&bull;&nbsp;&nbsp;&nbsp;'.$idrow['name'] .'</a> </td>  
	 			</tr>';
	  		}
	}
	echo '</table>';
$query = "select distinct cid from jos_artband";
	$result = mysql_query($query, $conn);
	$num = mysql_num_rows($result);

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

		$query2 = "select * from jos_categories where id = ".$row['cid']." ORDER BY name ASC";
		$result2 = mysql_query($query2, $conn);
		$idrow = mysql_fetch_array($result2, MYSQL_ASSOC);
		$link = sefRelToAbs('index.php?option=' . $option . '&amp;task=view&amp;limit=0&amp;id=' .$idrow['id'] . '&amp;Itemid=' . $Itemid);
		
 		if($idrow['name'] != "")
			{
				echo '<tr>';
				echo '<td align="center"><a href="' . $link . '">&bull;&nbsp;&nbsp;&nbsp;'.$idrow['name'] .'</a> </td>  
	 			</tr>';
	  		}
	}
	echo '</table>';

Any help will be highly appreciated.

swit

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Feb 2009

Permalink

Apr 9th, 2009

Re: order by not working with. help!

like what you said....before the output are the ff:
Output is
• Secondary Schools
• Primary school
• Special Needs Institutions
• Vocational School
• Nursery school

is this a "NAME" column inside your database or "SCHOOL"? can you post your database structure.

Last edited by rm_daniweb; Apr 9th, 2009 at 11:13 pm.

rm_daniweb

Reputation Points: 13

Solved Threads: 12

Junior Poster

Offline

165 posts
since Jan 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: PHP to read XML and write into MySQL ?

Next Thread in PHP Forum Timeline: Input value submit to php

DaniWeb Message

Cancel Changes

User Name
Password