WatsonN

Almost Solved. I had spaces in my folder name. Took those out and fixed the cookie problem. Still wont update mysql. It has no errors, though.

I have part of my script that I have used many times in many diffrent applications that works just fine. But in this use it refuses to set the cookie or do anything besides the redirect for that matter. // if login is ok then we add a cookie $ip = $_SERVER['REMOTE_ADDR']; $datem = date("j F Y, g:i a"); mysql_query("UPDATE YBK_Login SET date = '$datem' AND ip = '$ip' WHERE ID = '{{$info['ID']}'")or die(mysql_error()); $_POST['username'] = stripslashes($_POST['username']); $hour = time() + 3600; setcookie('ID_WatsonN', $_POST['username'], 0); setcookie('Key_WatsonN', $_POST['pass'], 0); setcookie('UID_WatsonN', $info['ID'], 0); setcookie('LOGIN', $info['ID'], time()+3); //then redirect them to the members area Header("Location: dashboard.php");

@kickstart Thank you for this, it is exactly what I needed. Also, thank you for taking the time to write and explain it. Hopefully I will remember this and expand on it in the future.

Hello all, I have to mysql tables and I want to join them and count the amount of rows in one. I have two tables YBK_Login and YBK_Ads, what I want to do is join them together and select a user's ID from YBK_Login and see how many entries that user has posted in YBK_Ads. The common field from YBK_Login is ID and in YBK_Ads is UID. Also, if you could explain so I can learn from this that would be much appreciated. If you need me to be more specific please let me know. Thank you in advanced.

Add this header to your email script and it will allow html $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; This is a good article to show you how to do HTML and attachments. http://www.webcheatsheet.com/PHP/send_email_text_html_attachment.php#attachment

On the top of the site the profile button returns a 404 http://www.phpfreaks.com/forums//forums/index.php?action=profile

Thank you thorpe. That is exactly what I needed to know.

@tHud That is, Thank you. So when I want to upload that information into a new database would i just put the sql file in a mysql_query()?

I already use that, I was just seeing if there was an automated way i could write into a script.

I'll Check it out Thanks!

I'm looking for a way to download all the database information and upload it to a totally diffrent server. Is this possible? If so, where should I start. Thanks in advanced.

Perfect! Thank ya much

