|    
			
				08/08/2007, 21:16
			
			
			  | 
  |   |  |  |  |  Fecha de Ingreso: marzo-2006 Ubicación: Aburrilandia, US 
						Mensajes: 652
					 Antigüedad: 19 años, 7 meses Puntos: 3 |  | 
  |  Re: ¿Cómo podria engañar al ORDER BY campo ASC?  
  Publico todo mi SELECT, la parte donde doy el ORDEN y la parte donde imprimo, a ver si ayuda a poner mas claras las cosas.  De antemano les agradezco la paciencia. 
el ORDER  
Código:
  if(!isset($HTTP_GET_VARS["SortCol"],$HTTP_GET_VARS["SortType"]))
{
	$SortCol = "c.price";
	$SortType = "ASC";
el SELEC  
Código:
  $sql = "SELECT 
			d.company,
			c.member_id,
			c.id,
			c.year,
			c.model,
			c.type,
			c.typemodel,
			c.trans,
			c.color,
			c.engine,
			c.drive,
			c.stock,
			c.millage,
			c.price,
			c.certified,
			c.comments,
			c.special,
			c.stored,
			IF(d.phone='','',CONCAT(SUBSTRING(d.phone,1,3),'-',SUBSTRING(d.phone,4,3),'-',SUBSTRING(d.phone,7,4))) AS dealer_phone, 			
                        d.zip,
			d.contact_name AS dealer_contact,
			st.state_code AS dealer_state,
			d.city,
			d.address AS dealer_address,
			d.website,
			CONCAT(d.contact_name) AS dealer_name,
			IF(TO_DAYS(NOW())-TO_DAYS(c.stored)<=7,'yes','no') AS is_new_car,
			d.featured AS dealer_featured,
			IF(rsr.id IS NULL,'no',rsr.id) AS results_stat_id
		FROM ".$db_prefix."cars AS c
		INNER JOIN ".$db_prefix."dealers AS d ON d.id=c.member_id
		LEFT JOIN ".$db_prefix."states AS st ON st.id = d.state_id
		LEFT JOIN ".$db_prefix."results_stat_report AS rsr ON (rsr.stock=c.stock AND rsr.member_id=c.member_id AND rsr.year = '".$stats_year."' AND rsr.month = '".$stats_month."')
		WHERE  
	    d.status='Active' AND
		(c.model LIKE '$model%' OR '$model'='')
		AND (c.price >= '$min_price' OR '$min_price'='')
	    AND (c.price <= '$max_price' OR '$max_price'='')
		".$filterType."
		".$filterKeyword."
		AND (d.city LIKE '%$city%' OR '$city'='')".
		//AND (d.zip LIKE '%$zip%' OR '$zip'='')
		$zipstring."
		AND (c.year >= '$min_year' OR '$min_year'='')
	    AND (c.year <= '$max_year' OR '$max_year'='')
		AND (c.member_id='$dealer_id' OR '$dealer_id'='')";
y donde imprimo el precio:    Código PHP:   
 <?php if(number_format($row["price"])!=0)
 {
 echo "$".number_format($row["price"]);
 }
 else
 {
 echo "<div style=\"width:50px; color:#666666; font-size:9px; font-weight:bold; font-family: Verdana, Arial, Helvetica, sans-serif\">CALL<br><img src=\"images/call.gif\"><br>PLEASE</div>";
 }
 ?>
 Perdona la ignorancia, k4k4, pero, a ke te refieres con ITERANDO?           
				__________________  ¿Dónde encontrar carros baratos en USA? En  Autopten .   Última edición por SI TAN SOLO TUVIERA; 08/08/2007 a las 21:34
     |