Multiple rows in mysql

Well first there's no use a parameter to pass in delete comment function.

$database->DeleteComment("del"); (in the call)

function DeleteProfileComment($del){ (in the class)

you can do this

$database->DeleteComment("del"); )

function DeleteProfileComment($del){ ()

Because $_GET is a superglobal and can be accesses from any where and any context.

just do this :


and no parameter for the function , that'll be enough.

Anyway that's not the problem that can work.

In fact the problem seems to be in the comment deleting link .

You use $data["id_comment"] but that was just a generic example, in fact you told be that you had an ID system for the comment but I've got no idea of how you get it just before that's why I put $data["id_comment"] as an example.
I assumed that you retrieved in the same query that retrieves the comments informations.
You should do so anyway, and change my example $data[« id_comment »] by the right value something like $req_user_postusername['something'] (something =>name of the id field)

Ask any question

you have lost me. i am confused on what you are saying. from the code that i put on here can you give me the code to put in?

here, see I replaced $data["id_comment"] in that part by $req_user_postusername['comment_id'].
But all is left to do, is replace comment_id by the real name of the ID field in the comment table. In fact I've got no idea of the name you gave to it in the database.
SO the right value will be in that link so that the right value will be passed $_GET["del"]

ok it will come up with the comment id number but when i click on delete it does nothing and comes up to http://www.gothicgreenwire.com/mycomments.php?del=114 and it says username not registured because it need to say http://www.gothicgreenwire.com/mycommen ... user=admin or what ever there username is.

here is the database php


here is the mycomments php

So no problem just add also this parameter in the target url :

still did not work. why wont you take a look on there http://www.gothicgreenwire.com

argh!
sorry it couldn't work,
I did not take you last script with $req_user_postusername['id']
I cannot test since can't login

try this :



by the way, you should put the user name in the url,
once it'll work you should think about session in PHP.

It's geting late here, I go to bed, I'll check this thread tomorow morning

here is the new code i added where you have to be loged in also but i still cant figure out why its not working.

noooooo !

The new code you added isn't the last corrected one !
in fact this code is wrong because it kept "del=".$data["id_comment"]." instead in "del=".$req_user_postusername["id"]."

So the right code is :

actually i fixed it and i ment to post that but for some reason you have to click the link twice to get the comment to delete..

No in fact that works but the delete function call is between the comment querying stuff and the comments displaying stuff.

SO when you retrived the comments, the delete hasn't been done yet.
And when you click for the second time, the delete stuff was done thow the delete comment is still displayed.

Well in fact I don't know if you get what I try to explain, but anyway you just have to move :


just before


so that the delete stuff is called before the query that retrieves the comments

did you get that?

it is befor it no?

HI,

not at all, like it is, when you call the comment delete function, the query to retrieve the comments has been yet submitted with :
$rs_pointer = $database->getUserComments($req_user);

and while($req_user_postusername = mysql_fetch_array($rs_pointer)) ...etc. is nothing but a loop that browse the yet built up results set.

so this is like you should order the statments :




and then you can do the displaying stuff ( links and comments )


If you're not sure, just show all the entire comment script and I'll do the changes.

so basically you are telling me to take out while($req_user_postusername = mysql_fetch_array($rs_pointer))?