[SOLVED] data from database lag

[mmarif4u]

Ok try to edit ur code to this:

f ($_GET['show'] == 1){$query = "SELECT * FROM piccomment WHERE picid = '$pictureid' ORDER BY picindex asc ";}

 

And let me know.

[bluebyyou]

Unfortuneately that still is not doing it. Thank you for your patience so far.

[mmarif4u]

Ok try it with out order by clause:

 

if ($_GET['show'] == 1){$query = "SELECT * FROM piccomment WHERE picid = '$pictureid'";}

 

[redarrow]

try this please.

if ($_GET['show'] == 1){$query = "SELECT * FROM `piccomment` WHERE `picid` = '$pictureid' ORDER BY `commentdatetime` DESC ";}
if ($_GET['show'] != 1)  {$query = "SELECT * FROM `piccomment` WHERE `picid` = '$pictureid' ORDER BY `commentdatetime` DESC LIMIT 7 ";}
query_db($query);

[bluebyyou]

Still not doing it. This is pretty frustrating isn't it? I have been working on this all day!

 

Do you think it has something to do with my db, and not the code at all?

[bluebyyou]

That didn't solve the issue either redarrow. It is still working after your changes though, so that is good. Would you like me to PM you a username and password to see what it happening?

[mmarif4u]

i did not think u change ur code to this:

if ($_GET['show'] == 1){$query = "SELECT * FROM piccomment WHERE picid = '$pictureid'";}

 

Bcoz i did not the comment i posted now.

[bluebyyou]

I did and tested it, when it didnt work I put it back, If you would like I will put it back to what you have posted above for you to try...so i am doing it now, let me know what you get.

[mmarif4u]

Read this link:

http://bugs.mysql.com/bug.php?id=28542

 

Thats why i remove order by clause from your query.

[bluebyyou]

So that did actually work, I was still looking at the top of the comments list for the latest post, I forgot that it would add it at the bottom.  So does that mean I cant order the posts now?

[bluebyyou]

I take that back it works for every post after the first. The first post on a pic still doesnt show.

 

edit: I continued to try on other photos, and it is back to not showing the latest post at all.

 

 

I know this can work, Im sure theres a more elegant solution especially using ajax or something, but I think what I have is close to working, or should I be going about this a different way?

[mmarif4u]

U can use but depend on your mysql version.

Order by is the way to put the latest one on top but here u r using version 4.1.22 so may be still the mysql team did not fix it for version 4.1.22, But later versions works fine for order by.

[redarrow]

are you posting the pic to another file.php or the same file.php

[bluebyyou]

 

are you posting the pic to another file.php or the same file.php

Im not sure what you are asking redarrow?

 

U can use but depend on your mysql version.

Order by is the way to put the latest one on top but here u r using version 4.1.22 so may be still the mysql team did not fix it for version 4.1.22, But later versions works fine for order by.

Unfortuneately I have no control over my verson

[redarrow]

post you insert code please ok.

[bluebyyou]

for inserting comments or photos?

[bluebyyou]

Here is the comment insert form

 

<?php
include("db_connect.php");

$striptext = stripslashes(strip_tags($_POST['text'])); 
$finaltext = mysql_real_escape_string($striptext); 
$now = date("Y-m-d H:i:s");
$query = "INSERT INTO piccomment (picid,posterid,commentdatetime,postername,comment) 
	  VALUES ('$_POST[picid]','$_SESSION[user]','$now','$_POST[postername]','$finaltext')";
query_db($query);
$getid = $_POST['picid'];

header("location:pic.php?id=$getid");

?>

 

 

[redarrow]

try this ok.

<?php

$picid=addslashes($_POST['picid']);
$users=addslashes($_SESSION['user']);
$users=addslashes($_POST['user']);
$postername=addslashes($_POST['postername']);

$striptext = stripslashes(strip_tags($_POST['text'])); 
$finaltext = mysql_real_escape_string($striptext); 
$now = date("Y-m-d H:i:s");
$query = "INSERT INTO piccomment (picid,posterid,commentdatetime,postername,comment) 
	  VALUES ('$picid','$user','$now','$postername','$finaltext')";
query_db($query);
$getid = $_POST['picid'];

header("location:pic.php?id=$getid");

?>

[redarrow]

updated version

 

<?php

$picid=$_POST['picid'];
$users=$_SESSION['user'];
$users=$_POST['user'];
$postername=$_POST['postername'];
$striptext = stripslashes(strip_tags($_POST['text'])); 
$finaltext = mysql_real_escape_string($striptext); 
$now = date("Y-m-d H:i:s");

if(isset($_POST['submitcomment'])){
$query = "INSERT INTO piccomment (picid,posterid,commentdatetime,postername,comment) 
	  VALUES ('$picid','$user','$now','$postername','$finaltext')";
query_db($query);
}

$getid = $_POST['picid'];

header("location:pic.php?id=$getid");

?>

[bluebyyou]

I still am getting the same lag, the latest post still doesn't show until another post has been made.

 

I will try that latest version now.

 

 

 

[redarrow]

from the database what is the table field set to varchar char lontext what?

[bluebyyou]

you have $users being set to two different things, and in the query $user isnt coming from anywhere

[bluebyyou]

Here are my columns and data types

 

picindex                  int

picid                        int

posterid                    int

commentdatetime    datetime

postername            varchar

comment                text

[redarrow]

sorry about the typo i am stuffed then that me sorry.

[bluebyyou]

No problem, I apreciate the patience and help. would you mind posting what it should have been?