Latest Announcemnent
New thread
Status
Not open for further replies.
bxflow said:
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
Click to expand...

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
Code: 
'SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1
when it should be
Code: 
SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1
 
Earlier you said:
bxflow said:
the database is there so is the table fblike
so idk wtfak is wrong :|
Click to expand...
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.
 
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
20like207c.png
 
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.
 
AGAIN: 'like' is a reserved word. rename 'like' the column name to 'likes' or any.

don't forget to rename on the php too.
Code: 
$like=$y['likes'];

let me know how it goes. regard.
 
wtf.. dood we said its not the mysql_fetch_assoc ... that just itterates (loops) the result from mysql_query.

The problem is that mysql_query is not returning a resource: (Resource)

You need to make sure that the query and that table are correct

its not the php code. its the query / database layout
 
Show us the other side of phpMyadmin that shows the table name.

I believe you are missing the part that has your name from host unless you have a dedi or vps.

Something like fb_like or fromhost_like or ???

bxflow said:
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
20like207c.png
Click to expand...
 
Status
Not open for further replies.
Back
Top