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 
31 
Other forums
Deleted Delivery but material wont return
We deleted a delivery but the material its still pending.
We made a reverse goods movemen
need Array help
This is what I have to do.
$teamname[1] = "Red Sox"
$teamname[2] = "Gian
Php mysql - select?
Hi i have this code:
Code: $iteminfo = mysql_query("SELECT desc FROM wc_items WHERE itemid =
Getting a variable to work in function params
I have this fuction which is inside a class:
Code: public static function generateEmbedCode($
Gridview Not updating in Update Panel
I have a gridview, three dropdown list boxes, and a button on my form. What is displayed in the gri
php is not recognized as an internal or external command
Hello,
I am trying to bake the code in CakePHP through my console.
I have changed my Path
Install page
How do I make it so when a user submits information on the Install page, it'll right it into the cor
firefox wouldnt stream mp3 files completely from my php page
hi everyone,
I have a php file trying to read and stream mp3 files. It works fine in IE but my pr
Wierd if else problem
Hi guys,
this probably aint wierd for you, but it seems like php is playin up to me. may b i
form problem
Hi all, I think this is going to be easy to resolve but for I have been looking at it to long and I
