php function and database select

[danielsebas]

Hi,
I have a function in my page named goods

function goods(){

function code

}

and a recordset made with dreamweaver for a mysql database that is:

SELECT * FROM products WHERE products.prod_goods_id = goods()

how can I put the value of the goods function in the WHERE statement? because when I write it like it is above I have an error that says the function goods does not exist in the database

thank you in advance

[JasonLewis]

well you would have to have a return somewhere in your goods function.

something like this would work, afaik:

[code=php:0]
function goods(){
$value = 1;

return $value;
}

mysql_query("SELECT * FROM `table` WHERE `id`='".goods()."'");
[/code]

[danielsebas]

Hi, thank you but I cannot make it work I made the code is like this:

[color=blue]function[/color] goods[color=blue](){[/color]
$mod [color=blue]=[/color] [color=navy]$_GET[/color][color=blue][[/color][color=red]'mod'[/color][color=blue]][/color];
  $url[color=blue]=array([/color][color=red]'ventas_materiales_para_construccion'[/color],[color=red]'ventas_equipos_y_maquinaria'[/color],[color=red]'ventas_computadoras'[/color][color=blue])[/color];
  [color=green]foreach[/color]($url [color=green]as[/color] $value){
    [color=green]if[/color][color=blue]([/color]$mod[color=blue]==[/color]$value[color=blue])[/color]{
$total [color=blue]=[/color] [color=red]'5'[/color];
    [color=blue]}[/color][color=green]elseif[/color][color=blue]([/color]$mod[color=blue]!=[/color]$value[color=blue]){[/color]
$total [color=blue]=[/color] [color=red]'0'[/color];
    [color=blue]}
  }[/color]
  [color=green]return[/color] $total;
[color=blue]}[/color]

[color=blue]mysql_select_db([/color]$database_mydatabase, $mydatabase[color=blue])[/color];
$query_rscaracteristicas = [color=red]"SELECT caracteristicas.car_id, caracteristicas.car_ubi_id2, caracteristicas.car_nombre, clasificados.cla_prod_id, clasificados.cla_valor FROM caracteristicas LEFT JOIN clasificados ON (clasificados.cla_car_id=caracteristicas.car_id AND clasificados.cla_prod_id=0123456789) WHERE caracteristicas.car_ubi_id2='"[/color][color=blue].[/color]goods[color=blue]().[/color][color=red]"'"[/color];
$rscaracteristicas [color=blue]= mysql_query([/color]$query_rscaracteristicas, $mydatabase[color=blue]) or die(mysql_error());[/color]
$row_rscaracteristicas [color=blue]= mysql_fetch_assoc([/color]$rscaracteristicas[color=blue])[/color];
$totalRows_rscaracteristicas [color=blue]= mysql_num_rows([/color]$rscaracteristicas[color=blue])[/color];