i dunno why this query doesn't function..




any suggestion???

try the above code.

doesn't function....

but thank u so much avalon

Try this:-



or this:-



if it still doesn't not work, i will have to get back to you later today or tomorrow.

Maybe you're not doing the query, you're just setting $query to $sql, you have to use $query = mysql_query($sql) or die("Maybe you were right?");

Other than this, I can't see a problem.


MC

See from your query, I figure you are trying to match up the contents of the variable $no_ficha with the table columns participantes.No_Ficha and sancionados.No_Ficha. the query is perfectly fine and wouldn't even need the open-close quotes (``) around the table/column names as shown here.

My guess is where you are going wrong is the open-close quotes ('') around the $no_ficha.... if you want to match the contents of $no_ficha with your table columns, then you have to enclose $no_ficha in double quotes ("$no_ficha") for PHP to be able to parse it as a variable and extract and use its value. Between single quotes, $no_ficha is treated as a string and you query is trying to find a string called $no_ficha in your tables... Try with double quotes and see....

I think breaking up the query like this would help:

$sql="SELECT count(*) FROM participantes,sancionados WHERE participantes.No_Ficha =" . "$no_ficha" . "or sancionados.No_Ficha = " . "$no_ficha";

...
...
And next check your syntax and add what mastercomputers wrote...
- coz it seems from your syntax that you aren't doing to query at all...

I see where you're coming from microscopic^earthling and I did too pick this up.

The only thing if I can explain it to you is that the single quotes are inside double quotes, meaning they play no importance other than being single quotes in a double quoted string.

Because the double quoted string is used and there's no closing prior the single quotes, the variables will be processed by PHP as variables inside that double quoted string and not as if they were singluarly quoted.

e.g $double_quoted = " '$hello' "; produces 'the_element_contained_in_hello' with the quotes. If it were only $single_quoted = ' "$hello" '; produces only "$hello", with the double quotes around it and not what's contained in the variable $hello.

You need to use those quotes in those statements though, so never leave them off.

MC

Righton thanks for clearing it up...it got a little fuzzy seeing so many quotes flying around

// Added Aliases just to avoid those big lengthy names

Check the Following,
The Column names are Case-sensitive and they are properly written.
If the things still dont work, Would you please put down the error statement reported by the "mysql_error()" function.

-OpaQue

a part of my code...




the insert query doesn't function either ...

thank u guys ...


greetings from México City