On my localhost this works fine

$result= mysql_query("SELECT date_format(date, '%d/%m/%Y') as date, title,
id, display FROM NEWS");
while ($row = mysql_fetch_***oc($result)) {

but on my remote i get a mysql_fetch_***oc(): supplied argument is not a
valid MySQL result resource

Can someone expalin the problem? PHP version problem?

blueboy wrote:
> On my localhost this works fine
>
> $result= mysql_query("SELECT date_format(date, '%d/%m/%Y') as date, title,
> id, display FROM NEWS");
> while ($row = mysql_fetch_***oc($result)) {
>
> but on my remote i get a mysql_fetch_***oc(): supplied argument is not a
> valid MySQL result resource
>
> Can someone expalin the problem? PHP version problem?

No. It's MySQL problem.
If it works fine locally, then make sure the table structure is the same
on your remote database as it is on your local database.

---
mysql_query("SELECT date_format(date, '%d/%m/%Y') as date, title,
id, display FROM NEWS") or die(mysql_error());
---


Using that die statement will also help while debugging your script as
it will print out any errors that are caused by your SQL statement.
Which you then ask some mysql people if that is the case.


Darren

On 31/05/07, blueboy <EMAIL REMOVED> wrote:
> On my localhost this works fine
>
> $result= mysql_query("SELECT date_format(date, '%d/%m/%Y') as date, title, id, display FROM NEWS");

1. check return values, $result should not be false unless there's a problem.
2. if $result is false, check mysql_error() it'll tell you more about
what's gone wrong.

for example:

$result = mysql_query($query) or die(mysql_error());

-robin

On Thu, May 31, 2007 4:50 am, blueboy wrote:
> On my localhost this works fine
>
> $result= mysql_query("SELECT date_format(date, '%d/%m/%Y') as date,
> title,
> id, display FROM NEWS");
> while ($row = mysql_fetch_***oc($result)) {
>
> but on my remote i get a mysql_fetch_***oc(): supplied argument is not
> a
> valid MySQL result resource
>
> Can someone expalin the problem? PHP version problem?

The problem is probably that you never even managed to connect to the
MySQL database in the first place...

But it could be something else entirely.

We can't tell you, but you can find out by using the mysql_error()
function a lot.

--
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?