piedpiper

One last question. So this is how it would be coded? echo stripslashes ($myrow['text1']); I only ask because even though something works, doesn't mean it's the correct syntax, lol

Ok, so i should use stripslashes on the page that displays (below) the DB content to remove them? echo $myrow['text1']; PS:I'll have a look at the documentation on the function.

magic_quotes are turned off I'm pretty sure. Ok so I added the stripslashes as below if(isset($_POST['submit3'])) { $text1 = $_POST['text1']; $text1 = mysql_real_escape_string($text1); $text1 = stripslashes($text1); if(!$text1) { and as I said that works, but now i get the 'rn' after every <p> tag in the code. <p>rn this is a <a href="http://www.google.com">link</a></p>rn<p>rn this is some text</p>rn<p>rn this is some text</p>rn It looks like this on display rn this is a link rn rn this is some text rn rn this is some text rn Any ideas as to why this would be happening?

Hi guys I'm fairly new to the forums and PHP, and am having some problems with slashes on the 'Add Hyperlink' button on CKEditor. Please let know if this is the wrong forum for this post. I currently have some simple code that lets me add news (blog style) to a mysql database. if(isset($_POST['submit3'])) { $text1 = $_POST['text1']; $text1 = mysql_real_escape_string($text1); if(!$text1) { echo "<center>One or more fields were not completed!<br /><br />Redirecting Back</center>"; echo "<meta http-equiv=Refresh content=2;url=newsadd.php>"; exit; } else { $result = mysql_query("INSERT INTO news (title, dtime, text1) VALUES ('$title',NOW(),'$text1')",$connect); echo "<center>Added Successfully!<br><br />Redirecting Back</center>"; echo "<meta http-equiv=Refresh content=2;url=index.php>"; } } Now please correct me if I'm wrong but I thought the mysql_real_escape_string was meant to remove slashes and make the content safe for insertion. It has been working fine up until this point, where I have now added the CKEditor wysiwyg editor (so as to have formatting options) instead of just using plain text fields. But using this editor adds slashes to my links on insertion to the DB. If I insert $text1 = stripslashes($text1); to the above code as well as mysql_real_escape_string it inserts the link into DB properly but ads an 'rn' to after every <p> tag in the code inserted in DB. I would have thought that cause the code coming from CKEditor was clean (by checking the source code of what I've written in the editor prior to submitting) that my submission to database would also be clean because of mysql_real_escape_string. Can you use both mysql_real_escape_string and stripslashes together or is this a no-no. Any help with this would be much appreciated

Ok, managed to nut it out using php within html, rather than the other way around. This then lets the CSS properties apply to the layout. Thought I'd post it up in case anyone wants to know. And Dropfaith, thanks for the error_reporting tip I didn't know you could do that. Will help me lots in the future! <?php include "../connect.php"; $getlist = mysql_query("SELECT * from mailing_list order by email ASC") or die("Could not get list"); //select e-mails in ABC order ?> <table border="0"><tr id="heading"> <td>Email...</td><td>Date Joined...</td><td>Validated...</td><td>Delete...</td></tr> <?php while($result=mysql_fetch_array($getlist)){ ?> <tr><td><a class="contact" href="mailto:<?php echo $result['email'];?>"><?php echo $result['email'];?></a></td> <td><?php echo $result['datejoined'];?></td> <td><center><?php echo $result['validated'];?></center></td> <td><a class="contact" href="deluser.php?ID=<?php echo $result['userID'];?>">Delete</a></td></tr> <?php } ?> </table>

Sorry dropfaith. That '<a class id' was a typo I didn't catch. Actually boths classes and id's work fine in html, but for some reason when its in the Print statement nested in the php tags, neither the id nor class works. The browser just shows a blank page.

Hi Guys I am new to PHP and the forum. I'm wondering if anyone can help me out with a css/php related issue. I have some php code that pulls its info from Mysql database and displays as a link. What I want to do is style the 'a href' links in the red text below with an 'a class' property from an external css style sheet. I just can't seem to get it. I've tried the standard <a class id="contact" href='mailto:$getlist3'>$getlist3</a> , which would work in HTML, but because it's in php it doesn't. I've also tried adding a <div id="property"> around the <?php brackets but that doesn't work either. Also I can't seem to add a <div id="property"> class from the css style sheet to style the normal text in the 'Print' statment. This is what I have so far. Any help would be much appreciated! <?php include "../connect.php"; $getlist="SELECT * from mailing_list order by email ASC"; //select e-mails in ABC order $getlist2=mysql_query($getlist) or die("Could not get list"); ?> <table border="0"><tr id="heading"><td>Email...</td><td>Date Joined...</td><td>Validated...</td><td>Delete...</td></tr> <?php while($getlist3=mysql_fetch_array($getlist2)) { print "<tr><td><a href='mailto:$getlist3'>$getlist3</a></td><td>$getlist3[datejoined]</td><td>$getlist3[validated]</td><td><a href='deluser.php?ID=$getlist3[userID]'>Delete</a></td></tr>"; } ?> </table>