[Resolved] invalid MySQL code?

matthewdingley

Hi,
I'm getting this error code:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/matthewd/public_html/admin/article.php on line 373

The sql code I am using for that mysql_fetch_array() function is:

$getArticles=mysql_query("SELECT id, title, date, summary, novisitors FROM $tablename WHERE complete='0'", $db);

Can anyone spot anything wrong that I may be doing?

Thanks in advance,

Matthew Dingley

www.matthewdingley.co.uk

KITTfan2K

I have a similar problem. My SQL query doesn't query right. enter a search term that I know will bring back a match, and it doesn't work.

I'm trying to make a case-insensitive query, and my current solution is to convert the string and the field to lowercase, as so:

$Query = "SELECT name,id FROM brk_members WHERE LOWER('name') LIKE LOWER('%".$MemberName."%')";

This doesn't bring back the beacon, though. I get no matches.

KITTfan2K

Lars_Berg

$Query = "SELECT name,id FROM brk_members WHERE LOWER(name) LIKE LOWER('%".$MemberName."%')";

dnszero

You should try using an OR DIE construct to catch any error in your sql query. Something like:

$articleSql = "SELECT id, title, date, summary, novisitors FROM $tablename WHERE complete='0'";

$getArticles = mysql_query($articleSql, $db) or die ("Invalid sql statement. Error: " . mysql_error());

This will at least allow you to see what the error is.

matthewdingley

I've tried that and this is the error message I get:

Invalid sql statement. Error: Can't open file: 'mdarticle.MYI'. (errno: 145)

tsinka

Your database might be damaged. Does the index file exist ? You might need to repair the table or to check if the mysql daemon has the access rights on the database files. Also check if the partition where the files reside might be full.

matthewdingley

It's been working before, so it might be damaged. Do you know how to check using PHPmyAdmin?

tsinka

If you try to list the contents of that table with phpMyAdmin it might spit an error message. at least if you want to insert new records with phpMyAdmin.

If the table is damaged you can try to repair it with the SQL statement

REPAIR TABLE mdarticle

This might solve the problem. Worst case would be that mysql can't repair the table or that the table is empty afterwards. But since mysql seems to be missing the index file only it might be able to repair the table. Additionally you might try a

OPTIMIZE TABLE mdartice

which would optimize the table and thus recreate the table files. The table will not be accessible while the table gets optimized.

matthewdingley

The database had corrupted, don't know how. My host sorted it out.

Thanks everyone for the help