using this mysql syntax. my script is returning that the syntax near “limit 10” is wrong.:
[php]
mysql_query( “SELECT * FROM “.$tablename.” WHERE id=”.$id." LIMIT 10" );
[/php]
anybody can help me, it’d be much appreciated. my friend has also been helping me work out some kinks in the script as well.
$sql = ‘SELECT * FROM ’ . $tablename . ’ WHERE id="’ . $id . ‘" LIMIT 10;’;
mysql_query( $sql );
Note the singe versus double quotes and that the double quotes I do have are escaped.
already tried that, and it really couldn’t matter much whether i used single quote or double quotes for the varying roles. i tried both ways, but neither worked. what actually happened though is my friend helped me out by writing a seperate script for the function that’s called that uses mysql_data_seek. here’s the script:
[php]
function printcomments( $tablename, $id, $offset=“10” ) {
$comments_querystring = "SELECT title, author, date, post FROM ".$tablename." WHERE id = '".$id."' LIMIT ".$offset;
$comments_query = mysql_query($comments_querystring) or die( "Couldn't query: ".mysql_error() );
$comments_output = "<table>";
for($i=0; $i < 10; $i++) {
if( !mysql_data_seek( $comments_query, $i ) ) {
break;
};
$comments_object = mysql_fetch_object($comments_query);
$comments_output .= "<tr><td><b>title:</b> ".$comments_object->title."</td></tr>";
$comments_output .= "<tr><td><b>posted by:</b> ".$comments_object->author." on ".$comments_object->date."</td></tr>";
$comments_output .= "<tr><td><b>comment:</b><br />n".$comments_object->post."</td></tr>";
}
$comments_output .= "</table>";
return $comments_output;
}[/php]
the function is stored in a seperate file from the script calling the function.
the results of calling this script from a seperate documment, view_comments.php (see below for script) can be seen at http://www.time2changefbcy.com/view_com … ype=a&id=9
script of view_comments.php:
[php]
if( isset( $_GET[‘type’] ) and isset( $_GET[‘id’] ) ) {
$type = $_GET[‘type’];
$id = $_GET[‘id’];
include( "mysql_info.php" );
$conn = mysql_connect( "localhost", $mysql_username, $mysql_password );
mysql_select_db( "time2ch_comments" );
include( "printcomments.php" );
if( $type == "a" ) {
if( isset( $_GET['offset'] ) ){
printcomments( "article", $id, $_GET['offset'].", 10" );
} else {
printcomments( "article", $id );
};
} elseif( $type == "p" ) {
if( isset( $_GET['offset'] ) ) {
printcomments( "poll", $id, $_GET['offset'].", 10" );
} else {
printcomments( "poll", $id );
};
};
mysql_close( $conn );
} else {
print “Error: Link has incorrect syntax.
n
Please contact the webmaster.
n
Include the following: n
n”;
};[/php]