[SOLVED] Inner join problem

[ballouta]

Hi

 

i wrote a query that is casuing a problem:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/simwsim/public_html/CMS/members/index.php on line 42

 

the query is:

<?php
$query = "SELECT members.usernme, members.name, members.emal, members.country, members.tele, members.paword, members.resler, credts.nums
 FROM members 
 INNER JOIN credts
 ON members.usernme = credts.usernm ";
$result = mysql_query($query);
while( $row = mysql_fetch_array($result)) //this is line 42
?>

 

please help

[Masna]

or die(mysql_error());

 

Let us know what's printed.

[ballouta]

Thanks ALOT

there was a wrong coulum name

it is working now