PHP problem calling MySQL

[Anon]

In the following lines,

<?php

include "include_fns.php";
include "header.php";

$conn = db_connect();

$pages_sql = "select * from pages order by code"; // line 9
$pages_result = mysql_query($pages_sql, $conn); // line 10

while ($pages = mysql_fetch_array($pages_result)) { // line 12

I get the error message:

Warning: Supplied argument is not a valid MySQL-Link resource in /usr/local/psa/home/vhosts/recursoscristianos.com/httpdocs/DataManager/headlines.php on line 10

Warning: Supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/recursoscristianos.com/httpdocs/DataManager/headlines.php on line 12

What is wrong? Anybody?

[jc94062]

Looks like you arn't connected to the db when calling those queries.

I'd check your db_connect() function to make sure it works, unless thats a PHP function (I'm rusty as anything) in which case it needs some variables, like host name!

$db = mysql_pconnect("hostname", "username", "password");
mysql_select_db("db_name",$db);

Try that to connect, changing the things to whatever they need to be of course.