Using LIMIT with %

Square1

Hi all:

I have a strong suspicion this won't fly, but can you use LIMIT with %? For example, LIMIT 50%?

I want to set up a table with 2 columns. The first column has the 1st 50% of the results, the second column has the second 50%. There doesn't seem to be any clean way to do this.

My thought is to first run a SQL statement that just gets a total count. Then run a SQL statement with the LIMIT being 1/2 the results of the first statement, then a third SQL statement using LIMIT X , X with X being that same 1/2 number.

It just seems like a lot to have to run 3 statements to accomplish this.

Thanks!

dagon

why not select them all and use php to divide em in to 2 col's

Square1

dagon;10986911 wrote:
why not select them all and use php to divide em in to 2 col's

Thank you.

I went to the following example and tried to adapt this to a dynamic array:

http://phpro.org/examples/Create-Columns-From-Array.html

The coding has the results read from left to right instead of a true up/down column as I would prefer. So it is

Apple Banana Cherry
Kiwi Melon Pineapple

instead of

Apple Cherry Melon
Banana Kiwi Pineapple

My SQL has two items in it "promoter" and "prID". I only want "promoter" to appear in the column but both items are appearing (I tried foreach ( $row["promoter"] as $item )). Here is my code:

<html>
<head><title>test</title></head>
<body>

<?php

require($_SERVER['DOCUMENT_ROOT'].'/inc/dbconn.php');
    /*** the number of columns wide ***/
        $num_cols = 2;

	$query3 = "
	SELECT
	DISTINCT events.promoter,
	promoters.prID
	FROM events INNER JOIN promoters ON events.promoter = promoters.promoter
	WHERE
	promoters.discountAmount <> '0' AND
	eventDate >= CURDATE()
	ORDER BY
	events.promoter
	";

	$result = mysqli_query($link, $query3);

?>

<table>
<?php
    /*** set a counter ***/
        $i = 0;
    /*** loop over the array ***/
	while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){
        foreach ( $row as $item )
        {

            /*** use modulo to check if the row should end ***/
            echo $i++%$num_cols==0 ? "</tr><tr>\r\n" : "";

            /*** output the array item ***/
            echo "<td>".$item."</td>\r\n";
    }
}
	mysqli_free_result($result);
	mysqli_close($link); 
?>
</tr>
</table>
</body>
</html>

dagon

http://www.phpbuilder.com/board/showthread.php?s=&postid=10593202#post10593202

Square1

dagon;10986929 wrote:
http://www.phpbuilder.com/board/showthread.php?s=&postid=10593202#post10593202

Bingo! I need to dust off my thinking cap for this.