[pedroso]

Hello!
I'm not a professional programmist, but I create now rather serious project, and -
as You know - sometimes I have problems with php or mysql...
Now I have terribly problem with one mysql query (...) - I need to have
"nr" or "id" in this query, but I can't do it... Everything, what I do - it's always
wrong, incorrect, and - it doesn't work... The part of the script looks like:

//
$question = "select * from data_table where ".$finding_method." like '%".$phrase."%' ORDER BY nr DESC ";
$result = mysql_query($question);
$howmany_founded = mysql_num_rows($result);

echo '<p>The number of founded elements: '.$howmany_founded.'</p>';

echo " ... etc...
//
So, I need a "nr" or "id" in this query, because I have to make the links
with results of this query, and without a "nr" or "id" it doesn't work correctly,
because it "don't know" which rekord of the data table should be displayed...
I try add something like : "and nr=$nr" ( $question = "select * from data_table where ".$finding_method." like '%".$phrase."%' and nr=$nr ORDER BY nr DESC " into query $question, but it still doesn't work...
If You can help me - I thank you very much, if not - I thank you too... bye-bye
Sorry for my english - it isn't my native language, unfortunately - P.P., Warsaw,Poland

[shadi]

hi ,

i don't get what is the problem for sure , but for my knowledge this part of query
"ORDER BY nr DESC"

doesn't matter when calling the function mysql_num_rows();
so better remove it.


what does the variable $finding_method in the query stands for ?


bye

[pedroso]

Hi - thank You for your answer - the script with a part: "ORDER BY nr DESC" works correct (I need, the results in this order), but when I add "and nr = $nr" as a requirement, it doesn't work... You understand - when i get list of results, for example:
result1
result2
result3
etc...
I want the results as a links to the sites, which displayed content of the table, in the way:
result1 - nr (id) of result1, and the rest of the rekords result1
result2 -nr (id) of result2 and the rest of the rekords result2
result3- nr (id) of result3 and the rest of the rekords result3
etc...
If I get results after query, I have "results" only, after that, I need the results should be links (heads of the links) to the sites, which displayed rest of their contents, and in this momment I need the "nr(or id)", because - in other way - the link (which is result of the query) "dont know" which rekord of the data base table should be displayed...

greetings for You - Pedroso

[pedroso]

$finding_method - it means "the way (manner, fashion) of the search in the database..."

[shadi]

did you surrounded the variable $nr with signle quotes ?

example :

$question = "select * from data_table where ".$finding_method." like '%".$phrase."%' and nr = '$nr' ORDER BY nr DESC "

[xtremenw]

The query looks good. The order by will not really hurt anything even if all you do is use mysql_num_rows();. Try running:

Code:

$result = mysql_query($question) or die (mysql_error());

This will tell you what is wrong in some detail. Also, check your error logs which might be easier then using the above query. Also, if you are looking for numbers in the where clause, you do not need to quote them.

Code:

WHERE nr = 1 ORDER BY nr DESC