I tried to use curl and it will output the file but is it possible to to make it post the images and css? <?php if ($_GET['id'] == "templates") { $page = "templates.php"; } elseif ($_GET['id'] == "24") { $page = "http://proj.WatsonN.com/templates/24/html/"; } elseif ($_GET['id'] == "35") { $page = "http://proj.WatsonN.com/templates/35/html/index.html"; } elseif ($_GET['id'] == "36") { $page = "http://proj.WatsonN.com/templates/36/html/index.html"; } elseif ($_GET['id'] == "46") { $page = "http://proj.WatsonN.com/templates/46/index.html"; } elseif ($_GET['id'] == "263") { $page = "http://proj.WatsonN.com/templates/263/index.html"; } elseif ($_GET['id'] == "brownstone") { $page = "http://proj.WatsonN.com/templates/brownstone/"; } elseif ($_GET['id'] == "zionnarrow") { $page = "http://proj.WatsonN.com/templates/zionanrrow/"; } elseif ($_GET['id'] == "assiduous") { $page = "http://proj.WatsonN.com/templates/assiduous/"; } elseif ($_GET['id'] == "bedazzled") { $page = "http://proj.WatsonN.com/templates/bedazzled/"; } elseif ($_GET['id'] == "boosting") { $page = "http://proj.WatsonN.com/templates/boosting/"; } elseif ($_GET['id'] == "cellulose") { $page = "http://proj.WatsonN.com/templates/cellulose/"; } elseif ($_GET['id'] == "component") { $page = "http://proj.WatsonN.com/templates/component/"; } elseif ($_GET['id'] == "concurrence") { $page = "http://proj.WatsonN.com/templates/concurrence/"; } elseif ($_GET['id'] == "customary") { $page = "http://proj.WatsonN.com/templates/customary/"; } elseif ($_GET['id'] == "familiar") { $page = "http://proj.WatsonN.com/templates/familiar/"; } elseif ($_GET['id'] == "gestured") { $page = "http://proj.WatsonN.com/templates/gestured/"; } elseif ($_GET['id'] == "implied") { $page = "http://proj.WatsonN.com/templates/implied/"; } elseif ($_GET['id'] == "indicator") { $page = "http://proj.WatsonN.com/templates/indicator/"; } elseif ($_GET['id'] == "lilypads") { $page = "http://proj.WatsonN.com/templates/lilypads/"; } elseif ($_GET['id'] == "offlimits") { $page = "http://proj.WatsonN.com/templates/offlimits/"; } elseif ($_GET['id'] == "offrecord") { $page = "http://proj.WatsonN.com/templates/offrecord/"; } elseif ($_GET['id'] == "reckoning") { $page = "http://proj.WatsonN.com/templates/reckoning/"; } elseif ($_GET['id'] == "refresh") { $page = "http://proj.WatsonN.com/templates/refresh/"; } elseif ($_GET['id'] == "smallwindow") { $page = "http://proj.WatsonN.com/templates/smallwindow/"; } elseif ($_GET['id'] == "solutions") { $page = "http://proj.WatsonN.com/templates/solutions/"; } elseif ($_GET['id'] == "soothing") { $page = "http://proj.WatsonN.com/templates/soothing/"; } elseif ($_GET['id'] == "substantial") { $page = "http://proj.WatsonN.com/templates/substantial/"; } elseif ($_GET['id'] == "wellness") { $page = "http://proj.WatsonN.com/templates/wellness/"; } elseif ($_GET['id'] == "woodenly") { $page = "http://proj.WatsonN.com/templates/woodenly/"; } elseif ($_GET['id'] == "equivalency") { $page = "http://proj.WatsonN.com/templates/equivalency/"; } else { $page = "welcome.php"; } if ($_GET['id'] == "templates") { ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>Template Preview - Nathan Watson</title> <meta name="keywords" content="xhtml css free templates layouts" /> <link rel="stylesheet" type="text/css" href="style.css" /></head> <body> <div id="header_lite"> <div id="header_inner_lite" class="fluid"> <div id="logo"> <a href="http://proj.WatsonN.com/"> <img src="images/logo.gif" alt="Nathan Watson inc." /></a> </div> <div id="menu"> <ul> <li><a href="mailto:[email protected]">E-mail Nathan</a></li> </ul> </div> </div> </div> <a href="?id=24">24</a><br> <a href="?id=35">35</a><br> <a href="?id=36">36</a><br> <a href="?id=46">46</a><br> <a href="?id=263">263</a><br> <a href="?id=brownstone">brownstone</a><br> <a href="?id=zionnarrow">zionnarrow</a><br> <a href="?id=assiduous">assiduous</a><br> <a href="?id=bedazzled">bedazzled</a><br> <a href="?id=boosting">boosting</a><br> <a href="?id=cellulose">cellulose</a><br> <a href="?id=component">componet</a><br> <a href="?id=concurrence">concurrence</a><br> <a href="?id=customary">customary</a><br> <a href="?id=familiar">familiar</a><br> <a href="?id=gestured">gestured</a><br> <a href="?id=implied">implied</a><br> <a href="?id=indicator">indicat</a><br> <a href="?id=lilypads">lilypads</a><br> <a href="?id=offlimits">offlimits</a><br> <a href="?id=offrecord">offrecord</a><br> <a href="?id=reckoning">reckoning</a><br> <a href="?id=refresh">refresh</a><br> <a href="?id=smallwindow">smallwindow</a><br> <a href="?id=solutions">solutions</a><br> <a href="?id=soothing">soothing</a><br> <a href="?id=substantial">substantial</a><br> <a href="?id=wellness">wellness</a><br> <a href="?id=woodenly">woodenly</a><br> <a href="?id=equivalency">equivalency</a><br> </body> </html> <?php } elseif (isset($_GET['id'])) { ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>Project Preview ~ Nathan Watson</title> <link rel="stylesheet" type="text/css" href="/style.css" /> </head> <?php include ("x.php"); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $page); curl_setopt ($ch, CURLOPT_COOKIEJAR, 'cookie.txt'); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($ch); curl_close($ch); echo $response; ?> </html> <? } else { ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>Template Preview - Nathan Watson</title> <meta name="keywords" content="xhtml css free templates layouts" /> <link rel="stylesheet" type="text/css" href="style.css" /></head> <body> <div id="header_lite"> <div id="header_inner_lite" class="fluid"> <div id="logo"> <a href="http://proj.WatsonN.com/"> <img src="images/logo.gif" alt="Nathan Watson inc." /></a> </div> <div id="menu"> <ul> <li><a href="mailto:[email protected]">E-mail Nathan</a></li> </ul> </div> </div> </div> <center> <h1>Please use the link provided to you to access these pages</h1> <br><br><br> <h3> <a href="http://WatsonN.com" target="top">Nathan Watson</a> </h3> </center> </body> </html> <?php } ?> I'm just trying to avoid iframes, as I hate them.

