PHP error, help please

[unknowngiver]

Hey
I just installed a Text exchange script and i am getting this kinda error in some of the USER pages
the site works and all..but in the USER control panel, i get these errors

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/linkpro/public_html/edit.php on line 140

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/linkpro/public_html/edit.php on line 144

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/linkpro/public_html/edit.php on line 145

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/linkpro/public_html/edit.php on line 146

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/linkpro/public_html/edit.php on line 147

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/linkpro/public_html/edit.php on line 148

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/linkpro/public_html/edit.php on line 149

 

[Shorty]

...It might help if you posted the code and not the errors.

 

[Peter]

That error is ussually caused by either a database connection that failed OR a query that failed.

Place the following code on line 141 of edit.php

echo mysql_errno();

Now go to the pages that display the error and post what you get now (remember to delete the added line after you have posted the result here).

 

[unknowngiver]

hey

1146
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/linkpro/public_html/edit.php on line 141

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/linkpro/public_html/edit.php on line 146

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/linkpro/public_html/edit.php on line 147

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/linkpro/public_html/edit.php on line 148

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/linkpro/public_html/edit.php on line 149

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/linkpro/public_html/edit.php on line 150

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/linkpro/public_html/edit.php on line 151

P.s: i cant copy the whole code because its a script, if you really want to help me out please add me on msn at [email protected] and i will send u the whole script, in return i will give u some other scripts i have wid resale rights and will donate some NP$

Thanks

 

[Eric]

Error code 1146 it looks, which is:

1146: Table 'databaseName.tableName' doesn't exist

Error Code: 1146
Error Info:

Occurs when the table you've specified in your SQL statement does not exist in specified database.

 

[unknowngiver]

hm weird i installed the database right, i am sure abt that...can anyone add me on msn and help me out plz

 

[weblord]

have you imported the .sql file that goes with it? also have you given the db username that access the db name?