Hi
I run the following:
// get page results
$sql = "SELECT timestamp1,title,author,substring(body,100) FROM test.articles
ORDER BY timestamp1 desc
LIMIT $startindex, $perpage";
.. etc:
print "
";
print $row->body;
print "
";
print "
";
i get error:
PHP Notice: Undefined property: stdClass::$body in C:\Inetpub.....
the column type for body is test, i read here that substr doesnt work with longtext:
http://bugs.mysql.com/bug.php?id=15757
so i also tried left(body,50), doesn't work!
thanks in advance
aurevoir
Tovia
2007-10-19
20:06:51
·
2 answers
·
asked by
jam
5
in
Programming & Design