Why wont this code work online.

[death_knight]

what you do is you call the function

 echo mysql_error();

after the

$result = mysql_query($query, $dblink);

did you follow this instructions along with mine. this is basically the situation. based on your error the result that you pass to the mysql_fetch_row, has no value in it because the query failed. so your passing a null value, are you sure you followed my instructions. cuase

$getdata = "SELECT * FROM meets WHERE pass LIKE '$pass'";


if($query = mysql_query($getdata) ){
   echo mysql_error();
}
else{
  echo "query executed sucessfully <br />";
  $result = mysql_fetch_row ($query) //i'ld use assoc so its easier to reffer to the field names
  $rows = mysql_num_rows($query);
  if($rows > 0){
    
  }
  else{
   echo "query was successful but returned " . $rows . " results"; 
 }
} 

copy and paste that and tell me what happens?

[Artificial_Intelligence]

if($$query = mysql_query($getdata) ){
echo mysql_error();
}

Think there is a typo in the if statment.

MySQL Example

The most common database used with PHP is MySQL, so I guess you should be familiar with the following code. It connects to a MySQL server at localhost, database mydb, and executes an SQL select statement. The results are printed, one line per row.

$db = mysql_connect("localhost", "root", "password");
mysql_select_db("mydb",$db);
$result = mysql_query("SELECT * FROM employees",$db);
if ($result === false) die("failed"); 
while ($fields = mysql_fetch_row($result)) {
 for ($i=0, $max=sizeof($fields); $i < $max; $i++) {
        print $fields[$i].' ';
 }
 print "<br>\n";
} 

Here is the equivalent code in ADODB

 include("adodb.inc.php");
 $db = NewADOConnection('mysql');
 $db->Connect("localhost", "root", "password", "mydb");
 $result = $db->Execute("SELECT * FROM employees");
 if ($result === false) die("failed");  
 while (!$result->EOF) {
    for ($i=0, $max=$result->FieldCount(); $i < $max; $i++)
           print $result->fields[$i].' ';
    $result->MoveNext();
    print "<br>\n";
 } 

check this link to know more
http://phplens.com/lens/adodb/tute.htm

[de_uno]

ensure the database username and pass are the same on your server and development machine

[leocrawf]

Thanks very much will try it out.

By the way can this this work with windows iis server

[death_knight]

if php can run on an iss server then i dont see why not. question is you sure is a mysqldb you working with?

[leocrawf]

yep. mysql 4.2 and php 4 +.

[death_knight]

you dont really want help leo. POST YOUR ERROR MESSAGES or you already get it working? right now we're just guessing the possible problems and giving you advice based on that. however we cant know what exactly is wrong untill we see the error message geneated from mysql_error(). if you used my code above it should trigger an error if the query failed.

[leocrawf]

I am sorry you. I guess i just gave up, because i still cant understand how it works on one machine and dont work an another. I will post results soon.

[Virus]

I dont really care much for the code, but u said u were using iis as ur localhost thingy.. but in the first line of ur post it looks like a linux server. No big deal, but uhmm, does ur hosting package give u access to mysql???

[leocrawf]

yes it does. i have the abillty to create a user and give them rights.