Help with mysql_fetch_array()

[anon]

Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/***/public_html/***/spider.php on line 13

 

Here is my current code -

<?php
$dbhost = '***';
$dbuser = '****';
$dbpass = '*****';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error with database');

$dbname = '****';
mysql_select_db($dbname);

$getlist=mysql_query("SELECT u_id FROM addurl");

while($row=mysql_fetch_array($getlist)){
   $text = file_get_contents($row[0]);
   mysql_query("insert into *** (content) values ($text)");
}
?>

 

The code should fetch and index a page that has been specified in a database.

[rajivgonsalves]

try

 

$getlist=mysql_query("SELECT u_id FROM addurl") or die("Query error ".mysql_error());

 

and let me know if you get any errors

[anon]

I will try it, but the error is in line 13...

[rajivgonsalves]

actually your syntax looks good, there can only be an error in connecting to the database, selecting a database, or the query..

[anon]

This is the error the Cron Daemon gave me\

 

"Query error No database selected"

 

I did select a database though...

 

[rajivgonsalves]

are you connecting to the correct host that has the db check that

[anon]

I think I may have spelt the DB name wrong. Is it case-sensitive?

 

[rajivgonsalves]

it should not be... but you can try it...

[anon]

Nope, no luck

 

Here's my code at the mo

<?php
$dbhost = 'localhost';
$dbuser = '***';
$dbpass = '****';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error with database');

$dbname = 'Direx';
mysql_select_db($dbname);

$getlist=mysql_query("SELECT u_link FROM addurl") or die("Query error ".mysql_error());

while($row=mysql_fetch_array($getlist)){
   $text = file_get_contents($row[0]);
   mysql_query("insert into Index (content) values ($text)");
}
?>

[kenrbnsn]

Put an "or die" clause on the mysql_select_db() function:

<?php
mysql_select_db($dbname) or die("Problem selecting the database $dbname<br>" . mysql_error());
?>

 

Ken

[anon]

Ok, I'll try that now. Just asking, is that a technique used by developers to find where the problem is?

[anon]

The problem is in my password or something, because it says access denied.

[PHP_PhREEEk]

If that doesn't get you going, the only thing I would try is:

 

<?php
$dbhost = 'localhost';
$dbuser = '***';
$dbpass = '****';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error with database');

$dbname = 'Direx';
mysql_select_db($dbname, $conn);
// rest of your script

 

PhREEEk

[PHP_PhREEEk]

Please, when we are trying to prompt you for error msgs, don't just post "it says access denied". Copy the entire error right off of the screen.. all of it... then paste it here.

 

PhREEEk

[janim]

you need this :

<?php

$getlist=mysql_query("SELECT u_id FROM addurl");
// add this if statement   
if(mysql_num_rows($getlist)){
while($row=mysql_fetch_array($getlist)){
   $text = file_get_contents($row[0]);
   mysql_query("insert into *** (content) values ($text)");
}
}
?>

[kenrbnsn]

The OP isn't even connecting to the database.

 

Ken

[anon]

Problem selecting the database Direx<br>Access denied for user '*******'@'localhost' to database 'Direx'

[PHP_PhREEEk]

Interesting that the error does not state 'Using Password YES' or 'NO' for that matter...

 

I've got to run some errands this morning, so I'll leave it to someone else to walk him through verifying the user.

 

PhREEEk

[revraz]

$dbhost = '***';

$dbuser = '****';

$dbpass = '*****';

 

$dbname = '****';

 

One of these is wrong, you need to figure out which one and fix it.