RE: [PHP-DB] listing question
Hi there, I tried something similar: $query = SELECT * FROM videos WHERE videomakers_website_url = '$x' AND privatepublic = 'public' AND producer_website LIKE '%$x%' OR videomakers_website_url LIKE '%$x%' ORDER BY videomakers_site_position ASC, video_title ASC LIMIT $offset, $item_perpage; $querytotal = SELECT count(*) FROM videos WHERE videomakers_website_url = '$x' AND privatepublic = 'public' AND producer_website LIKE '%$x%' OR videomakers_website_url LIKE '%$x%' ORDER BY videomakers_site_position ASC, video_title ASC; My problem is, it displays not alphabetical videos first and then LAST it displays the videos with numbers, and when I can get the numbers at the top of the listing, they are in the wrong order (IE: 0,1,2 is from the bottom up and not 0 being at the top, 1 being next and so on). Chris Is there something stopping you from specifying two columns to order results by, ie: select myNumeric , myText from myTable order by myNumeric asc, myText asc -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.4.1/308 - Release Date: 4/11/2006 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] listing question
Chris Payne wrote: Hi there, I tried something similar: $query = SELECT * FROM videos WHERE videomakers_website_url = '$x' AND privatepublic = 'public' AND producer_website LIKE '%$x%' OR videomakers_website_url LIKE '%$x%' ORDER BY videomakers_site_position ASC, video_title ASC LIMIT $offset, $item_perpage; $querytotal = SELECT count(*) FROM videos WHERE videomakers_website_url = '$x' AND privatepublic = 'public' AND producer_website LIKE '%$x%' OR videomakers_website_url LIKE '%$x%' ORDER BY videomakers_site_position ASC, video_title ASC; My problem is, it displays not alphabetical videos first and then LAST it displays the videos with numbers, and when I can get the numbers at the top of the listing, they are in the wrong order (IE: 0,1,2 is from the bottom up and not 0 being at the top, 1 being next and so on). I don't understand what you want (maybe a sample 5 in the order you get and the order you want will help us - include the position field if you send it through). Do you want alphabetical first then numbers? change your order: order by video_title asc, videomakers_site_position asc; if you want numbers first: order by videomakers_site_position asc, video_title asc; Lastly, you don't need to order your results for a count query ($querytotal) :) -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
