display multiple currency pricing in html

Thx1138

Hi Folks, I decide to try and learn a little php and created my first database yesterday. It is simple one table with 7 fields (id, item, period, CDN, US, GBP, EURO). I want to display the contents of this database in a table. So that the price related to period (1, 2, 3, 5 or 10) is displayed in the appropriate table cell. Although my code sample doens't include it I will use an If/Else statement and a form to display and select the various currencies:

<table width="550" border="1">
  <tr>
    <th>domains</td>
    <th>1 year</td>
    <th>2 years</td>
    <th>5 years</td>
    <th>10 years</td>
  </tr>
<?php
$username="xxxx";
$password="xxxx";
$database="xxxx";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM pricing";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {

$item=mysql_result($result,$i,"item");
$period=mysql_result($result,$i,"period");
$cdn=mysql_result($result,$i,"cdn");

?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><b><center>.ca, .bc.ca etc.</center></font></td>
<td><font face="Arial, Helvetica, sans-serif">$<? echo $cdn; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif">$<? echo $cdn; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif">$<? echo $cdn; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif">$<? echo $cdn; ?></font></td>
</tr>

<?
$i++;
}

echo "</table>";

?>

For some reason this displayes only one value (the CDN price for period 1) in each of the cells. I'm certain that when I first tested it displayed (all the CDN priced for the periods I needed.

Not being a programmer or db designer I may not be able to do this easily witht eh db design I've used or with the lack of php-coding skill. So joined this baord jsut in case this is rather simple and its something I'm jsut not aware of or didn't consider when designing my database. Any help would be appreciate. Please not that some items won't have pricing for period's 3 or 5 & 10.

dalecosp

Well, not a bad start, but it looks as if you're printing all the $cdn variables on one pass --- hence, they will all be the same value.

Taking a look at the manual for [man]mysql_result/man, you might note that they recommend using a more powerful function (such as [man]mysql_fetch_row[/man], [man]mysql_fetch_array[/man], etc) in situations involving larger data sets.

Seems like something like this would be the way to go:

<?php

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM pricing";
$result=mysql_query($query);

while ($cdn=mysql_fetch_row($result)) {

   echo "
<td>$cdn[1]</td>
<td>$cdn[2]</td>
// and so on....
?>

🙂

Thx1138

Thanks for the advice! But I tried working with that code and keep getting parse errors?

Parse error: parse error, unexpected $ in /home/user/public_html//displaytest2.php on line 22

The file ends with at line 21?

Thx1138

Here is the code I'm testing...

<?php

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM pricing";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

while ($cdn=mysql_fetch_row($result)) { 

   echo " 
<td>$cdn[1]</td> 
<td>$cdn[2]</td>

?>

dalecosp

Well, you must complete the "and so on" part. I gave an example rather than a complete script. If you're just testing my example, you'll get at least one parse error because the string isn't terminated (no closing quotation mark, and no semicolon). Then you'd get one because the loop isn't terminated with a curly brace ... and so on.

At the very least, you should round out the echo statement with the rest of your table cells, close it properly and terminate the while() loop. Then see what you get .....

Thx1138

Yep I figured as much... this is pretty basic programming I guess but being completely new to this I'm relying on examples and tutorials and haven't quite got a handle why this is done or what a while loop is etc. I will do some more reading and write the code properly then. Thanks for the help and feedback dalecosp!