[Alex.css]

Hi dear programmers.
I'm a bit confused about my SQL queries problem. To make short, I select something from the database but it doesn't fetch an array, and I don't know why.

The mysql_error() did not show any errors, even if it made the script dying.
I mean, I did : mysql_connect(....) or die(mysql_error()); -> fine
mysql_sel...-> fine
mysql_query-> fine
mysql_fetch_array-> it dies. Showing only a blank page, no error.

This is a part of the script, starting from the beginning :

PHP Code:

<?php
$theme = $_GET['theme'];
mysql_connect($SQL['hote'], $SQL['utilisateur'], $SQL['motdepasse']);
mysql_select_db($SQL['bdd']);
  $req1 = mysql_query("SELECT * FROM `".$SQL['bdd_prefix']."theme` WHERE `url`='".$theme."'");
  echo $req1;
  $SOMETHING = mysql_fetch_array($req1);
  echo $SOMETHING['defaut'];
?>

The $_GET['theme'] is for sure containing something, it's already verified.
Mysql_connect works.
mysql Select works.
mysql Query works, returning a resource id (#12)
mysql fetch_array DONT work. Returning nothing.


Thanks in advance, Alex.css

[landing]

Try a var_dump($SOMETHING); to see if it's set?