In my script it is supposed to display the info in the VIEW is set to 2. But since i put the if 'UL' > 3 above it it will only display the else and I'm not sure why it is doing this. $view = mysql_query("SELECT * FROM YBK_Login WHERE `ID` = '{$_COOKIE['UID_WatsonN']}'") or die(mysql_error()); while($infos = mysql_fetch_array( $view )) If ($infos['UL'] > "3") { Print' <form action="post.php" method="post"> <select name="view"> <option value="1">User</option> <option value="2" SELECTED>Admin</option> </select> <input type="submit" value="Set View" name="admin-view"> </form>'; } If ($infos['VIEW'] == "2") { $data = mysql_query("SELECT * FROM YBK_Ads WHERE `delete` = '0' ORDER BY ID LIMIT $offset, $rowsperpage") or die(mysql_error()); while($info = mysql_fetch_array( $data )) { $ID = $info['ID']; ?> <div id="content"> <div class="post"><a name="<?php Print $ID; ?>"> <h2 class="title"><a href="#<?php Print $ID; ?>"><?php Print $info['BSN']; ?></a></h2> <p class="meta"><span class="author"><a href="/user?UID=<?php Print $info['UID']; ?>"><?php Print "By: ".$info['UID']; ?></a></span> <span class="date"><?php Print $info['Date']; ?></span> <span class="links"><a href="#<?php Print $ID; ?>" title="">Ad ID: <?php Print $ID; ?> </a><br> <form name="YBK-payment" action="post.php" method="post"> <input type="hidden" name="ID" value="<?php Print $ID ?>"> <select name="status"> <option value="Not Sent">Not Sent</option> <option value="Bill Sent" SELECTED>Bill Sent</option> <option value="Check to be cashed">Check TBC</option> <option value="Paid">Paid</option> <option value="Temporarily Declined">T Decl</option> <option value="Permanently Declined">P Decl</option> <option value="Delete">Delete</option> </select> </select> <input type="submit" value="Update Status" name="payment"> </form> </ul><br> <?php Print "Payment Status: <b>".$info['payment'] . "</b>"; ?> </span></p> <div class="entry"> <form id="form_25488_2" method="post" action="http://ybk.watsonn.com/post-add.php"><input type="hidden" name="id" value="<?php echo $ID; ?>"> <ul > <li id="li_7" > <label class="description" for="element_7">Contact Name </label> <span> <input id="element_7_1" name= "element_7_1" class="element text" maxlength="255" size="8" value="<?php echo $info['CNF']; ?>"/> <label>First</label> </span> <span> <input id="element_7_2" name= "element_7_2" class="element text" maxlength="255" size="14" value="<?php echo $info['CNL']; ?>"/> <label>Last</label> </span> </li> <li id="li_2" > <label class="description" for="element_2">Address </label> <div> <input id="element_2" name="element_2" class="element text medium" type="text" maxlength="255" value="<?php echo $info['ADD']; ?>"/> </div> </li> <li id="li_3" > <label class="description" for="element_3">City </label> <div> <input id="element_3" name="element_3" class="element text medium" type="text" maxlength="255" value="<?php echo $info['CITY']; ?>"/> </div> </li> <li id="li_4" > <label class="description" for="element_4">State </label> <div> <input id="element_4" name="element_4" class="element text medium" type="text" maxlength="255" value="<?php echo $info['STATE']; ?>"/> </div> </li> <li id="li_5" > <label class="description" for="element_5">Zip </label> <div> <input id="element_5" name="element_5" class="element text medium" type="text" maxlength="255" value="<?php echo $info['ZIP']; ?>"/> </div> </li> <li id="li_5" > <label class="description" for="element_5">Declined Ad </label> <div> <input id="element_5" name="DCL" class="element text medium" type="text" maxlength="3" value="<?php echo $info['DCL']; ?>"/> </div> </li> <li id="li_5" > <label class="description" for="element_5">Call Back Next Year </label> <div> <input id="element_5" name="CB" class="element text medium" type="text" maxlength="3" value="<?php echo $info['CB']; ?>"/> </div> </li> <li id="li_10" > <?php Print "Type of Ad:<b> ".$info['ToA'] . "</b><br>"; ?> <li id="li_13" > <label class="description" for="element_13">Ad Size </label> <span> <input id="element_13" name="element_13" class="element radio" type="text" value="<?php echo $info['AS']; ?>" /><br> <small>1/8 1/4 1/2 Full</small></p> </span> </li> <li id="li_11" > <label class="description" for="element_11">Payment Type </label> <span> <input id="element_11" name="element_11" class="element radio" type="text" value="<?php echo $info['PT']; ?>" /> </span> </li> <li id="li_6" > <label class="description" for="element_6">Check Number (If Applicable) </label> <div> <input id="element_6" name="element_6" class="element text medium" type="text" maxlength="255" value="<?php echo $info['CN']; ?>"/> </div> </li> <li id="li_12" > <label class="description" for="element_12">Buying a Yearbook </label> <span> <input id="element_12_1" name="element_12" class="element radio" type="text" value="<?php echo $info['BY']; ?>" /> </span> </li> <li id="li_8" > <label class="description" for="element_8">Ad Copy • Artwork/Photo Instructions </label> <div> <textarea COLS="45" ROWS="5" style="overflow: visible; white-space: wrap;" id="element_8" name="element_8" class="element textarea medium"><?php echo stripslashes($info['ACI']); ?></textarea> </div><p class="guidelines" id="guide_8"><small>Artwork needs to be black or a dark color on a white background</small></p> <p></p> <dd><dd> <a href="image?id=<?php Print $ID ?>">Upload an image</a><? Print " "; Print $info['image'] ?> </li> <?php Print "<li>Talked to Ad Manager:<b> ".$info['TAM'] . "</b><br></li>"; Print "<li>Left A Voicemail: <b>".$info['VM'] . "</b><br></li>"; ?> <input type="submit" name="Update" value="Update" /> </ul> </form> </div> <?php } ?> </div> <?php } else { $data = mysql_query("SELECT * FROM YBK_Ads WHERE `delete` = '0' ORDER BY ID LIMIT $offset, $rowsperpage") or die(mysql_error()); while ($info = mysql_fetch_assoc($data)) { $ID = $info['ID']; ?> <div id="content"> <div class="post"><a name="<?php Print $ID; ?>"> <h2 class="title"><a href="#<?php Print $ID; ?>"><?php Print $info['BSN']; ?></a></h2> <p class="meta"><span class="author"><a href="/user?UID=<?php Print $info['UID']; ?>"><?php Print "User ID: ".$info['UID']; ?></a></span> <span class="date"><?php Print $info['Date']; ?></span> <span class="links"><a href="#<?php Print $ID; ?>" title="">Ad ID: <?php Print $ID; ?> </a><br> </ul><br> <?php Print "Payment Status: <b>".$info['payment'] . "</b>"; ?> </span></p> <div class="entry"> <p>Contact Name: <?php Print "<b>" . $info['CNF'] ." " . $info['CNL'] . "</b><br>";?> <?php Print "Address: <b>".$info['ADD'] . "</b><br>"; Print "City: <b>".$info['CITY'] . "</b><br>"; Print "State:<b> ".$info['STATE'] . "</b><br>"; Print "Zip:<b> ".$info['ZIP'] . "<br></b>"; Print "Declined Ad:<b> ".$info['DCL'] . "<br></b>"; Print "Call Back Next Year:<b> ".$info['CB'] . "<br></b>"; Print "Type of Ad:<b> ".$info['ToA'] . "</b><br>"; Print "Ad Size:<b> ".$info['AS'] . "<br></b>"; Print "Payment Type:<b> ".$info['PT'] . "</b><br>"; Print "Check Number:<b> ".$info['CN'] . "</b><br>"; Print "Buying a yearbook:<b> ".$info['BY'] . "</b><br>"; Print "Ad Copy • Artwork/Photo Instructions:<b><pre> ".stripslashes($info['ACI']) . "</pre></b><br>"; Print "Image: <b>" . $info['image'] . "</b><br>"; Print "Talked to Ad Manager:<b> ".$info['TAM'] . "</b><br>"; Print "Left A Voicemail: <b>".$info['VM'] . "</b><br>"; ?> </p> </div> <?php } ?> </div> <?php }

