[dyablo687]

I'v developing a small web app and i've started to get the following message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

This had not happend before, it just started happening when i tried to convert my urls from dynamic to friendly urls, using apache mod rewrite.

At first i was getting a mysql_fetch_assoc():sumysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in line 59 and 8

PHP Code:

$sql = "SELECT * FROM db WHERE blogID={$_GET['blogID']}";

$run = mysql_query($sql);

while($fetch = mysql_fetch_assoc($run))

{

$blogID = $fetch['blogID'];    

$blogTitle = $fetch['title'];

$date = $fetch['date'];

$post = $fetch['post'];

$category = $fetch['category'];

$user = $fetch['user'];

$tags = $fetch['tags']; 

PHP Code:

$sql = "SELECT * FROM dbWHERE blogID={$_GET['blogID']}";

$run = mysql_query($sql);

while($fetch = mysql_fetch_assoc($run)){

       $blogID = $fetch['blogID'];    

       $name = $fetch['name'];

       $email = $fetch['email'];

       $comment = $fetch['comment'];

    echo"

        <h3 class='commentName'>$name</h3>

        <h3 class='commentDate'>$date</h3>

        <p>$comment</p>

                ";

            } 

I then added this:

PHP Code:

$run = mysql_query($sql) or die(mysql_error()); 

and since then i've been getting

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Not sure what else to try

[dyablo687]

I'm not sure if thats the problem anymore....like i said this started happening after i tried converting the urls to friendly urls. But when i access the page using the dynamic url it goes in fine, the problem is when i try to acccess it using the friendly url

here is the code that i have to get the links to change:

PHP Code:

$sql = "SELECT * FROM db ORDER BY blogID DESC";

    $run = mysql_query($sql) or die(mysql_error());

        $num = mysql_num_rows($run);

        while($fetch = mysql_fetch_assoc($run)) {

             $blogID = $fetch ['blogID'];

                    $blogTitle = $fetch['title'];

                    $date = $fetch['date'];

                    $teaser = $fetch['teaser'];

                    $category = $fetch['category'];

                    $user = $fetch['user'];

                    $tags = $fetch['tags'];

                    $blog_title_url = gen_seo_friendly_titles($blogTitle);

                    echo"

                        <div class='postRoll'>

                            <h1><a href='http://www.domainname.com/blog/$blog_title_url.html'>$blogTitle</a></h1>

                            <h2>$date | |User:$user | Category:$category</h2>

                            $teaser

                            <p><a href='#'>Post Comment</a>&nbsp;&nbsp;&nbsp;Number Of Comments</p>

                        </div>

                        ";

                }

                

                function gen_seo_friendly_titles($title) {

                $replace_what = array('  ', ' - ', ' ',    ', ', ',');

                $replace_with = array(' ', '-', '-', ',', '-');

                

                $title = strtolower($title);

                $title = str_replace($replace_what, $replace_with, $title);

                return $title;

            } 

Plus have this following code in a .htaccess file on my root folder

Code:

<IfModule mod_rewrite.c>
RewriteEngine On

RewriteRule ^blog/([^-]+)-([^&]+)\.html$ /blogpost.php?blogId=$blogID

</IfModule>

Both of those sections of code are not on my blogpost.php which is the one that i've having problems with, they are on another file one level up from were the blogpost.php file is in.

Finally, when i look into my error log this is what it tells me thats wrong:

PHP Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result on line 8 and 59 which is where the while($fetech = mysql_fetch_assc($run)) is at