MySQL Error

[Mr Happy]

thanx,


#1064 - 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 ''SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1' at line 1

Try it again. You have an extra ' before the SELECT that shouldn't be there. Probably an error copying and pasting it.

PHPmyadmin checked for

'SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1

when it should be

SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1

[litewarez]

what he said again lol.

[bxflow]

#1146 - Table 'XXXXX_XXX.fblike' doesn't exist

[Robin H]

You sure the name of the table is right? 'fblike' just sounds wrong

[bxflow]

well now the error in phpmyadmin says the table doesnt exist

[Mr Happy]

Earlier you said:

the database is there so is the table fblike
so idk wtfak is wrong

but the code and PHPmyadmin is saying that it doesn't exist. How do you know it exists? Can you see the table in PHPmyadmin? If so maybe screen shot it for us? Something is wrong someplace. Either it doesn't exist or it's spelled differently.

You should have being given an install script or something to run to insert the code and set up the DataBase. Can you show us a copy of that? The problem seams to be in the install script rather than in the actual script itself.

[litewarez]

the table exists but the column does not,

Export the structure of the table in SQL and past the fblike section here please

[bxflow]

sorry about the confusion but the fblike does not exist,

the script has a read me that says

upload files to server
create a database,etc
import the database.sql file into your database
edit config.php to match database details
and done.


the fblike does not exist i guess i got confused earlier.

this is the table

"like"
the structure of the table is

[litewarez]

so change fblike in your query to like.

[bxflow]

already did that and doesn't wok.

the problem might be this?

while ($y=mysql_fetch_assoc($x)) {
and my php version?

Before i had a problem with a script saying the fetch was invalid and then i had to add the $ sign in front of something to fix it, but idk whats wrong here.