Thank you I did that and it sends the code itself instead of formatting it. What do i need to chnge? // ---------------- SEND MAIL FORM ---------------- $to="[email protected]"; $subject="Weekly user report!"; $header="from: Yearbook Ads <[email protected]>"; $headers .= "X-Mailer: NLW\n"; $headers .= "X-Priority: 1\n"; $headers .= "Return-Path: [email protected] \n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $messages= "Here is the weekly report of all users and the ads sold. . . \r\n"; $messages .= $data; $sentmail = mail($to,$subject,$messages,$header); ?>

I am trying to print the contents of my database into mail function and send it but i'm not sure how this is done. i already have the code to print all the data needed, I just don't know how to get it into the e-mail <?php // Connects to your Database mysql_connect(***) or die(mysql_error()); mysql_select_db("loginwatsonn") or die(mysql_error()); ?> <p>Yearbook Users</p> <table class="listing" cellpadding="0" cellspacing="0"> <tr> <th>ID </th> <th>UID </th> <th>Ads Sold </th> <th>mail </th> <th>Allowed </th> </tr> <tr> <?php $data = mysql_query("SELECT y.*,COUNT(ads.UID) AS posts FROM YBK_Login AS y LEFT JOIN YBK_Ads AS ads ON ads.UID=y.ID GROUP BY y.ID") or die(mysql_error()); while($info = mysql_fetch_array( $data )) { Print "<tr>"; Print "<td>".$info['ID'] . " </td>"; Print "<td>".$info['UID'] . "</td> "; Print "<td> ".$info['posts'] . " </td>"; Print "<td>".$info['mail'] . " </td>"; Print "<td> ".$info['Allowed'] . "</td>"; } ?></tr></table><br><br>

