Selecting multiple rows by id

[renob]

Hello, i am trying to select 8 specific rows from my db that pertain to my billing management software. what i wanna do is dynamically updat the pricing on the order page by only have to do it threough the billing software.

I managed to get one working, but its long and im sure theres a simpler solution just not sure.

function showprices(){
include "config.php";
unset($db,$table);
$db='xxxxxxxxxx';
$table='xxxxxxxx';
$connection = mysql_connect($host, $uname, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");
$query = "SELECT * FROM `$table` ORDER BY pack_id ASC LIMIT 4, 8";
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_row($result);
$row =$row[2];
$row = explode('|0|0|0|0',$row);
echo $row[0];
}

as you can tell, $row[0] is the price i want, but i have 7 more to like this, and what happens in the future if i add more plans. then the ids will get messed up. the ids right now are not incremental so im pretty much stuck 😕

Thanks for any help

[bogu]

This is how u should parse your results from mysql:

	if (mysql_num_rows($result)) { 
		while ($row = mysql_fetch_assoc($result)) {
			$tmp = $row['field_needed'];
			$tmp = explode('|0|0|0|0',$tmp);
			echo $tmp[0];
		}
	}

[renob]

Ok i was able to return an array from the needed rows, but i have 8 seperate arrays.

how can combine this into 1 array with keys from 0-7?

Heres the code i used for this array

include "rev_includes/config.php";
unset($db,$table);
$db='xxxxx';
$table='xxxxxxxx';
$connection = mysql_connect($host, $uname, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");
$query = "SELECT pack_price FROM `$table` ORDER BY pack_id ASC LIMIT 4, 8";
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
while($row=mysql_fetch_array($result)){
//print_r($row);
}
$row =$row[2];
$row = explode('|0|0|0|0',$row);
echo $row[2];

And this is the resulting array

Array
(
    [0] => 199|0|0|0|0|0
    [pack_price] => 199|0|0|0|0|0
)
Array
(
    [0] => 209|0|0|0|0|0
    [pack_price] => 209|0|0|0|0|0
)
Array
(
    [0] => 199|0|0|0|0|0
    [pack_price] => 199|0|0|0|0|0
)
Array
(
    [0] => 209|0|0|0|0|0
    [pack_price] => 209|0|0|0|0|0
)
Array
(
    [0] => 269|0|0|0|0|0
    [pack_price] => 269|0|0|0|0|0
)
Array
(
    [0] => 319|0|0|0|0|0
    [pack_price] => 319|0|0|0|0|0
)
Array
(
    [0] => 519|0|0|0|0|0
    [pack_price] => 519|0|0|0|0|0
)
Array
(
    [0] => 549|0|0|0|0|0
    [pack_price] => 549|0|0|0|0|0
)

Thanks all

[renob]

must have posted at the same time 🙂

Using what you posted i have a smaller array, looks like its getting there, but it needs to be 1 array with 7 keys

Array
(
    [pack_price] => 199|0|0|0|0|0
)
Array
(
    [pack_price] => 209|0|0|0|0|0
)
Array
(
    [pack_price] => 199|0|0|0|0|0
)
Array
(
    [pack_price] => 209|0|0|0|0|0
)
Array
(
    [pack_price] => 269|0|0|0|0|0
)
Array
(
    [pack_price] => 319|0|0|0|0|0
)
Array
(
    [pack_price] => 519|0|0|0|0|0
)
Array
(
    [pack_price] => 549|0|0|0|0|0
)

[bogu]

while ($row = mysql_fetch_assoc($result)) {
    $arr[] = $row;
}

u need something like this:

while ($row = mysql_fetch_assoc($result)) {
    $arr[] = $row['pack_price'];
}

[renob]

Thank you, but that still prints out

Array
(
    [pack_price] => 199|0|0|0|0|0
)
Array
(
    [pack_price] => 209|0|0|0|0|0
)
Array
(
    [pack_price] => 199|0|0|0|0|0
)
Array
(
    [pack_price] => 209|0|0|0|0|0
)
Array
(
    [pack_price] => 269|0|0|0|0|0
)
Array
(
    [pack_price] => 319|0|0|0|0|0
)
Array
(
    [pack_price] => 519|0|0|0|0|0
)
Array
(
    [pack_price] => 549|0|0|0|0|0
)

[bogu]

Print $arr not the $row ....