Jump to content

pocobueno1388

Members
 View Profile  See their activity

  • Posts

    3,369

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by pocobueno1388

  1. pocobueno1388
    Could you post your actual code? I think it does have something to do with double quotes vs single quotes. I have been playing around with it on my server.
  2. pocobueno1388
    You didn't do anything major wrong, so don't lose confidence over this. It was actually mainly your HTML, not your PHP. You closed your form twice for some reason, and the first one you closed before putting your submit button, so that input was cut off from the form. Then you had your opening <form> AFTER your title input, and that cut that off, so I had to move the <form> above it. Then you just had a few minor PHP mistakes. Just look back at what I changed and you will understand more Don't forget to press "solved" so no one comes into this thread thinking you still need help.
  3. pocobueno1388
    Okay, this HAS to work. I tested it, so I think it will. <?php session_start(); ?> <html> <link rel="stylesheet" href="includes/in.css" type="text/css"> <style type="text/css"> <!-- .style5 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold; } .style10 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; font-weight: bold; } .style11 { font-size: 10px} .style12 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; } --> </style> <?php include_once "includes/db_connect.php"; include_once"includes/functions.php"; logincheck(); $username=$_SESSION['username']; if ($_POST['open']) { $spt = strip_tags(trim($_POST['spt'])); $title = strip_tags(trim($_POST['title_insert'])); $cat = strip_tags($_POST['category']); if (empty($spt) && empty($title)) { echo "Fill in all fields."; } else { $query = "INSERT INTO `support` ( `writer`,`reply`,`read`,`ticket`,`time`,`title`,`category`) VALUES ('$username','0','0','$spt',NOW(),'$title','$cat')"; $result = mysql_query($query)or die($query.'<br>'.mysql_error()); echo '<p>'.$query.'<p>'; } } ?> <center> <table width="100%" border="0" cellspacing="2" cellpadding="0"> <tr> <td width="39%"> </td> <td width="52%"> </td> <td width="9%"> </td> </tr> <tr> <td><table width=100% align="center" cellpadding=2 cellspacing=0 rules=none class=thinline> <tr> <td height="17" align=center background=includes/grad.jpg><span class="style10"><font color=#FFFFFF>Ticket Information</font></span></td> </tr> <tr> <td><span class="style12"> Submit a Ticket to an Admin or a Mod, Bugs will be fixed as soon as we read the message and if it is very serious we will reward you. Money Bugs Only Not Typing Errors! </span> <p class="style12"> <font color=#CC0000>Warning</font>: Tickets may take up to 24 hours to be answered so please be patient. </td> </tr> </table> <br> <table width=100% height="38" border=1 align="center" cellpadding=2 cellspacing=0 bordercolor=black class=thinline> <tr> <td height="19" colspan=2 align=center background=includes/grad.jpg><span class="style5 style11 style12"><font color=#FFFFFF>Open tickets</font></span></td> </tr> <td align=center bgcolor="#494949" class=style12 style8> Name</td> <td align=center bgcolor="#494949" class=style12 style8> Tickets Closed </td> </tr> <tr> <?php /// add ticket ppl here $users_sup = array("1" => "WentWorth", "2" => "Mobsterkenny", "3" => "Trivium", ); $i = 1; while ($i < 4) { $upstats = mysql_query("SELECT amount FROM ticketinfo WHERE username='$users_sup[$i]'"); while ($getandpost = mysql_fetch_row($upstats)) { $total = $getandpost[0]; } echo "<tr><td><a href='profile.php?viewuser=$users_sup[$i]'>$users_sup[$i]</a></td> <td>$total</td></tr>"; $i++; } ?> </table></td> <td><table width=90% border=1 align=center cellpadding=1 cellspacing=1 bordercolor=black class="thinline"> <tr class=title> <td height="15" colspan="2" background=includes/grad.jpg><div align="center"><strong>Create Help Ticket </strong></div></td> </tr> <tr class=title> <td width="49%" height="15"><div align="center"><span class="style10">Topic Title</span></div></td> <td width="51%"> <form name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <div align="center"> <input name="title_insert" type="text" class="submit" style=width: size="60%"; > </div></td> </tr> <tr class=title> <td height="29"><div align="center"><strong>Category</strong></div></td> <td height="29"> <label> </label> <div align="center"> <select name="category"> <option value="Bug/Exploits Report" selected>Bug/Exploits Report</option> <option value="Duplicate Accounts Report">Duplicate Accounts Report</option> <option value="Scam Report">Scam Report</option> <option value="Scripter/Exploiter Report">Scripter/Exploiter Report</option> <option value="Credits Question">Credits Question</option> <option value="Other Question">Other Question</option> </select> </div> </td> </tr> <tr class=text> <td height="15" colspan="2" bgcolor="#494949"><div align="center"><span class="style10">Message</span></div></td> </tr> <tr class=sub> <td height="185" colspan="2"><div align="center"> <textarea name="spt" style="width: 98%; height: 175px" class="submit"></textarea> </div></td> </tr> <tr class=title> <td colspan="2"><div align="center"> <input name="open" type="submit" class="submit" style="background-color: #990000; bottom; background-repeat: repeat; border: 1; color: #FFFFFF; cursor: pointer; height: 20px; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000; border-bottom: 1px solid #000000; font-size: 7.5pt; font-weight: normal; font-colour:#FFFFFF; font-family: Verdana" value="Open Help Ticket"> <label></label> </div></td> </tr> </table></td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> </table> <br> </tr> </td> </tr> </table> <br> </form> <br>
  4. pocobueno1388
    Okay...this *should* work. <?php session_start(); ?> <html> <link rel="stylesheet" href="includes/in.css" type="text/css"> <style type="text/css"> <!-- .style5 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold; } .style10 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; font-weight: bold; } .style11 { font-size: 10px} .style12 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; } --> </style> <?php include_once "includes/db_connect.php"; include_once"includes/functions.php"; logincheck(); $username=$_SESSION['username']; if ($_POST['open']) { $spt = strip_tags(trim($_POST['spt'])); $title = strip_tags(trim($_POST['title_insert'])); $cat = strip_tags($_POST['category']); if (empty($spt) && empty($title)) { echo "Fill in all fields."; } else { $query = "INSERT INTO `support` ( `writer`,`reply`,`read`,`ticket`,`time`,`title`,`category`) VALUES ('$username','0','0','$spt',NOW(),'$title','$cat')"; $result = mysql_query($query)or die($query.'<br>'.mysql_error()); echo '<p>'.$query.'<p>'; } } ?> <center> <table width="100%" border="0" cellspacing="2" cellpadding="0"> <tr> <td width="39%"> </td> <td width="52%"> </td> <td width="9%"> </td> </tr> <tr> <td><table width=100% align="center" cellpadding=2 cellspacing=0 rules=none class=thinline> <tr> <td height="17" align=center background=includes/grad.jpg><span class="style10"><font color=#FFFFFF>Ticket Information</font></span></td> </tr> <tr> <td><span class="style12"> Submit a Ticket to an Admin or a Mod, Bugs will be fixed as soon as we read the message and if it is very serious we will reward you. Money Bugs Only Not Typing Errors! </span> <p class="style12"> <font color=#CC0000>Warning</font>: Tickets may take up to 24 hours to be answered so please be patient. </td> </tr> </table> <br> <table width=100% height="38" border=1 align="center" cellpadding=2 cellspacing=0 bordercolor=black class=thinline> <tr> <td height="19" colspan=2 align=center background=includes/grad.jpg><span class="style5 style11 style12"><font color=#FFFFFF>Open tickets</font></span></td> </tr> <td align=center bgcolor="#494949" class=style12 style8> Name</td> <td align=center bgcolor="#494949" class=style12 style8> Tickets Closed </td> </tr> <tr> <?php /// add ticket ppl here $users_sup = array("1" => "WentWorth", "2" => "Mobsterkenny", "3" => "Trivium", ); $i = 1; while ($i < 4) { $upstats = mysql_query("SELECT amount FROM ticketinfo WHERE username='$users_sup[$i]'"); while ($getandpost = mysql_fetch_row($upstats)) { $total = $getandpost[0]; } echo "<tr><td><a href='profile.php?viewuser=$users_sup[$i]'>$users_sup[$i]</a></td> <td>$total</td></tr>"; $i++; } ?> </table></td> <td><table width=90% border=1 align=center cellpadding=1 cellspacing=1 bordercolor=black class="thinline"> <tr class=title> <td height="15" colspan="2" background=includes/grad.jpg><div align="center"><strong>Create Help Ticket </strong></div></td> </tr> <tr class=title> <td width="49%" height="15"><div align="center"><span class="style10">Topic Title</span></div></td> <td width="51%"><div align="center"> <input name="title_insert" type="text" class="submit" style=width: size="60%"; > </div></td> </tr> <tr class=title> <td height="29"><div align="center"><strong>Category</strong></div></td> <td height="29"><form name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <label> </label> <div align="center"> <select name="category"> <option value="Bug/Exploits Report" selected>Bug/Exploits Report</option> <option value="Duplicate Accounts Report">Duplicate Accounts Report</option> <option value="Scam Report">Scam Report</option> <option value="Scripter/Exploiter Report">Scripter/Exploiter Report</option> <option value="Credits Question">Credits Question</option> <option value="Other Question">Other Question</option> </select> </div> </td> </tr> <tr class=text> <td height="15" colspan="2" bgcolor="#494949"><div align="center"><span class="style10">Message</span></div></td> </tr> <tr class=sub> <td height="185" colspan="2"><div align="center"> <textarea name="spt" style="width: 98%; height: 175px" class="submit"></textarea> </div></td> </tr> <tr class=title> <td colspan="2"><div align="center"> <input name="open" type="submit" class="submit" style="background-color: #990000; bottom; background-repeat: repeat; border: 1; color: #FFFFFF; cursor: pointer; height: 20px; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000; border-bottom: 1px solid #000000; font-size: 7.5pt; font-weight: normal; font-colour:#FFFFFF; font-family: Verdana" value="Open Help Ticket"> <label></label> </div></td> </tr> </table></td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> </table> <br> </tr> </td> </tr> </table> <br> </form> <br>
  5. pocobueno1388
    I love listening to artists that can actually sing and have a modern day sound. Christina Aguilera (favorite), Carrie Underwood, Kelly Clarkson, Mariah Carey I also listen to a few others that have some good songs Green Day, Three Days Grace, Linkin Park, AFI, Plain White T's, OneRepublic, Evanescence, Justin Timberlake, Daughtry, Maroon 5, Pink
  6. pocobueno1388
    Okay, just don't fill in your "id" field for the table. Do you have it set to auto-increment in the DB? Do this <?php $query = "INSERT INTO `support` ( `writer`,`reply`,`read`,`ticket`,`time`,`title`,`category`) VALUES ('$username','0','0','$spt',now(),'$title','$cat')"; $result = mysql_query($query)or die($query.'<br>'.mysql_error()); echo '<p>'.$query.'<p>'; ?>
  7. pocobueno1388
    Okay, do this and post what it gives you. <?php $query = "INSERT INTO `support` (`id`, `writer`,`reply`,`read`,`ticket`,`time`,`title`,`category`) VALUES ('','$username','0','0','$spt',now(),'$title','$cat')"; $result = mysql_query($query)or die($query.'<br>'.mysql_error()); echo '<p>'.$query.'<p>'; ?> Your id field should be empty...thats what you set it to be in the query. And the category variable should be $cat, not $category. I'm not sure whats going on with the $title var though.
  8. pocobueno1388
    Well, what is wrong with the insertion? Do you get an error? Make sure you uncomment the insert code, I accidentally posted it commented out, then I fixed it.
  9. pocobueno1388
    Change this <?php if ($_POST['open']) { $spt = $_POST['spt']; $title = $_POST['title']; $spt = strip_tags($spt); $title = strip_tags($title); $cat = strip_tags($_POST['category']); if ($spt == "" || $title == "") { echo "Fill in all fields."; } else { $query = "INSERT INTO `support` (`id`, `writer`,`reply`,`read`,`ticket`,`time`,`title`,`category`) VALUES ('','$username','0','0','$spt',now(),'$title','$category')"; $result = mysql_query($query)or die($query.'<br>'.mysql_error()); echo "Ticket has been submitted."; } } ?> To <?php if ($_POST['open']) { $spt = strip_tags(trim($_POST['spt'])); $title = strip_tags(trim($_POST['title'])); $cat = strip_tags($_POST['category']); if (empty($spt) && empty($title)) { echo "Fill in all fields."; } else if ($spt != "" || $title != "") { $query = "INSERT INTO `support` (`id`, `writer`,`reply`,`read`,`ticket`,`time`,`title`,`category`) VALUES ('','$username','0','0','$spt',now(),'$title','$category')"; $result = mysql_query($query)or die($query.'<br>'.mysql_error()); echo "Ticket has been submitted."; } } ?>
  10. pocobueno1388
    Huh? So did it fix it? If it did, don't forget to press solved.
  11. pocobueno1388
    So it is printing out how you want it, it's just not showing up in the right spot? If thats the case, then it's an HTML problem, not PHP. Throwing errors? What kind of errors? I'm just confused now
  12. pocobueno1388
    Try <?php session_start(); ?> <html> <link rel="stylesheet" href="includes/in.css" type="text/css"> <style type="text/css"> <!-- .style5 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold; } .style10 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; font-weight: bold; } .style11 { font-size: 10px} .style12 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; } --> </style> <?php include_once "includes/db_connect.php"; include_once"includes/functions.php"; logincheck(); $username=$_SESSION['username']; if ($_POST['open']) { $spt = $_POST['spt']; $title = $_POST['title']; $spt = strip_tags($spt); $title = strip_tags($title); $cat = strip_tags($_POST['category']); if ($spt == "" || $title == "") { echo "Fill in all fields."; } else if ($spt != "" || $title != "") { $query = "INSERT INTO `support` (`id`, `writer`,`reply`,`read`,`ticket`,`time`,`title`,`category`) VALUES ('','$username','0','0','$spt',now(),'$title','$category')"; $result = mysql_query($query)or die($query.'<br>'.mysql_error()); echo "Ticket has been submitted."; } } ?> <center> <table width="100%" border="0" cellspacing="2" cellpadding="0"> <tr> <td width="39%"> </td> <td width="52%"> </td> <td width="9%"> </td> </tr> <tr> <td><table width=100% align="center" cellpadding=2 cellspacing=0 rules=none class=thinline> <tr> <td height="17" align=center background=includes/grad.jpg><span class="style10"><font color=#FFFFFF>Ticket Information</font></span></td> </tr> <tr> <td><span class="style12"> Submit a Ticket to an Admin or a Mod, Bugs will be fixed as soon as we read the message and if it is very serious we will reward you. Money Bugs Only Not Typing Errors! </span> <p class="style12"> <font color=#CC0000>Warning</font>: Tickets may take up to 24 hours to be answered so please be patient. </td> </tr> </table> <br> <table width=100% height="38" border=1 align="center" cellpadding=2 cellspacing=0 bordercolor=black class=thinline> <tr> <td height="19" colspan=2 align=center background=includes/grad.jpg><span class="style5 style11 style12"><font color=#FFFFFF>Open tickets</font></span></td> </tr> <td align=center bgcolor="#494949" class=style12 style8> Name</td> <td align=center bgcolor="#494949" class=style12 style8> Tickets Closed </td> </tr> <tr> <?php /// add ticket ppl here $users_sup = array("1" => "WentWorth", "2" => "Mobsterkenny", "3" => "Trivium", ); $i = 1; while ($i < 4) { $upstats = mysql_query("SELECT amount FROM ticketinfo WHERE username='$users_sup[$i]'"); while ($getandpost = mysql_fetch_row($upstats)) { $total = $getandpost[0]; } echo "<tr><td><a href='profile.php?viewuser=$users_sup[$i]'>$users_sup[$i]</a></td> <td>$total</td></tr>"; $i++; } ?> </table></td> <td><table width=90% border=1 align=center cellpadding=1 cellspacing=1 bordercolor=black class="thinline"> <tr class=title> <td height="15" colspan="2" background=includes/grad.jpg><div align="center"><strong>Create Help Ticket </strong></div></td> </tr> <tr class=title> <td width="49%" height="15"><div align="center"><span class="style10">Topic Title</span></div></td> <td width="51%"><div align="center"> <input name="title" type="text" class="submit" style=width: size="60%"; > </div></td> </tr> <tr class=title> <td height="29"><div align="center"><strong>Category</strong></div></td> <td height="29"><form name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <label> </label> <div align="center"> <select name="category"> <option value="Bug/Exploits Report" selected>Bug/Exploits Report</option> <option value="Duplicate Accounts Report">Duplicate Accounts Report</option> <option value="Scam Report">Scam Report</option> <option value="Scripter/Exploiter Report">Scripter/Exploiter Report</option> <option value="Credits Question">Credits Question</option> <option value="Other Question">Other Question</option> </select> </div> </td> </tr> <tr class=text> <td height="15" colspan="2" bgcolor="#494949"><div align="center"><span class="style10">Message</span></div></td> </tr> <tr class=sub> <td height="185" colspan="2"><div align="center"> <textarea name="spt" style="width: 98%; height: 175px" class="submit"></textarea> </div></td> </tr> <tr class=title> <td colspan="2"><div align="center"> <input name="open" type="submit" class="submit" style="background-color: #990000; bottom; background-repeat: repeat; border: 1; color: #FFFFFF; cursor: pointer; height: 20px; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000; border-bottom: 1px solid #000000; font-size: 7.5pt; font-weight: normal; font-colour:#FFFFFF; font-family: Verdana" value="Open Help Ticket"> <label></label> </div></td> </tr> </table></td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> </table> <br> </tr> </td> </tr> </table> <br> </form> <br>
  13. pocobueno1388
    Well, instead of just having it echo "Error, query failed", have it tell you why. mysql_query($query) or die(mysql_error());
  14. pocobueno1388
    No...I don't want the code to the function. I want the code to where you are trying to USE the function.
  15. pocobueno1388
    You don't need this entire chunk of code <?php if ($cat == "Bug/Exploits Report") { $category="Bug/Exploits Report'"; } else if ($cat == "Duplicate Accounts Report") { $category="Duplicate Accounts Report"; } else if ($cat == "Scam Report") { $category="Scam Report"; } else if ($cat == "Scripter/Exploiter Report") { $category="Scripter/Exploiter Report"; } else if ($cat == "Credits Question") { $category="Credits Question"; } else if ($cat == "Other Question") { $category="Other Question"; ?> This line $cat = strip_tags($_POST['category']); will store the value. Here, I cleaned up the code a bit...see what this gives you. <?php session_start(); ?> <html> <link rel="stylesheet" href="includes/in.css" type="text/css"> <style type="text/css"> <!-- .style5 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold; } .style10 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; font-weight: bold; } .style11 { font-size: 10px} .style12 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; } --> </style> <?php include_once "includes/db_connect.php"; include_once"includes/functions.php"; logincheck(); $username=$_SESSION['username']; if ($_POST['open']) { $spt = $_POST['spt']; $title = $_POST['title']; $spt = strip_tags($spt); $title = strip_tags($title); $cat = strip_tags($_POST['category']); if ($spt == "" || $title == "") { echo "Fill in all fields."; } else if ($spt != "" || $title != "") { $query = "INSERT INTO `support` (`id`, `writer`,`reply`,`read`,`ticket`,`time`,`title`,`category`) VALUES ('','$username','0','0','$spt',now(),'$title','$category')"; $result = mysql_query($query)or die($query.'<br>'.mysql_error()); echo "Ticket has been submitted."; } } ?> <center> <table width="100%" border="0" cellspacing="2" cellpadding="0"> <tr> <td width="39%"> </td> <td width="52%"> </td> <td width="9%"> </td> </tr> <tr> <td><table width=100% align="center" cellpadding=2 cellspacing=0 rules=none class=thinline> <tr> <td height="17" align=center background=includes/grad.jpg><span class="style10"><font color=#FFFFFF>Ticket Information</font></span></td> </tr> <tr> <td><span class="style12"> Submit a Ticket to an Admin or a Mod, Bugs will be fixed as soon as we read the message and if it is very serious we will reward you. Money Bugs Only Not Typing Errors! </span> <p class="style12"> <font color=#CC0000>Warning</font>: Tickets may take up to 24 hours to be answered so please be patient. </td> </tr> </table> <br> <table width=100% height="38" border=1 align="center" cellpadding=2 cellspacing=0 bordercolor=black class=thinline> <tr> <td height="19" colspan=2 align=center background=includes/grad.jpg><span class="style5 style11 style12"><font color=#FFFFFF>Open tickets</font></span></td> </tr> <td align=center bgcolor="#494949" class=style12 style8> Name</td> <td align=center bgcolor="#494949" class=style12 style8> Tickets Closed </td> </tr> <tr> <?php /// add ticket ppl here $users_sup = array("1" => "WentWorth", "2" => "Mobsterkenny", "3" => "Trivium", ); $i = 1; while ($i < 4) { $upstats = mysql_query("SELECT amount FROM ticketinfo WHERE username='$users_sup[$i]'"); while ($getandpost = mysql_fetch_row($upstats)) { $total = $getandpost[0]; } echo "<tr><td><a href='profile.php?viewuser=$users_sup[$i]'>$users_sup[$i]</a></td> <td>$total</td></tr>"; $i++; } ?> </table></td> <td><table width=90% border=1 align=center cellpadding=1 cellspacing=1 bordercolor=black class="thinline"> <tr class=title> <td height="15" colspan="2" background=includes/grad.jpg><div align="center"><strong>Create Help Ticket </strong></div></td> </tr> <tr class=title> <td width="49%" height="15"><div align="center"><span class="style10">Topic Title</span></div></td> <td width="51%"><div align="center"> <input name="title" type="text" class="submit" style=width: size="60%"; > </div></td> </tr> <tr class=title> <td height="29"><div align="center"><strong>Category</strong></div></td> <td height="29"><form name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <label> </label> <div align="center"> <select name="category"> <option value="Bug/Exploits Report" selected>Bug/Exploits Report</option> <option value="Duplicate Accounts Report">Duplicate Accounts Report</option> <option value="Scam Report">Scam Report</option> <option value="Scripter/Exploiter Report">Scripter/Exploiter Report</option> <option value="Credits Question">Credits Question</option> <option value="Other Question">Other Question</option> </select> </div> </form></td> </tr> <tr class=text> <td height="15" colspan="2" bgcolor="#494949"><div align="center"><span class="style10">Message</span></div></td> </tr> <tr class=sub> <td height="185" colspan="2"><div align="center"> <textarea name="spt" style="width: 98%; height: 175px" class="submit"></textarea> </div></td> </tr> <tr class=title> <td colspan="2"><div align="center"> <input name="open" type="submit" class="submit" style="background-color: #990000; bottom; background-repeat: repeat; border: 1; color: #FFFFFF; cursor: pointer; height: 20px; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000; border-bottom: 1px solid #000000; font-size: 7.5pt; font-weight: normal; font-colour:#FFFFFF; font-family: Verdana" value="Open Help Ticket"> <label></label> </div></td> </tr> </table></td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> </table> <br> </tr> </td> </tr> </table> <br> </form> <br> Post any errors if there are any.
  16. pocobueno1388
    Well, post the entire code then. <td>’.formatText("nmF","First:").’</td> That is obviously not the entire line...there has to be an echo or print in there.
  17. pocobueno1388
    What is the error? This line mysql_query("INSERT INTO `support` (`id`, `writer`,`reply`,`read`,`ticket`,`time`,`title`,`category`) VALUES ('','$username','0','0','$spt',now(),'$title','$category');") or die (mysql_error()); Should be mysql_query("INSERT INTO `support` (`id`, `writer`,`reply`,`read`,`ticket`,`time`,`title`,`category`) VALUES ('','$username','0','0','$spt',now(),'$title','$category')") or die (mysql_error());
  18. pocobueno1388
    Show us more code that goes along with <td>’.formatText("nmF","First:").’</td> Also, what are the errors?
  19. pocobueno1388
    You never stated what the problem was...
  20. pocobueno1388
    I figured out whats wrong, for the "O" in $_POST, you are using a zero.
  21. pocobueno1388
    That isn't a normal dollar sign... if (isset($_P0ST['click'])){
  22. pocobueno1388
    Instead of if ($_POST) I would go with if (isset($_POST['submit']))
  23. pocobueno1388
    is it possible to switch a database from MyISAM to InnoDB without any issues? I can't help you with that question...I have no idea, I've never had to do it.
  24. pocobueno1388
    On the page that inserts the info, do a check to see if that row already exists in the DB...and give an error if it's already there. Once you do that, it should completely solve the problem.
  25. pocobueno1388
    Shouldn't the customerID field hold the customers ID from another table which is already unique? I don't know what the use would be to just put in any unique ID for that field....doesn't make any sense. But to answer your initial question, no...I'm pretty sure you can only have 1 auto-incremented field per table. You may be able to use mysql_insert_id() to get what you want done.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.