[Resolved] Bullet Point Layout

[dcjones]

Hi all,

I have been working on my problem for 3 days with zero result.

I have a table, one of the feilds holds data which when presented on screen I want to be able to use bullet points. ie,

1. first line
2. second line
3. third line

and so on.

The dat is stored as one string in the table, can the above be done.

Any ideas would be good.

Kind regards, keep safe and well.

Dereck

[TheDefender]

The dat is stored as one string in the table

Working on an assumption here, that when you say the above thing, you mean the data is in one column in a table?, so your data is something like:

line 1, line 2, line 3 (all in one field?)

That being the case, you need to query the table, and get that column, then explode the string... In the above example, something like:

$qry = mysql_query("SELECT * FROM table WHERE condition = met");
$row = mysql_fetch_array($qry));
$broken = explode(",", $row['fieldwithdata']);
$countbroken = count($broken);
echo "<OL>";
FOR($i = 0; $i < $countbroken; $i++){
  echo "<LI>".$broken[$i]."</LI>";
}
echo "</OL>";

This may not be exactly what you are looking for, but will hopefully get you started.

[dcjones]

Hi and thanks for your reply.

I am working on it.

I will come back and let you know how I get on.

Many thanks

Dereck

[dcjones]

Hi, it is I again.

This is waht I have so far.

<?php require_once('../Connections/Chandos.php'); ?>
<?php
mysql_select_db($database_Chandos, $Chandos);
$query_record_detail = "SELECT * FROM chandos_books";
$record_detail = mysql_query($query_record_detail, $Chandos) or die(mysql_error());
$row_record_detail = mysql_fetch_assoc($record_detail);
$totalRows_record_detail = mysql_num_rows($record_detail);

$maxRows_DetailRS1 = 4;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
  $pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;

mysql_select_db($database_Chandos, $Chandos);
$recordID = $_GET['recordID'];
$query_DetailRS1 = "SELECT * FROM chandos_books WHERE book_title = '$recordID'";
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $Chandos) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);



if (isset($_GET['totalRows_DetailRS1'])) {
  $totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];
} else {
  $all_DetailRS1 = mysql_query($query_DetailRS1);
  $totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);
}
$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1;
?>

Then some HTML code,

<?
mysql_select_db($database_Chandos, $Chandos);
$recordID = $_GET['recordID'];	
$query_DetailRS1 = mysql_query("SELECT * FROM chandos_books WHERE book_title = '$recordID'"); 


$row = mysql_fetch_array($query_DetailRS1)); 
$broken = explode(",", $row['key_features']); 
$countbroken = count($broken); 
echo "<OL>"; 
FOR($i = 0; $i < $countbroken; $i++){ 
  echo "<LI>".$broken[$i]."</LI>"; 
} 
echo "</OL>";

<?php echo $row_DetailRS1['key_features'];
?>

It has an error here

mysql_select_db($database_Chandos, $Chandos);
$recordID = $_GET['recordID'];

Parse error: parse error, unexpected ')

Any idea looking at the above.

Kind regards

Dereckphp

[TheDefender]

On this line:

$row = mysql_fetch_array($query_DetailRS1));

Remove one of the closing parens ), so it looks like:

$row = mysql_fetch_array($query_DetailRS1);

My bad, I missed it in my post originally.

[dcjones]

Hi,

Great it works,

Changed the code from <ol> to <ul> with the right results.

Your a star. Next time i'm in your town I will buy you a beer.

Many thanks

Keep safe and well.

Dereck

[TheDefender]

I will take you up on that, but only if it is a good English Stout brew 😉. The brews we get here in the US don't compare...