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?

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

Exporting new records
Trying to figure out the best way to set this up.

People register my site.

Their prof

apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

Why doesn't this work? (SSH2)
This is my script:

Code: <?php
$connection = ssh2_connect('213.251.167.109', 22);

header redirect problems? please help
Ok i am making a site that generates youtube thumbnails and i am generating an image that displays 1

Does design fit in FPGA ?
Hi all,

I've made a large HCC-Design. Because of the program-size the compile process with th

Calander layout
Hi i know this sounds like a simple question but i cant find the answer to it anywhere i have added

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to

PHP File Upload Problem
Hi, I have written a very simple file upload script but it fails for reasons I can't explain. Hope

Not Inserting into DB
I can't get my Add new Division form to submit to the database. Anyone see my issue?

Code: &a

calculator
I can't figure out why this code doesn't work. No error messages. Page loads.

Code: <

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