Help me please!

MBK

I am trying to format the results of a query.

What I need to do is create a table that has headings on the left and fills the table with the query results.

i.e.

Heading1 result1 result2
Heading2 result1 result2
Heading3 result1 result2

But I don't seem able to do it, I keep getting:

Heading1 result1
Heading2 result1
Heading3 result1

Heading1 result2
Heading2 result2
Heading3 result2

Can anyone help me?!

This is my script:-

<html>
<body>
<?php


$cpu=$_POST['cpu'];
$ffactor=$_POST['ffactor'];
$sound=$_POST['sound'];
$lan=$_POST['lan'];

echo "CPU: $cpu<br>Form Factor: $ffactor<br>Sound: $sound<br>LAN: $lan<hr><br>";


mysql_connect('localhost');
@mysql_select_db('mboards')or die("Unable to connect to selected database.");


$query="SELECT * FROM giga where cpu like '%$cpu%' AND ffactor like '%$ffactor%'";
$result=mysql_query($query);
$num=mysql_numrows($result);

mysql_close();

$i=0;
echo "<table width='355' border='0' cellspacing='0' cellpadding='0'>";
while($i<$num){

$model=mysql_result($result,$i,"model");
$cpu=mysql_result($result,$i,"cpu");
$chipset=mysql_result($result,$i,"chipset");
$ffactor=mysql_result($result,$i,"ffactor");
$fsb=mysql_result($result,$i,"fsb");
$ata=mysql_result($result,$i,"ata");
$agp=mysql_result($result,$i,"agp");
$memslot=mysql_result($result,$i,"memslot");
$memcap=mysql_result($result1,$i,"memcap");
$memtype=mysql_result($result1,$i,"memtype");
$pci=mysql_result($result1,$i,"pci");
$isa=mysql_result($result1,$i,"isa");
$amr=mysql_result($result1,$i,"amr");
$cnr=mysql_result($result1,$i,"cnr");
$sound=mysql_result($result1,$i,"sound");
$lan=mysql_result($result1,$i,"lan");
$other=mysql_result($result1,$i,"other");


//echo "<b>$model</b><br>$cpu<br>$chipset<br>$ffactor<br>$fsb<br><br>";

//echo "<table width='60%' border='0' cellspacing='0' cellpadding='0'>";
//echo "<tr><td width=20 align=left>Model</td><td width=20>CPU</td><td>Chipset</td><td>Form Factor</td><td>FSB</td></tr><br>
//      <tr><td>$model</td><td>$cpu</td><td>$chipset</td><td>$ffactor</td><td>$fsb</td></tr>
//</table>";



echo"    <td width='10'></td>
  <tr height='5'>
    <td colspan='7'></td>
  </tr>
  <tr><td height='1'></td></tr>  <tr height='20'>
    <td width='10'></td>
    <td width='130'><b>Model</font></b></td>
    <td width='10'></td>
    <td width='95'><b>$model</font></b></td>
    <td width='10'></td>
  <tr height='5' colspan='7'>
    <td colspan='7'></td>
  </tr>
  <tr valign='top'>
    <td width='10'></td>
    <td width='130' valign='middle'><b>CPU</font></b></td>
    <td width='10'></td>
    <td width='95'>$cpu</td>
    <td width='10'></td>
  <tr height='5'>
    <td colspan='7'></td>
  </tr>
  <tr height='5' colspan='7'>
    <td colspan='7'></td>
  </tr>
  <tr valign='top'>
    <td width='10'></td>
    <td width='130' valign='middle'>Chipset&nbsp;</td>
    <td width='10'></td>
    <td width='95'>$chipset</td>
    <td width='10'></td>

  <tr height='5'>
    <td colspan='7'></td>
  </tr>
  <tr height='5' colspan='7'>
    <td colspan='7'></td>
  </tr>
  <tr valign='top'>
    <td width='10'></td>
    <td width='130'>Form Factor&nbsp;</td>
    <td width='10'></td>
    <td width='95' class='small'>$ffactor</td>
    <td width='10'></td>

  </tr>
  <tr height='5' colspan='7'>
    <td colspan='7'></td>
  </tr>

  <tr valign='top'>
    <td width='10'></td>
    <td width='130'>fsb&nbsp;</td>
    <td width='10'></td>
    <td width='95' class='small'>$fsb</td>
    <td width='10'></td>

</tr>";


++$i;
}

echo "</table>";


?>
</body>
</html>

Someone help please!!

eriksmoen

try this:

mysql_connect('localhost');
@mysql_select_db('mboards')or die("Unable to connect to selected database.");


$query="SELECT * FROM giga WHERE cpu LIKE '%$cpu%' OR ffactor LIKE '%$ffactor%'";
$result=mysql_query($query);
$num=mysql_numrows($result);

echo "<table width='355' border='0' cellspacing='0' cellpadding='0'>";
while($this == $result){

$model=$this['model'];
$cpu=$this['cpu'];
$chipset=$this['chipset]';
$ffactor=$this['ffactor'];
$fsb=$this['fsb'];
$ata=$this['ata'];
$agp=$this['agp'];
$memslot=$this['memslot'];
$memcap=$this['memcap'];
$memtype=$this['memtype'];
$pci=$this['pci'];
$isa=$this['isa'];
$amr=$this['amr'];
$cnr=$this['cnr'];
$sound=$this['sound'];
$lan=$this['lan'];
$other=$this['other'];

echo"    <td width='10'></td>
  <tr height='5'>
    <td colspan='7'></td>
  </tr>
  <tr><td height='1'></td></tr>  <tr height='20'>
    <td width='10'></td>
    <td width='130'><b>Model</font></b></td>
    <td width='10'></td>
    <td width='95'><b>$model</font></b></td>
    <td width='10'></td>
  <tr height='5' colspan='7'>
    <td colspan='7'></td>
  </tr>
  <tr valign='top'>
    <td width='10'></td>
    <td width='130' valign='middle'><b>CPU</font></b></td>
    <td width='10'></td>
    <td width='95'>$cpu</td>
    <td width='10'></td>
  <tr height='5'>
    <td colspan='7'></td>
  </tr>
  <tr height='5' colspan='7'>
    <td colspan='7'></td>
  </tr>
  <tr valign='top'>
    <td width='10'></td>
    <td width='130' valign='middle'>Chipset&nbsp;</td>
    <td width='10'></td>
    <td width='95'>$chipset</td>
    <td width='10'></td>

  <tr height='5'>
    <td colspan='7'></td>
  </tr>
  <tr height='5' colspan='7'>
    <td colspan='7'></td>
  </tr>
  <tr valign='top'>
    <td width='10'></td>
    <td width='130'>Form Factor&nbsp;</td>
    <td width='10'></td>
    <td width='95' class='small'>$ffactor</td>
    <td width='10'></td>

  </tr>
  <tr height='5' colspan='7'>
    <td colspan='7'></td>
  </tr>

  <tr valign='top'>
    <td width='10'></td>
    <td width='130'>fsb&nbsp;</td>
    <td width='10'></td>
    <td width='95' class='small'>$fsb</td>
    <td width='10'></td>

</tr>";

}

mysql_close($query);
echo "</table>";

------------------------

i didn't read the whole code (because I'm sitting in class), just browsed where i thought errors might be and fixed some... will still probably require some more error-checking... Hope it helps you out.

MBK

Hi,
Thanks for the reply, but it doesn't seem to work.

I have added:
<html>
<body>
<?

at the top of the page and

?>
</body>
</html>

at the bottom of the page, but it still doesn't work.

What does the $this refer to?

eriksmoen

.
oops... sorry... should be:

while($this = mysql_fetch_array($result){

instead of:

while($this==$result){

my bad. 😛

hope that does it for ya.

miky58k

If I understand what you wanted correctly, the following code
should give you results of more or less this form:

CPU:
Form Factor:
Sound:

LAN:

Model model1 model2 model3 etc

CPU cpu1 cpu2 cpu3 etc

Chipset chipset1 chipset2 chipset3 etc

Form Factor ff1 ff2 ff3 etc

fsb fsb1 fsb2 fsb3 etc

--
I'm sure there is a better way to do it, but this what first came to
my mind.

the code for the table -

<html>
<body>
<?php

// $cpu, $ffactor, $sound, $lan should already exist if sent from a posted form
// if you have a reason to be concerned that vars could be set by another source
// you can just do a extract($_POST); and that will over-write anything else

mysql_connect('localhost');
@mysql_select_db('mboards') or die("Unable to connect to selected database.");

$query = "SELECT * FROM giga where cpu like '%$cpu%' AND ffactor like '%$ffactor%'";
$result = mysql_query($query);

mysql_close();

// populate arrays holding all info of a single field
// mysql_fetch_assoc only available on php >= 4.0.3, if you don't have that,
// mysql_fetch_array($result, MYSQL_ASSOC) is almost as fast
while($row = mysql_fetch_assoc($result))
{
    $field_values['model'][] = $row['model'];
    $field_values['cpu'][] = $row['cpu'];
    $field_values['chipset'][] = $row['chipset'];
    $field_values['ffactor'][] = $row['ffactor'];
    $field_values['fsb'][] = $row['fsb'];
}

echo "
CPU: $cpu<br>
Form Factor: $ffactor<br>
Sound: $sound<br>
LAN: $lan<hr><br>

<table width='355' border='0' cellspacing='0' cellpadding='0'>";

$table_headers = array(
    "Model" => "model",
    "CPU" => "cpu",
    "Chipset" => "chipset",
    "Form Factor" => "ffactor",
    "fsb" => "fsb",
    );
foreach($table_headers as $header => $fieldname)
{
    echo "
    <tr height='5'></tr>

<tr height='20'>
    <td width='10'></td>
    <td width='130' valign='middle'><b>$header</b></td>
    <td width='10'></td>";

foreach($field_values[$fieldname] as $value)
{
    if ($fieldname == "ffactor" || $fieldname == "fsb")
    {
        echo "
    <td width='95' class='small'><b>$value</b></td>";
    } else {
        echo "
    <td width='95'><b>$value</b></td>";
    }
}

echo "
    <td width='10'></td>
</tr>";

}

?>
    </table>
</body>
</html>

As a side note, I noticed you set variables referencing fields by assigning
$fieldname = $mysq_row['fieldname'];
To save you some typing, you might try
extract($mysql_row);
Which takes an associative array and treats keys as variable
names and values as variable values. For each key/value pair it
will create a variable in the current symbol table.
http://www.php.net/manual/en/function.extract.php for more details

MBK

Hey,
That works great.

Thanks a lot.