riots1 Posted December 2, 2009 Share Posted December 2, 2009 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? <?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); ?> Link to comment https://forums.phpfreaks.com/topic/183792-how-do-i-make-new-line-after/ Share on other sites More sharing options...
corbin Posted December 2, 2009 Share Posted December 2, 2009 You could just use str_replace. As a side note, you should do a while loop instead of a do while loop with database results unless you know for sure that there's a first result. (You would need to get rid of the $row_rs1 = mysql_fetch_assoc($rs1); before the loop.) Link to comment https://forums.phpfreaks.com/topic/183792-how-do-i-make-new-line-after/#findComment-970119 Share on other sites More sharing options...
riots1 Posted December 3, 2009 Author Share Posted December 3, 2009 can you show me of an example on how I can use it with to replace the * with <br/> Link to comment https://forums.phpfreaks.com/topic/183792-how-do-i-make-new-line-after/#findComment-970195 Share on other sites More sharing options...
cloudy243 Posted December 3, 2009 Share Posted December 3, 2009 str replace would be like $new = str_replace("*","<br />", $old); Link to comment https://forums.phpfreaks.com/topic/183792-how-do-i-make-new-line-after/#findComment-970273 Share on other sites More sharing options...
riots1 Posted December 3, 2009 Author Share Posted December 3, 2009 awesome guys thank.. i got it working fine now http://wellnessconnections.net/educational-guide/ Link to comment https://forums.phpfreaks.com/topic/183792-how-do-i-make-new-line-after/#findComment-970686 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.