Hi All,
I'm trying to put a set of numbers (i.e. stored like: 0,2,4,6,8,10...)
from a database field, into an array, so that I can loop through and
display them.
Below is my 'Good Test Code' that uses manually populated arrays,
followed by the 'Good Results' I get.
Below this, under 'Crappy Test Code' is the same code (with the kind
of thing I am trying to do, although successfully ;) with the line:
$sizeArray = array(0,2,4,6,8,10,12,14,16,18,20,22,24,26,28);
changed to:
$sizeArray = array($row[3]);
follow by the 'Crappy Results' results that I get.
For some reason (that I don't know of), the $sizeArray seems to treat
the $row[3] as a literal string or something???
I hope this makes sense and sorry the post is a bit long.
Mat
Good Test Code
============
<?php
require_once('model/global.php');
$field = '*';
$table = 'sizes';
$condition = "WHERE brandID = 'mega-whoppers'";
include('model/qrySelect.php');
$row = $result->fetch_array(MYSQLI_NUM);
printf ("%s (%s)\n", $row[3], $row[4]);
$sizeArray = array(0,2,4,6,8,10,12,14,16,18,20,22,24,26,28);
$bustArray = array
(31,32,33,34,35,36.5,38,39.5,41,43,45,47.5,50,53,56);
$waistArray = array
(31,32,33,34,35,36.5,38,39.5,41,43,45,47.5,50,53,56);
$hipsArray = array
(31,32,33,34,35,36.5,38,39.5,41,43,45,47.5,50,53,56);
$notesArray = array("Standard gown length is 59 inches / 150 cm's from
hollow to hem.","Standard bodice length is 14.5 inches / 37 cm's from
hollow to waist.","Standard sleeve length is 18 inches / 46 cm's from
underarm to wrist.","No extra charges for plus sizes.","Factory
tolerance on measurement is 1/2 an inch / 1.3 cm's.");
$sizeArrayCount = count($sizeArray);
$i = 0;
?>
<table>
<tr>
<th>Size</th>
<th>Bust (in)</th>
<th>Waist (in)</th>
<th>Hips (in)</th>
</tr>
<?php
while($sizeArrayCount > $i)
{
echo "<tr>";
echo "<td>" . $sizeArray[$i] . "</td>";
echo "<td>" . $bustArray[$i] . "</td>";
echo "<td>" . $waistArray[$i] . "</td>";
echo "<td>" . $hipsArray[$i] . "</td>";
echo "</tr>";
$i++;
}
echo "</table>";
?>
Good Results
==========
0,2,4,6,8,10,12,14,16,18,20,22,24,26,28
(31,32,33,34,35,36.5,38,39.5,41,43,45,47.5,50,53,56)
Size Bust (in) Waist (in) Hips (in)
0 31 31 31
2 32 32 32
4 33 33 33
6 34 34 34
8 35 35 35
10 36.5 36.5 36.5
12 38 38 38
14 39.5 39.5 39.5
16 41 41 41
18 43 43 43
20 45 45 45
22 47.5 47.5 47.5
24 50 50 50
26 53 53 53
28 56 56 56
Crappy Test Code
=============
<?php
require_once('model/global.php');
$field = '*';
$table = 'sizes';
$condition = "WHERE brandID = 'mega-whoppers'";
include('model/qrySelect.php');
$row = $result->fetch_array(MYSQLI_NUM);
printf ("%s (%s)\n", $row[3], $row[4]);
//THIS IS WHAT THE KIND OF THING I AM TRYING TO DO AND NEED HELP
WITH!!
$sizeArray = array($row[3]);
//$sizeArray = array(0,2,4,6,8,10,12,14,16,18,20,22,24,26,28);
$bustArray = array
(31,32,33,34,35,36.5,38,39.5,41,43,45,47.5,50,53,56);
$waistArray = array
(31,32,33,34,35,36.5,38,39.5,41,43,45,47.5,50,53,56);
$hipsArray = array
(31,32,33,34,35,36.5,38,39.5,41,43,45,47.5,50,53,56);
$notesArray = array("Standard gown length is 59 inches / 150 cm's from
hollow to hem.","Standard bodice length is 14.5 inches / 37 cm's from
hollow to waist.","Standard sleeve length is 18 inches / 46 cm's from
underarm to wrist.","No extra charges for plus sizes.","Factory
tolerance on measurement is 1/2 an inch / 1.3 cm's.");
$sizeArrayCount = count($sizeArray);
$i = 0;
?>
<table>
<tr>
<th>Size</th>
<th>Bust (in)</th>
<th>Waist (in)</th>
<th>Hips (in)</th>
</tr>
<?php
while($sizeArrayCount > $i)
{
echo "<tr>";
echo "<td>" . $sizeArray[$i] . "</td>";
echo "<td>" . $bustArray[$i] . "</td>";
echo "<td>" . $waistArray[$i] . "</td>";
echo "<td>" . $hipsArray[$i] . "</td>";
echo "</tr>";
$i++;
}
echo "</table>";
?>
Crappy Results
===========
0,2,4,6,8,10,12,14,16,18,20,22,24,26,28
(31,32,33,34,35,36.5,38,39.5,41,43,45,47.5,50,53,56)
Size Bust (in) Waist (in) Hips (in)
0,2,4,6,8,10,12,14,16,18,20,22,24,26,28 31 31 31
--~--~---------~--~----~------------~-------~--~----~
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
-~----------~----~----~----~------~----~------~--~---
