Fatal error: Class '1' not found

Ejryuu

I am moving a website from a crapy windows asp server to a real linux webhosting server. on the main page this is the error I am geting

Fatal error: Class '1' not found in /home/cats/public_html/index.php on line 233

now on line 233 it reads
if ($row = mysql_fetch_object($query, MYSQL_ASSOC ))

any ideas why that is not working?

the new server is using php5 via Cpanel and I am not realy to sure what the old server was running....

any help would be nice

Ryan

halojoy

Try remove MYSQL_ASSOC.
That parameter can be used for arrays,
but [man]mysql_fetch_object/man deals with objects
and should not have MYSQL_ASSOC as parameter.

//now on line 233 it reads
if ($row = mysql_fetch_object($query))

Ejryuu

the error nows reads

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/cats/public_html/index.php on line 233

its just never ending lol

Weedpacket

In other words $query isn't a valid MySQL result resource. So there's something wrong with its value (hint: if the query fails, the returned value will be FALSE).

Ejryuu

so this is wrong?

$query = mysql_query("SELECT NewsID, Topic, Body, Poster, Year, Month, Day, TIME_FORMAT(Time, '%l:%i %p') AS the_time FROM News ORDER BY NewsID DESC");
for ($count=0; $count<=0; $count++)
{
this that what I am seeing?

halojoy

A query is the string: "SELECT NewsID, Topic, Body, Poster, Year, Month......"

When we run the query we get a result
But $result is not useful until we fetch some rows from $result

Study the examples in this page: [man]mysql_fetch_array[/man]

This is the usual way:

$result = mysql_query("SELECT NewsID, Topic, Body, Poster, Year, Month, Day, TIME_FORMAT(Time, '%l:%i %p') 
AS the_time FROM News ORDER BY NewsID DESC");

// get the first row from result, into an array
$row = mysql_fetch_array( $result );

// dump out this row, this array
echo '<pre>';
print_r( $row );
echo '</pre>';