mysql_fetch_assoc() not working

[marxman]

Hello I've this problem with mysql_fetch_assoc() i'm developing a website on localhost where there is no problem after uploading the site to a previous provider everything worked with little modification, i decided to change the provider and then the problem begins

mysql_select_db($database, $link);
echo $query = "SELECT title_id, title_name, genre_id, rating_id, title_desc, tumbnail_url FROM titles where new_release = 'C' ORDER BY title_name ASC";
$coming_soon_rows = mysql_num_rows(mysql_query($query));
$results = mysql_query($query, $link) or die(mysql_error());
$row_results = mysql_fetch_assoc($result);

this code works perfectly on the previous provider and localhost but not on the new provider I tested it but mysql_fetch_assoc() is empty

Thanx

[keith73]

$results = mysql_query($query, $link) or die(mysql_error());
$row_results = mysql_fetch_assoc($result);

Actually, unless that's a typo, that code shouldn't work anywhere.
your assigning the query results to $results but trying to create an assoc array using $result <- no s

IF it's not a typo, then it is possible the query is not returning anything.

The other problem could be your new host has an old version of PHP.
mysql_fetch_assoc is in version 4.0.3 and up. IF they have an old version, tell them to upgrade it or find a new host. IF they aren't up to date, they probably don't have the latest patches installed either which makes your site vulnerable.

throw this into a script somewhere and check the version.

echo phpversion();

• keith

[marxman]

Thanx for replying but it was a typing error, the php version of the current provider is 4.1.2