using full paths i get the error Warning: include(/home/content/n/a/t/nathanwatson/html/projects/24/) [function.include]: failed to open stream: Inappropriate ioctl for device in /home/content/n/a/t/nathanwatson/html/projects/index.php on line 23 Warning: include() [function.include]: Failed opening '/home/content/n/a/t/nathanwatson/html/projects/24/' for inclusion (include_path='.:/usr/local/php5/lib/php') in /home/content/n/a/t/nathanwatson/html/projects/index.php on line 23

I'll try full paths @Pikachu2000 Yes they are all there.

I have the code: <?php if ($_GET['id'] == "24") { $page = "/24/"; } elseif ($_GET['id'] == "35") { $page = "/35/html/index.html"; } elseif ($_GET['id'] == "36") { $page = "/36/html/index.html"; } elseif ($_GET['id'] == "46") { $page == "/46/index.html"; } elseif ($_GET['id'] == "263") { $page = "/263/index.html"; } else { $page = "welcome.php"; } ?> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>Page Preview - Nathan Watson</title> <link rel="stylesheet" type="text/css" href="/style.css" /> </head> <?php include("x.php"); include($page); ?> but when I use an id it gives me the error Warning: include(/263/index.html) [function.include]: failed to open stream: No such file or directory in /home/content/n/a/t/nathanwatson/html/projects/index.php on line 23 Warning: include() [function.include]: Failed opening '/263/index.html' for inclusion (include_path='.:/usr/local/php5/lib/php') in /home/content/n/a/t/nathanwatson/html/projects/index.php on line 23 And I have absolutely no idea why

