[SOLVED] mysql db editing.

cloudy243 · April 10, 2009

I have a sort of complex script that i was hoping everyone could look at and follow. the script is

<?php
if (@$_SESSION['auth'] != "yes") {
echo "Please Login.";
}
else {
$security_code = rand();
$name = @$_SESSION['logname'];
$_SESSION['security']=$security_code;
$_SESSION['post_check']=rand();
$host = "localhost";
$user = "NOT SHOWN";
$pass = "NOT SHOWN";
$base = "wizll_forumzmembers";
$cxn = mysqli_connect($host,$user,$pass,$base)
		or die ("Connection failed");
$sql = "SELECT * FROM posts ORDER BY position";
$result = mysqli_query($cxn,$sql)
		or die ("Query failed");
while($row = mysqli_fetch_array($result)) {
echo '<table  width="100%" border="1">';
echo '<tr><td width="20%">';
echo "<center>";
echo $row['user'];
echo "</center>";
echo '</td><td width="80%">';
echo "Subject: ";
echo $row['subject'];
echo '</td></tr><tr><td>';
echo "<center>";
if ($row['rank'] == 10) {
echo '<img src="pictures/buttons/admin.png" alt="">';
}
if ($row['rank'] == 9) {
echo '<img src="pictures/buttons/admin.png" alt="">';
}
if ($row['rank'] ==  {
echo '<img src="pictures/buttons/mod.png" alt="">';
}
$num_posts = $row['posts'];
echo "<br>Posts:$num_posts";
echo "</center>";
echo "</td><td>";
$post_put = nl2br($row['post']);
echo '<div id="post">';
echo $post_put;
echo '</div>';
echo "</td></tr><tr><td>";
echo "Posted: ";
echo $row['post_time'];
echo "</td><td>";
// make is so when you click edit/quote it will edit/quote that post, not the last post on that page
echo '<script type="text/javascript" language="javascript">';
echo 'function quote()
{
   var old_post = "[quote]" + "';
   echo $row['user'];
   echo '[br]" + "';
   echo $row['post'];
   echo '" + "[/quote]";
   var MyElement = document.getElementById("post");
   MyElement.value = old_post;
}
</script>';
echo '<img src="pictures/buttons/quote.png" alt="" onclick="quote()"><img src="pictures/buttons/PM.png" alt="">';
$name_3 = @$_SESSION['logname'];
if ($row['user'] == $name_3) {
//make it so it deletes the old post you are editing
echo '<script type="text/javascript" language="javascript">';
echo 'function edit()
{
   var old_post = "';
   echo $row['post'];
   echo '";
   var MyElement = document.getElementById("post");
   MyElement.value = old_post;
   var override = "';
   $override = "true";
   $position_override = $row['position'];
   echo $override;
   echo '";
   var position_override = "';
   echo $position_override;
   echo '";
   var MyElement = document.getElementById("override");
   MyElement.value = override;
   var MyElement = document.getElementById("position_override");
   MyElement.value = position_override;
}
</script>';
echo '<img src="pictures/buttons/edit.png" alt="" onclick="edit()">';
}
echo "</td></tr>";
echo "</table>";
echo "<br>";
}
echo '<br />
<form action="posted.php" method="post">
Quick Post: <br>
Subject:
<input type="textbox" name="post_subject" value=""><br>
<img src="pictures/buttons/img.png" alt="" onclick="img()">
<img src="/forumz/pictures/buttons/smiley.png" name="smilies_show" id="smilies_show" onclick="show_buttons(smilies);">
<img src="pictures/buttons/code.png" alt="" onclick="code()">
<img src="pictures/buttons/url.png" alt="" onclick="link()"><br />
<textarea rows="9" name="post_box" id="post_box" cols="90"></textarea> <br />
<input type="hidden" name="security_code" value="';
echo $security_code;
echo '" /> <input type="hidden" name="override" id="override" value=""><input type="hidden" name="position_override" id="position_override" value=""><input type="submit" value="Post" />
</form>
<form action="post.php" method="post">
<input type="submit" value="Go Advanced" />';
}
?>

The problem is when you try to edit/quote a post it always selects the last post to put in the text box and not the one of which the button you clicked. How do i fix this. If you need a live demo visit http://www.forumzbb.com/forumz/

briant · April 10, 2009

There are some echos you haven't closed with a semi colon. You don't have to echo every line of html/javascript you have. For print you do but the beauty of echo is you can have as many lines in side as you like.

schilly · April 10, 2009

my js isn't that great but i think you are declaring your quote fn numerous times so when you actually call it, it only uses the last one. make one fn and just pass in the quote string.

cloudy243 · April 10, 2009

how would i go about doing that what would the code be? Also the javascript has to be ran for each post because it is getting each post one at a time, not just the same thing every time. It is suppose to get a different thing each time, but it isnt.

cloudy243 · April 10, 2009

I have a new index.php. Here it is, but it is still broken.

<?
include_once("global/css.php");
?>
<script type="text/javascript" language="javascript">

function img()
{
   var post=prompt("Please enter the image link","http://");
   var MyElement = document.getElementById("post_box");
   MyElement.value = MyElement.value + "[img=" + post + "]";
}

function code()
{
   var code=prompt("Paste the code here.","");
   var MyElement = document.getElementById("post_box");
   MyElement.value = MyElement.value + "[code]" + code + "[/ccooddee]";
}

function link()
{
   var url=prompt("Please enter the url link.","http://");
   var urlpage=prompt("Please enter the text to be shown.","");
   var MyElement = document.getElementById("post_box");
   MyElement.value = MyElement.value + "[url=http://" + url + "]" + url + "[/url]" + "[urlpage]" + urlpage + "[/urlpage]";
}

function center()
{
   var cen=prompt("Please enter the centered text.","");
   var MyElement = document.getElementById("post_box");
   MyElement.value = MyElement.value + "[cen]" + cen + "[/cen]";
}

function bold()
{
   var b=prompt("Please enter the bold text.","");
   var MyElement = document.getElementById("post_box");
   MyElement.value = MyElement.value + "[b]" + b + "[/b]";
}

function italic()
{
   var i=prompt("Please enter the italic text.","");
   var MyElement = document.getElementById("post_box");
   MyElement.value = MyElement.value + "[i]" + i + "[/i]";
}

function underline()
{
   var u=prompt("Please enter the underlined text.","");
   var MyElement = document.getElementById("post_box");
   MyElement.value = MyElement.value + "[u]" + u + "[/u]";
}

function omg()
{
   var MyElement = document.getElementById("post_box");
   MyElement.value = MyElement.value + "[omg]";
}

function show_buttons(show) {

               if (show == 'smilies') {
               
                   document.getElementById('smile_1').style.visibility='visible';
                   document.getElementById('smile_2').style.visibility='visible';
                   document.getElementById('smile_3').style.visibility='visible';
                   document.getElementById('smile_4').style.visibility='visible';
                   document.getElementById('smile_5').style.visibility='visible';
                   document.getElementById('smile_6').style.visibility='visible';
                   document.getElementById('smile_7').style.visibility='visible';
                   document.getElementById('smile_8').style.visibility='visible';
                   document.getElementById('smile_9').style.visibility='visible';
                   document.getElementById('smile_10').style.visibility='visible';
                   document.getElementById('smile_11').style.visibility='visible';
                   document.getElementById('smile_12').style.visibility='visible';
                   document.getElementById('smile_13').style.visibility='visible';
                   document.getElementById('smile_14').style.visibility='visible';
                   document.getElementById('smile_15').style.visibility='visible';
                   document.getElementById('smile_16').style.visibility='visible';
                   document.getElementById('smile_17').style.visibility='visible';
                   document.getElementById('smile_18').style.visibility='visible';
                   document.getElementById('smile_19').style.visibility='visible';
                   document.getElementById('smile_20').style.visibility='visible';
                   document.getElementById('smile_21').style.visibility='visible';
                   document.getElementById('smile_22').style.visibility='visible';
                   document.getElementById('smile_23').style.visibility='visible';
                   document.getElementById('smile_24').style.visibility='visible';
                   document.getElementById('smile_25').style.visibility='visible';
                   document.getElementById('smile_26').style.visibility='visible';
                   document.getElementById('smile_27').style.visibility='visible';
                   document.getElementById('smile_28').style.visibility='visible';
                   document.getElementById('smile_29').style.visibility='visible';
                   document.getElementById('smile_30').style.visibility='visible';
                   document.getElementById('smile_31').style.visibility='visible';
                   document.getElementById('smile_32').style.visibility='visible';
                   document.getElementById('smile_33').style.visibility='visible';
                   document.getElementById('smile_34').style.visibility='visible';
                   document.getElementById('smile_35').style.visibility='visible';
                   document.getElementById('smile_36').style.visibility='visible';
                   document.getElementById('smile_37').style.visibility='visible';
                   document.getElementById('smile_38').style.visibility='visible';
                   document.getElementById('smile_39').style.visibility='visible';
                   document.getElementById('smile_40').style.visibility='visible';
                   document.getElementById('smile_41').style.visibility='visible';
                   
                } else {

                   document.getElementById('smile_1').style.visibility='hidden';
                   document.getElementById('smile_2').style.visibility='hidden';
                   document.getElementById('smile_3').style.visibility='hidden';
                   document.getElementById('smile_4').style.visibility='hidden';
                   document.getElementById('smile_5').style.visibility='hidden';
                   document.getElementById('smile_6').style.visibility='hidden';
                   document.getElementById('smile_7').style.visibility='hidden';
                   document.getElementById('smile_8').style.visibility='hidden';
                   document.getElementById('smile_9').style.visibility='hidden';
                   document.getElementById('smile_10').style.visibility='hidden';
                   document.getElementById('smile_11').style.visibility='hidden';
                   document.getElementById('smile_12').style.visibility='hidden';
                   document.getElementById('smile_13').style.visibility='hidden';
                   document.getElementById('smile_14').style.visibility='hidden';
                   document.getElementById('smile_15').style.visibility='hidden';
                   document.getElementById('smile_16').style.visibility='hidden';
                   document.getElementById('smile_17').style.visibility='hidden';
                   document.getElementById('smile_18').style.visibility='hidden';
                   document.getElementById('smile_19').style.visibility='hidden';
                   document.getElementById('smile_20').style.visibility='hidden';
                   document.getElementById('smile_21').style.visibility='hidden';
                   document.getElementById('smile_22').style.visibility='hidden';
                   document.getElementById('smile_23').style.visibility='hidden';
                   document.getElementById('smile_24').style.visibility='hidden';
                   document.getElementById('smile_25').style.visibility='hidden';
                   document.getElementById('smile_26').style.visibility='hidden';
                   document.getElementById('smile_27').style.visibility='hidden';
                   document.getElementById('smile_28').style.visibility='hidden';
                   document.getElementById('smile_29').style.visibility='hidden';
                   document.getElementById('smile_30').style.visibility='hidden';
                   document.getElementById('smile_31').style.visibility='hidden';
                   document.getElementById('smile_32').style.visibility='hidden';
                   document.getElementById('smile_33').style.visibility='hidden';
                   document.getElementById('smile_34').style.visibility='hidden';
                   document.getElementById('smile_35').style.visibility='hidden';
                   document.getElementById('smile_36').style.visibility='hidden';
                   document.getElementById('smile_37').style.visibility='hidden';
                   document.getElementById('smile_38').style.visibility='hidden';
                   document.getElementById('smile_39').style.visibility='hidden';
                   document.getElementById('smile_40').style.visibility='hidden';
                   document.getElementById('smile_41').style.visibility='hidden';

                }

}
</script>
<?php
if (@$_SESSION['auth'] != "yes") {
echo "Please Login.";
}
else {
$security_code = rand();
$name = @$_SESSION['logname'];
$_SESSION['security']=$security_code;
$_SESSION['post_check']=rand();
$host = "localhost";
$user = "BLOCKED";
$pass = "BLOCKED";
$base = "wizll_forumzmembers";
$cxn = mysqli_connect($host,$user,$pass,$base)
		or die ("Connection failed");
$sql = "SELECT * FROM posts ORDER BY position";
$result = mysqli_query($cxn,$sql)
		or die ("Query failed");
while($row = mysqli_fetch_array($result)) {
echo '<table  width="100%" border="1">';
echo '<tr><td width="20%">';
echo "<center>";
echo $row['user'];
echo "</center>";
echo '</td><td width="80%">';
echo "Subject: ";
echo $row['subject'];
echo '</td></tr><tr><td>';
echo "<center>";
if ($row['rank'] == 10) {
echo '<img src="pictures/buttons/admin.png" alt="">';
}
if ($row['rank'] == 9) {
echo '<img src="pictures/buttons/admin.png" alt="">';
}
if ($row['rank'] ==  {
echo '<img src="pictures/buttons/mod.png" alt="">';
}
$num_posts = $row['posts'];
echo "<br>Posts:$num_posts";
echo "</center>";
echo "</td><td>";
$post_put = nl2br($row['post']);
echo '<div id="post">';
echo $post_put;
echo '</div>';
echo "</td></tr><tr><td>";
echo "Posted: ";
echo $row['post_time'];
echo "</td><td>";
// make is so when you click edit/quote it will edit/quote that post, not the last post on that page
// ask how on php freaks
echo '<script type="text/javascript" language="javascript">';
echo 'function quote()
{
   var old_post = "[quote]" + "';
   echo $row['user'];
   echo '[br]" + "';
   echo $row['post'];
   echo '" + "[/quote]";
   var MyElement = document.getElementById("post");
   MyElement.value = old_post;
}
</script>';
echo '<img src="pictures/buttons/quote.png" alt="" onclick="quote()"><img src="pictures/buttons/PM.png" alt="">';
$name_3 = @$_SESSION['logname'];
if ($row['user'] == $name_3) {
//make it so it deletes the old post you are editing
echo '<script type="text/javascript" language="javascript">';
echo 'function edit()
{
   var old_post = "';
   echo $row['post'];
   echo '";
   var MyElement = document.getElementById("post");
   MyElement.value = old_post;
   var override = "';
   $override = "true";
   $position_override = $row['position'];
   echo $override;
   echo '";
   var position_override = "';
   echo $position_override;
   echo '";
   var MyElement = document.getElementById("override");
   MyElement.value = override;
   var MyElement = document.getElementById("position_override");
   MyElement.value = position_override;
}
</script>';
echo '<img src="pictures/buttons/edit.png" alt="" onclick="edit()">';
}
echo "</td></tr>";
echo "</table>";
echo "<br>";
echo '
<br />
<form action="posted.php" method="post">
Quick Post: <br>
Subject:
<input type="textbox" name="post_subject" value=""><br>
<img src="pictures/buttons/img.png" alt="" onclick="img()">
<img src="/forumz/pictures/buttons/smiley.png" name="smilies_show" id="smilies_show" onclick="show_buttons(';
}
?>
'smilies'
<?
if (@$_SESSION['auth'] != "yes") {
echo "Please Login.";
}
else {
echo ');">
<img src="pictures/buttons/code.png" alt="" onclick="code()">
<img src="pictures/buttons/url.png" alt="" onclick="link()"><br />
<textarea rows="9" name="post_box" id="post_box" cols="90"></textarea> <br />
<input type="hidden" name="security_code" value="';
$security_code = @$_SESSION['security'];
echo $security_code;
echo ' "> <input type="hidden" name="override" id="override" value=""><input type="hidden" name="position_override" id="position_override" value=""><input type="submit" value="Post" />
</form>
<form action="post.php" method="post">
<input type="submit" value="Go Advanced">
<table id="Table_02" width="100%" height="65" border="0" cellpadding="0" cellspacing="0">
<tr>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_1" id="smile_1" width="30" heigh="30" onclick="omg()" style="visibility: hidden"> </td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_2" id="smile_2" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_3" id="smile_3" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_4" id="smile_4" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_5" id="smile_5" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_6" id="smile_6" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_7" id="smile_7" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_8" id="smile_8" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_9" id="smile_9" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_10" id="smile_10" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_11" id="smile_11" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_12" id="smile_12" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_13" id="smile_13" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_14" id="smile_14" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_15" id="smile_15" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_16" id="smile_16" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_17" id="smile_17" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_18" id="smile_18" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_19" id="smile_19" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_20" id="smile_20" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_21" id="smile_21" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_22" id="smile_22" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_23" id="smile_23" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_24" id="smile_24" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_25" id="smile_25" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_26" id="smile_26" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_27" id="smile_27" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_28" id="smile_28" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_29" id="smile_29" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_30" id="smile_30" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_31" id="smile_31" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_32" id="smile_32" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_33" id="smile_33" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_34" id="smile_34" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_35" id="smile_35" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_36" id="smile_36" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_37" id="smile_37" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_28" id="smile_28" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_39" id="smile_39" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_40" id="smile_40" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>
	<td>
		<img src="pictures/smilies/omg.png" name="smile_41" id="smile_41" width="30" heigh="30" onclick="omg()" style="visibility: hidden"></td>

</tr>
</table> ';
}
}
?>

schilly · April 10, 2009

your quote fn is still in that while loop. i would do something like this out of your while loop with the rest of your js fns.


function quote(quote_id){
var post;
post = document.getElementById('post' + quote_id);
post = '[quote]' + post + '[\quote]';
document.getElementById.InnerHTML = post;
}

then use a counter in your while loop and append the number to the div tag post ie. <div id='post1'>. now all you do is just pass that number into the quotes fn. hope that helps

cloudy243 · April 10, 2009

what do i put for quote id?

schilly · April 10, 2009

<?php
if (@$_SESSION['auth'] != "yes") {
echo "Please Login.";
}
else {
$security_code = rand();
$name = @$_SESSION['logname'];
$_SESSION['security']=$security_code;
$_SESSION['post_check']=rand();
$host = "localhost";
$user = "NOT SHOWN";
$pass = "NOT SHOWN";
$base = "wizll_forumzmembers";
$cxn = mysqli_connect($host,$user,$pass,$base)
		or die ("Connection failed");
$sql = "SELECT * FROM posts ORDER BY position";
$result = mysqli_query($cxn,$sql)
		or die ("Query failed");
$post_count = 0;

while($row = mysqli_fetch_array($result)) {
echo '<table  width="100%" border="1">';
echo '<tr><td width="20%">';
echo "<center>";
echo $row['user'];
echo "</center>";
echo '</td><td width="80%">';
echo "Subject: ";
echo $row['subject'];
echo '</td></tr><tr><td>';
echo "<center>";
if ($row['rank'] == 10) {
echo '<img src="pictures/buttons/admin.png" alt="">';
}
if ($row['rank'] == 9) {
echo '<img src="pictures/buttons/admin.png" alt="">';
}
if ($row['rank'] ==  {
echo '<img src="pictures/buttons/mod.png" alt="">';
}
$num_posts = $row['posts'];
echo "<br>Posts:$num_posts";
echo "</center>";
echo "</td><td>";
$post_put = nl2br($row['post']);
echo '<div id="post' . $post_count . '">';
echo $post_put;
echo '</div>';
echo "</td></tr><tr><td>";
echo "Posted: ";
echo $row['post_time'];
echo "</td><td>";
// make is so when you click edit/quote it will edit/quote that post, not the last post on that page

//fn deleted

echo '<img src="pictures/buttons/quote.png" alt="" onclick="quote(' . $post_count . ')"><img src="pictures/buttons/PM.png" alt="">';
$name_3 = @$_SESSION['logname'];
if ($row['user'] == $name_3) {
//make it so it deletes the old post you are editing
echo '<script type="text/javascript" language="javascript">';
echo 'function edit()
{
   var old_post = "';
   echo $row['post'];
   echo '";
   var MyElement = document.getElementById("post");
   MyElement.value = old_post;
   var override = "';
   $override = "true";
   $position_override = $row['position'];
   echo $override;
   echo '";
   var position_override = "';
   echo $position_override;
   echo '";
   var MyElement = document.getElementById("override");
   MyElement.value = override;
   var MyElement = document.getElementById("position_override");
   MyElement.value = position_override;
}
</script>';
echo '<img src="pictures/buttons/edit.png" alt="" onclick="edit()">';
}
echo "</td></tr>";
echo "</table>";
echo "<br>";

$post_count++;
}
echo '<br />
<form action="posted.php" method="post">
Quick Post: <br>
Subject:
<input type="textbox" name="post_subject" value=""><br>
<img src="pictures/buttons/img.png" alt="" onclick="img()">
<img src="/forumz/pictures/buttons/smiley.png" name="smilies_show" id="smilies_show" onclick="show_buttons(smilies);">
<img src="pictures/buttons/code.png" alt="" onclick="code()">
<img src="pictures/buttons/url.png" alt="" onclick="link()"><br />
<textarea rows="9" name="post_box" id="post_box" cols="90"></textarea> <br />
<input type="hidden" name="security_code" value="';
echo $security_code;
echo '" /> <input type="hidden" name="override" id="override" value=""><input type="hidden" name="position_override" id="position_override" value=""><input type="submit" value="Post" />
</form>
<form action="post.php" method="post">
<input type="submit" value="Go Advanced" />';
}
?>

Ok added count variable to <div id='post#'> and also past the count variable into the onClick call for the quote function. That should put you on the right track. Your edit fn will probably need the same thing done to it.

cloudy243 · April 11, 2009

thanks i will try this and tell u guys if it works.

Sign In

[SOLVED] mysql db editing.

Recommended Posts

cloudy243

Link to comment

Share on other sites

briant

Link to comment

Share on other sites

schilly

Link to comment

Share on other sites

cloudy243

Link to comment

Share on other sites

cloudy243

Link to comment

Share on other sites

schilly

Link to comment

Share on other sites

cloudy243

Link to comment

Share on other sites

schilly

Link to comment

Share on other sites

cloudy243

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information