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
Links not updating
I'm trying to fuel a simple navigation system for a news section. It works fine when it comes to ret
Company Code for Vendors created through Business Partners
Hi, experts!
I'm trying to set up the integration between Business Partner (BP) and Vendo
Populate drop down list from table??
Lets say for arguments sake that i have a table which contains the numbers 1 to 10.
How can i get
why does my session end?
my connect.php starts the session just so you know
i can navigate arround my site fine except whe
redirect standard error and assert (how to?)
How do you redirect standard error and assert?
---
(Why? I am creating an web app and
PHP Form to Variable.
Hi! I have written a HTML-form code in DreamWeaver CS3 (in a PHP doc) and I really need it to work s
php slowing my site?
Hi all,
I think that one of the reasons that my site doesn't work fast is that the code is ve
mysql UNION | warning mysql_fetch_array !!
Code: <?php
$i = 0;
$query1="SELECT * FROM `products` WHERE `div
PHP search multiple input field box help
I am having a problem with my search script. At current it will simply search by a selected date whi
SWF image using php?
Hello once again.
My latest en devour requires me to produce an image of a static .swf that i