I have a script to let the user update their password, when I submit it i get a 500 error and I'm not sure. Here is the code: If (isset($_POST['update-password'])) { //This makes sure they did not leave any fields blank if (!$_POST['oldpw'] || !$_POST['pass'] || !$_POST['pass2'] ) { $error="<span style="; $error .="color:red"; $error .=">"; $error .= "You did not complete all of the required fields"; $error .="</span>"; setcookie('Errors', $error, time()+20); header('Location /useredit.php'); exit; } // checks if the password is correct $pass = md5($_POST['pass']); if (!get_magic_quotes_gpc()) { $pass = addslashes($pass); } $check = mysql_real_escape_string("SELECT * FROM YBK_Login WHERE pass = '{$pass}'"); mysql_query($check) or die( 'Query string: ' . $check . '<br />Produced an error: ' . mysql_error() . '<br />' ); // this makes sure both passwords entered match if ($_POST['pass'] != $_POST['pass2']) { $error="<span style="; $error .="color:red"; $error .=">"; $error .= 'Your passwords did not match.'; $error .="</span>"; setcookie('Errors', $error, time()+20); header('Location: /useredit.php'); exit; } // here we encrypt the password and add slashes if needed $_POST['pass'] = md5($_POST['pass']); if (!get_magic_quotes_gpc()) { $_POST['pass'] = addslashes($_POST['pass']); $_POST['pass2'] = addslashes($_POST['pass2']); } // now we insert it into the database mysql_real_escape_string($insert = "UPDATE `YBK_Login` SET `pass` = '{$_POST['pass']}', `HR` = '{$_POST['pass2']}', `comment` = '{$_POST['oldpw']}' WHERE `ID` = {$_COOKIE['UID_WatsonN']}"); mysql_query($insert) or die( 'Query string: ' . $insert . '<br />Produced an error: ' . mysql_error() . '<br />' ); $error="<span style="; $error .="color:green"; $error .=">"; $error .= "<p>Thank you, your password has been updated.</p>"; $error .="</span>"; setcookie('Errors', $error, time()+20); header('Location: /useredit.php'); exit; }

Thank yall much, figured it out. . . So far

Well yeah, but is there a way you can make a form look like a link?

I have a piece of code: Print "<li><a href=\"biz?UID=".$info['ID'].'">'.$info['BSN']. "</a></li>"; What I want it to do is use POST instead of get but i'm mot sure how to achieve this. Is this even possible? This page: <?php $data = mysql_query("SELECT * FROM YBK_Ads WHERE `delete` = '0' ORDER BY CNL") or die(mysql_error()); while($info = mysql_fetch_array( $data )) { Print "<li><a href=\"biz?UID=".$info['ID'].'">'.$info['BSN']. "</a></li>"; Print '<li>'." &#45;".$info['CNL'] . ", <em> " . $info['CNF'] . "</em></li>"; } ?> Page sent to: <div id="biz"> <div class="toolbar"> <h1>Contact Information</h1> <a href="#" class="back">Back</a> </div> <ul class="edgetoedge"> <?php $data = mysql_query("SELECT * FROM `YBK_Ads` WHERE `UID` = '{$_GET['UID']}' and `delete` = '0'") or die(mysql_error()); while($info = mysql_fetch_array( $data )) { Print $info['BSN']; Print "Payment Status: <b>".$info['payment'] . "</b>"; ?> <p><li> &#45;Contact Name: <?php Print "<b>" . $info['CNF'] ." " . $info['CNL'] . "</b></a></li>";?> <?php Print "<li> &#45;Address: <b>".$info['ADD'] . "</b></a></li>"; Print "<li> &#45;City: <b>".$info['CITY'] . "</b></a></li>"; Print "<li> &#45;State:<b> ".$info['STATE'] . "</b></a></li>"; Print "<li> &#45;Zip:<b> ".$info['ZIP'] . "<br></b>"; Print "<li> &#45;Declined Ad:<b> ".$info['DCL'] . "<br></b>"; Print "<li> &#45;Call Back Next Year:<b> ".$info['CB'] . "<br></b>"; Print "<li> &#45;Type of Ad:<b> ".$info['ToA'] . "</b></a></li>"; Print "<li> &#45;Ad Size:<b> ".$info['AS'] . "<br></b>"; Print "<li> &#45;Payment Type:<b> ".$info['PT'] . "</b></a></li>"; Print "<li> &#45;Check Number:<b> ".$info['CN'] . "</b></a></li>"; Print "<li> &#45;Buying a yearbook:<b> ".$info['BY'] . "</b></a></li>"; Print "<li> &#45;Ad Copy • Artwork/Photo Instructions:<b> ".stripslashes($info['ACI']) . "</b></a></li>"; Print "<li> &#45;Talked to Ad Manager:<b> ".$info['TAM'] . "</b></a></li>"; Print "<li> &#45;Left A Voicemail: <b>".$info['VM'] . "</b></a></li>"; } ?> </ul> </div>

I fixed it by creating a new user and posting all deleted posts to that user so they don't show up under other people. I will keep looking at this and if I find something I will post back. But, for now SOLVED! Because the original problem was solved. Thank yall so much for the help

Nope, even out of quotes it still does the same thing