Search the Community

I have a Mysql table where I store prices of a product. I have the values in "varchar" format because I needed to include "decimals" in the prices(for eg. 15.30) and "int" doesn't allow that. Having done that, when ever I filter the products by prices in Ascending or Descending order, they don't show up in proper order. It seems like the decimal in the prices is messing up the order. Is there a way to fix this so that the php query can filter the prices in proper order despite the decimals? Here's the eg of the query. $get_records = $db->prepare("SELECT * FROM records ORDER BY records.price DESC");

Hello! My name is Razvan and I work as a (front-end) web developer in Bucharest, Romania. I am using the Simple Staff List Word Press plugin on THIS page. I have used the guidance here to sort staff members by full name. I need to order them by last name. For this, even though I am new to PHP, I have written the code below: <?php $name = "Firstname Middlename Lastname"; $name_parts = explode(' ',$name); $no_of_parts = sizeof($name_parts); $last_name_index = $no_of_parts - 1; $last_name = $name_parts[$last_name_index]; $first_names = chop($name,$last_name); $reverse_name = $last_name . ' ' . $first_names; ?> It is made to move the last name at the beginning of the full name, store the result in the $reverse_name, and then sort by $reverse_name. It does move the last name at the beginning of the full name, but I can't do this 2 things: 1) Use the value of the staff member post title as value for the $name variable; 2) Use $reverse_name for sorting. Can anyone give me a hint on what to change in the plugin files to achieve this goal, please? Thank you! Razvan Zamfir

Hi first tyvm for reading my help request me and my friend ar trying to build a order form (see png file ^^) so the main idea is some on go to order form.php in that order form they fil in thear info like name, adress you know ^^ thean here is the treaky part at the and of the form they kan add products to there order by selecting it or search it from the drop down list the items in the dropdown list come from msql the client can add more or delete items by clicking - or + whean the clint click send the client need to get a mail whit there a list of what theay have orderd and there unic order number wel so far we can do that but we wont to send another list to the company of order where the added products in the order ar sorted out based on the product id number this is what we have so far http://clientconstruction.publishvision.nl/valeri/ tyvm again voor anyone who read this ^^

Hi all, I have a strange problem. I am using the MySQL query SELECT * FROM crh_log WHERE logdetix=$detix ORDER BY logix ASC I have this exact query in two scripts, each gives a different result. logix is the primary key to the table. There are two rows that satisfy this query. One script returns the rows on ascending order of logix, the other is the reverse. I've tried ORDER BY different variables and in one script it never makes a difference - it's as if MySQL is ignoring the ORDER by clause. The MySQL code in the code snippets in attached file are identical. The only difference is that logix is displayed in the able in one script and not in the other.

Hello guys. I execute a query and then put the records into array, the query has ORDER BY .... why I don't have the same order in the array?, If I execute the query, the record one it's no the same that $arreglo[0]. $stmt = $this->db->prepare('SELECT a.id_torneo, b.tor_nombre, a.id_jornada, a.id_juego, a.cal_fecha_hora, id_arbitro, a.cal_estatus, a.cal_default, c.id_equipo, d.equ_nombre, c.enc_locvis, e.id_jugador, e.jug_nombre_pila, e.jug_apellido_pat, e.jug_apellido_mat, e.jug_representante, e.jug_numero, jug_fechimp_reg FROM calendario a, torneo b, encuentro c, equipo d, jugador e WHERE a.id_cliente =? AND a.id_sucursal = ? AND date(a. cal_fecha_hora)= date(?) AND a.id_cliente = b.id_cliente AND a.id_sucursal = b.id_sucursal AND a.id_torneo = b.id_torneo AND a.id_cliente = c.id_cliente AND a.id_sucursal = c.id_sucursal AND a.id_torneo = c.id_torneo AND a.id_jornada = c.id_jornada AND a.id_juego = c.id_juego AND a.id_cliente = d.id_cliente AND c.id_sucursal = d.id_sucursal AND c.id_torneo = d.id_torneo AND c.id_equipo = d.id_equipo AND d.id_cliente = e.id_cliente AND d.id_sucursal = e.id_sucursal AND d.id_torneo = e.id_torneo AND d.id_equipo = e.id_equipo AND e.jug_estatus = "A" ORDER BY 5,11') or die(mysqli_error($this->db)); $stmt->bind_param("iis", $cliente, $sucursal, $fecha); $stmt->execute(); $stmt->bind_result($id_torneo, $tor_nombre, $id_jornada, $id_juego, $fecha_partido, $id_arbitro, $cal_estatus, $cal_default, $id_equipo, $equipo_nombre, $locvis, $id_jugador, $jug_nombre, $jug_apellidop, $jug_apellidom, $jug_rep, $jug_playera, $jug_fechareg); $arreglo = array() ; $contador = 0; while ($stmt->fetch()) { $arreglo[$contador] = array("id_torneo"=>$id_torneo,"torneo_nombre"=>$tor_nombre,"id_jornada"=>$id_jornada,"id_juego"=>$id_juego,"fecha_partido"=>$fecha_partido,"id_arbitro"=>$id_arbitro,"cal_estatus"=>$cal_estatus,"cal_default"=>$cal_default,"id_equipo"=>$id_equipo,"equipo_nombre"=>$equipo_nombre,"locvis"=>$locvis,"id_jugador"=>$id_jugador,"jug_nombre"=>$jug_nombre,"jug_apellidop"=>$jug_apellidop,"jug_apellidom"=>$jug_apellidom,"jug_rep"=>$jug_rep,"jug_player"=>$jug_playera,"jug_fechareg"=>$jug_fechareg); $contador++; }

Hi friends, I'm using Kalins pdf in Wordpress. Where in the code below can I arrange these comments using "ORDER by comment_date DESC"? I have tried for weeks and I keep getting blank pages. I'll appreciate your input: function commentCallback($matches) { if(defined("KALINS_PDF_ COMMENT_CALLBACK")){ return call_user_func(KALINS_PDF_COMMENT_CALLBACK); } global $post; $comments = get_comments('status=approve&post_id=' .$post->ID); $commentString = $matches[2]; foreach($comments as $comment) { if($comment->comment_author_url == ""){ $authorString = $comment->comment_author; }else{ $authorString = '<a href="' .$comment->comment_author_url .'" >' .$comment->comment_author ."</a>"; } $commentString = $commentString .'<p>' .$authorString ." - " .get_comment_date(null, $comment->comment_ID) ." @ " .get_comment_date(get_option('time_format'), $comment->comment_ID) ."<br />" . $comment->comment_content ."</p>"; } //get_comment_date('m-d-Y @ g:i A', $comment->comment_ID) return $commentString .$matches[4]; }