[Resolved] mysql_fetch_row(): supplied argument is not a valid MySQL result resource

[loureiro]

ok here is my code and i cant figure out why its not working....can anyone help?

//build client select
  $sqlClient = "SELECT clientNo, first, last FROM client ORDER BY last";

  //run query
  $clientResult = mysql_query( $sqlClient, $connection );

  while(list( $clientNo, $firstName, $lastName ) = mysql_fetch_row( $clientResult ))  //problem here at mysql_fetch_row
  {
    $line = '<option value="'.$clientNo.'">'.$lastName.', '.$firstName.'</option>';
    $retVal .= $line;
  }

[bunner_bob]

Almost always, when this happens to me, it's because something's wrong with my query. Make sure you have the field names exactly right in your query. And that your connection string is right (though I'd think you'd get a different error if that wasn't the case). Try simplifying your query and find out where it breaks.

I always use mysql_fetch_array - but strangely I don't see that in the mysql manual any more. Has mysql_fetch_array been deprecated?

• Bob

[tsinka]

No,

it's still there

Thomas

[bunner_bob]

Silly me - I was looking at the MySQL manual.

[tsinka]

loureiro,

change the mysql_query line a little bit to see what might be wrong with the query:

$clientResult = mysql_query( $sqlClient, $connection ) or die("SQL error: ".mysql_error()); 

Thomas

[loureiro]

ok for some reason it isnt allowing me to include a file! i checked the name and its in the same folder and everything...here is what i have and what i've tried already...

include "./config.php";

include "config.php";

this is in the same folder as the file that this code appears in...anyone can you help?

[tsinka]

which error do you get ?

[loureiro]

No Database Selected

that is exactly the error message i get. it must have something to do with the way im trying to include the file cause its just not working. if i put it in manually it works but since i have the variables created in another file and it wont let me include that file...its giving me that error message. PLEASE HELP!

[tsinka]

Ok,

this is rather a problem of how you connect to the database than how you include files. You need to select a database after connecting to the database like (in short without error checking):

$conn = mysql_connect("host","user","pass");
mysql_select_db("thedb",$conn);
// then you can use mysql_query and so on

Please post the code if that doesn't help you ...

Thomas

[loureiro]

yeah im doing that... take a look at this...

<?php
include_once "./config.php";

$connection = mysql_connect( $DBHostName, $DBUsername, $DBPassword ) or die("SQL connect error: ".mysql_error());
mysql_select_db ( $DBName ) or die("SQL select DB error: ".mysql_error());

?>

where you see a variable start with $DB that means it is a variable defined in another page...the one included

here is the exact error message i get:

SQL select DB error: No Database Selected

[tsinka]

How does config.php look like ?

[loureiro]

<?php
$DBHostName = "localhost"; // database host name
$DBUsername = "*"; // database login username
$DBPassword = "*"; // database login password

$DBName = "****"; // name of database
?>

[tsinka]

Which output do you get if you change the code to:

<?php 
ini_set("error_reporting",E_ALL);
include_once "./config.php"; 

$connection = mysql_connect( $DBHostName, $DBUsername, $DBPassword ) or die("SQL connect error: ".mysql_error()); 
echp "Database: $DBName<br>\n";
mysql_select_db ( "$DBName",$connection ) or die("SQL select DB error: ".mysql_error()); 
?> 

[loureiro]

Database:
SQL select DB error: No Database Selected

thats what appears

[tsinka]

Ok,

so PHP doesn't see the $DBName variable. PHP is case sensitive so check if the variable name matches exactly. Something happens with that variable. Are there any other lines in config.php ?

[loureiro]

no there are no other lines in the config file

[loureiro]

if i hard code the values in then it works perfectly...why would the include not work?

[loureiro]

i replaced include with a require and then checked the log and here is what it says...

[24-Aug-2004 17:27:48] PHP Warning: main(./config.php): failed to open stream: No such file or directory in C:\apache2triad\htdocs\php_functions\edit.php on line 2

it shouldnt be looking inside the same file! the same folder yes but not the same file! it should be looking for it in...

C:\apache2triad\htdocs\php_functions\config.php

[bunner_bob]

I would suggest, when in doubt, to work your way out and temporarily replace variables with the actual content.
In other words, replace

$connection = mysql_connect( $DBHostName, $DBUsername, $DBPassword ) or die("SQL connect error: ".mysql_error()); 
mysql_select_db ( $DBName ) or die("SQL select DB error: ".mysql_error()); 

with

$connection = mysql_connect( 'myhost', 'myusername', 'mypassword ) or die("SQL connect error: ".mysql_error()); 
mysql_select_db ( 'mydatabase' ) or die("SQL select DB error: ".mysql_error()); 

If that works or doesn't, it should help you pinpoint the problem.

• Bob

[bunner_bob]

PHP Warning: main(./config.php): failed to open stream: No such file or directory in C:\apache2triad\htdocs\php_functions\edit.php on line 2

If it's the same directory, you don't need "./"