[SOLVED] wont order by..

[jwk811]

$sql = "SELECT pd_id, c.cat_id, cat_name, pd_name, pd_thumbnail, pd_description
        FROM tbl_product p, tbl_category c
	WHERE p.cat_id = c.cat_id $sql2 AND user_id = '$userId'
	ORDER BY p.pd_date DESC";
$result     = dbQuery(getPagingQuery($sql, $rowsPerPage));
$pagingLink = getPagingLink($sql, $rowsPerPage, $queryString);

 

for some reason it wont order. is it bcuz im getting info from two tables? if so how can i make it work. or is it bcuz im making it into separate pages with the getpagingquery function?

[Mchl]

What is this getPagingLink() function?

[Ken2k7]

What type is the column p.pd_date?

[jwk811]

What is this getPagingLink() function?

function getPagingLink($sql, $itemPerPage = 10, $strGet = '')
{
$result        = dbQuery($sql);
$pagingLink    = '';
$totalResults  = dbNumRows($result);
$totalPages    = ceil($totalResults / $itemPerPage);

// how many link pages to show
$numLinks      = 10;


// create the paging links only if we have more than one page of results
if ($totalPages > 1) {

	$self = 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'] ;


	if (isset($_GET['page']) && (int)$_GET['page'] > 0) {
		$pageNumber = (int)$_GET['page'];
	} else {
		$pageNumber = 1;
	}

	// print 'previous' link only if we're not
	// on page one
	if ($pageNumber > 1) {
		$page = $pageNumber - 1;
		if ($page > 1) {
			$prev = " <a href=\"$self?page=$page&$strGet\">[Prev]</a> ";
		} else {
			$prev = " <a href=\"$self?$strGet\">[Prev]</a> ";
		}	

		$first = " <a href=\"$self?$strGet\">[First]</a> ";
	} else {
		$prev  = ''; // we're on page one, don't show 'previous' link
		$first = ''; // nor 'first page' link
	}

	// print 'next' link only if we're not
	// on the last page
	if ($pageNumber < $totalPages) {
		$page = $pageNumber + 1;
		$next = " <a href=\"$self?page=$page&$strGet\">[Next]</a> ";
		$last = " <a href=\"$self?page=$totalPages&$strGet\">[Last]</a> ";
	} else {
		$next = ''; // we're on the last page, don't show 'next' link
		$last = ''; // nor 'last page' link
	}

	$start = $pageNumber - ($pageNumber % $numLinks) + 1;
	$end   = $start + $numLinks - 1;		

	$end   = min($totalPages, $end);

	$pagingLink = array();
	for($page = $start; $page <= $end; $page++)	{
		if ($page == $pageNumber) {
			$pagingLink[] = " $page ";   // no need to create a link to current page
		} else {
			if ($page == 1) {
				$pagingLink[] = " <a href=\"$self?$strGet\">$page</a> ";
			} else {	
				$pagingLink[] = " <a href=\"$self?page=$page&$strGet\">$page</a> ";
			}	
		}

	}

	$pagingLink = implode(' | ', $pagingLink);

	// return the page navigation link
	$pagingLink = $first . $prev . $pagingLink . $next . $last;
}

return $pagingLink;
}

 

[jwk811]

What type is the column p.pd_date?

datetime and i also tried just pd_date that didnt work

[jwk811]

no one?

[PFMaBiSmAd]

for some reason it wont order

 

What is it doing? What do you see in front of you?

[jwk811]

its ordering by name

[jwk811]

still dunno

[Ken2k7]

Okay, can you run this for me -

$sql = "SELECT pd_id, c.cat_id, cat_name, pd_name, pd_thumbnail, pd_description
        FROM tbl_product p, tbl_category c
      WHERE p.cat_id = c.cat_id $sql2 AND user_id = '$userId'
      ORDER BY p.pd_date DESC";
var_dumpp($sql);
$result     = dbQuery(getPagingQuery($sql, $rowsPerPage));
$pagingLink = getPagingLink($sql, $rowsPerPage, $queryString);

[jwk811]

SORRY!!! im stupid. wrong file, hah wow thanks for your time guys