mysql_fetch_row problem.......

[ozzy73]

For some reason the mysql_fetch_row is returning empty results, i do not understand why :

I have used the select statement with mysql, and it returned the appropriate data ( data is correct in db ). All the variables contain a value when the connection and query is run.

Any help would be appreciated, thanks guys.

Ozzy.

function get_lists() {

global $lists, $list_table, $database, $name, $password;

$query = "SELECT name, email, lists FROM $list_table WHERE name='$name'";

$connection = mysql_connect($hostname, $user, $pass) or die ("Unable to establish db connection !");

$result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());

if ( $result ) {

list( $n, $e, $lists ) = mysql_fetch_row($result) or die ("Error in fetch row: !" );

} else {

echo " DOHHHH ";

}
mysql_close($connection);
}

[djg_uk]

Hi Ozzy,

Try using mysql_query instead, as mysql_db_query has been depreciated. mysql_db_query will still return positive even if there is no data, so this might be a reason. I can't see any other reason why this might happen.

Regards,

David

[Anon]

Hi all,

Maybe is your query too fine and the result is unique (just one row). In that case, there might be a problem as well.
I just begin php and I had the same troubles yesterday. I solve it in doing a larger query ("SELECT * FROM MyTable", no WHERE option).
Your result is heavier but it works...

Hope somebody have a better answer...
Kind Regards,
Fred.