PHP4+MYSQL Problem

Anon

Hi,

I am migrating from PHP3 to PHP4, and I
am receiving the following error message:

Warning: Supplied argument is not a valid MySQL result resource in
trm6.phtml on line 16

Here's the code:

<?php

function gettrm($nandina, $tipo){

$db = mysql_connect("localhost", "fgusf", "adiyshad8yBkj");

mysql_select_db("dbname_com",$db);

$result = mysql_query("SELECT * FROM indicadores WHERE nandina=$nandina");

$myrow = mysql_fetch_array($result);

if ($tipo==0){
$impo97 = $myrow["impo97"];
return $impo97;
}

if ($tipo==1){
$expo97 = $myrow["expo97"];
return $expo97;
}

if ($tipo==2){
$descripcion = $myrow["descripcion"];
return $descripcion;
}

}

if ($submit) {

// process form

while (list($value) = each($HTTP_POST_VARS)) {
}

$tipo=0;
  $ans = gettrm($nandina, $tipo);

  printf("Ans = %s ",$ans);

}

if ($submit1) {

// process form

while (list($value) = each($HTTP_POST_VARS)) {
}

  $tipo=1;

  $ans = gettrm($nandina,$tipo);

  printf("<B>El total de las exportaciones en 1997 para la subpartida %s fue de USD $ %s\n</B><br>",$nandina,$ans);

}

....

I would appreciate some help on this...
Thanks,

Sergio

Anon

Where are you setting the variable $nandina equal to something before you pass it to the function?

Since you are using this variable in your query, it needs to have a value.

I would first try the query with a literal value:

SELECT * FROM indicadores WHERE nandina='whatever'

If this works you will know your problem is with the variable $nandina.

Also, you may want to use global variables in your function, since you are using variables that you have declared outside the function.

Anon

Thanks for your reply Bruce,
It seems that nandina is not the problem. I belive that the function mysql_fetch_array($result) does not work well with php4. However here´s the complete code... once again thank you!

<body>
<?php

function gettrm($nandina, $tipo){

$db = mysql_connect("localhost", "gfkust", "kashjandskj");

mysql_select_db("shflsafjlfsf",$db);

$result = mysql_query("SELECT * FROM indicadores WHERE nandina=$nandina");

$myrow = mysql_fetch_array($result);

if ($tipo==0){
$impo97 = $myrow["impo97"];
return $impo97;
}

if ($tipo==1){
$expo97 = $myrow["expo97"];
return $expo97;
}

if ($tipo==2){
$descripcion = $myrow["descripcion"];
return $descripcion;
}

}

if ($submit) {

// process form

while (list($value) = each($HTTP_POST_VARS)) {
}

$tipo=0;
  $ans = gettrm($nandina, $tipo);

  printf("<B>El total de las importaciones en 1997 para la subpartida %s fue de USD $ %s\n</B><br>",$nandina,$ans);

}

if ($submit1) {

// process form

while (list($value) = each($HTTP_POST_VARS)) {
}

  $tipo=1;

  $ans = gettrm($nandina,$tipo);

  printf("<B>El total de las exportaciones en 1997 para la subpartida %s fue de USD $ %s\n</B><br>",$nandina,$ans);

}

if ($submit2) {

// process form

while (list($value) = each($HTTP_POST_VARS)) {
}

  $tipo=2;

  $ans = gettrm($nandina,$tipo);

  printf("<B>La subpartida %s corresponde a: %s\n</B><br>",$nandina,$ans);

}

else{

// display form
?>

  <form method="post" action="<?php echo $PHP_SELF?>">
Código Nandina: <input type="Text" name="nandina"><br>
  <input type="submit" name="submit" value="Impo97">
<input type="submit" name="submit1" value="Expo97">
<input type="submit" name="submit2" value="Descripción">
  </form>

<?php

} // end if

?>
</body>

Sergio

Anon

Try putting your var in single quotes within your select statement:

$result = mysql_query("SELECT * FROM indicadores WHERE nandina='$nandina'");

Anon

Bruce wrote:

Try putting your var in single quotes within your select statement:

$result = mysql_query("SELECT * FROM indicadores WHERE nandina='$nandina'");

Hello,
I have the same problem (after migrating from PHP3 to PHP4, in PHP3 everything worked!!!).
Single quotes did not help. Actually SELECT is succesfull, I get a result, everything is OK, ONLY I get that warning on a page. What is happend in PHP4?

Thank for any ideas,
Lubos.

Anon

Thank you all for the help received,
It seems that the code is OK - php4 should work properly, but it does not.
Until then, I´m afraid I´ll have to implement it in someone else´s php3 server - since my php4 could not handle it.

Grate collaboration network we have created - Keep up the good work!

SERGIO