how do i make new line after *


Posted on 16th Feb 2014 07:03 pm by admin

First check this page here. and you see my report. Im pulling form a mysql db. I want to beable to make a new line before each *
Also why does some characters come out all funky?
Hers my code.. I dont know if it has to do with how its stored to the db?

Did you know?Explore Trending and Topic pages for more stories like this.
Code: <?php require_once('../Connections/wellness.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

mysql_select_db($database_wellness, $wellness);
$query_rs1 = "SELECT * FROM LISTINGS WHERE EDUON ='on'";
$rs1 = mysql_query($query_rs1, $wellness) or die(mysql_error());
$row_rs1 = mysql_fetch_assoc($rs1);
$totalRows_rs1 = mysql_num_rows($rs1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Wellness Connections Educational Listing</title>
<link href="style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
a:link {
text-decoration: none;
color: #000;
}
a:visited {
text-decoration: none;
color: #000;
}
a:hover {
text-decoration: none;
color: #000;
}
a:active {
text-decoration: none;
color: #000;
}
-->
</style></head>

<body>
<?php do { ?>
<div id="table" ><span class="style1"><?php echo $row_rs1['CONTACTNAME']; ?></span>

..................................
<span class="style1"><a href="<?php echo $row_rs1['LISTLINK']; ?>"><?php echo $row_rs1['TITLE']; ?></a></span> <br />
<div id="indent"><?php echo $row_rs1['EDUDESCRIPTION']; ?></div>
<hr />
</div>




<?php } while ($row_rs1 = mysql_fetch_assoc($rs1)); ?>
</body>
</html>
<?php
mysql_free_result($rs1);
?>
No comments posted yet

Your Answer:

Login to answer
222 Like 31 Dislike
Previous forums Next forums
Other forums

I face problems to extract data from one table and insert it in another one
Hi,

For modifications, I have to extract data from one table and insert it in another one

how can i make a .gif images for my site
Dear Friends ,

Pls solve my problem , I am starting making new site but i dont know how can i

how to validate date using javascript
I need to validate date in textbox using javascript..
The date is must be not greater than TODAY

Creating XML with php
I need to creat an XML with php and have successfully produced a valid output.
The problem I hav

isset undefined variable
Hi all,

Hope someone can point out the obvious. I've a log in script, if you dont enter a use

double and single quotes in text fields acting up... help please
Single quotes, when entered into a text field, create an sql error upon Submit. It seems to create t

using file_get_contents??
okay how would i create a script using file_get_contents() in php have it grab search pages 1-20 and

$GPRMC and NMEA how to extract from report
Hi There,

Im a little bi lost and not sure where to start with this one, ive got a small gps

Get to know your fellow coder
I think it's time we got personal around here. There's a lot of code swapping and a few members kno

Day of week
I am using PHP version 5.0.5
I have a varaible ($DATE (date format yyyy-mm-dd)) that is being inc

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash