tm

Hey,

Im trying to find a string in a database.

I KNOW the string is there, i can find it easily in phpmyadmin.

I'm DEFINATELY connecting to the database, otherwise the script would die().

I've checked that everything is spelled correctly.

so WHY is it returning 0 numrows?!? There's definately a good two or three in the database (WHERE string='$q').

I've turned on error reporting
error_reporting(E_ALL);
but nothings coming up.

Me and several other people are STUMPED, so I need help!

thanks,

tm

Please register or log-in into NamePros to hide ads

__________________

ninedogger

whats the whole query?

__________________

Want to prove yourself?

My Domains

Xyzer

I dont know, we would have to see the code!

Palyriot

use echo $q to make sure that $q isn't blank or something like that. Just check the small things. Also, instead of using $q, try an actual word instead of a variable. Will show you if it's a problem in the variable. Sorry if this doesn't help, but I tried.

Dan

If the row has more than just $q in it, that won't work.

Use:

monty

What I always do in a situation like yours, I just echo the query and run the same query in phpMyAdmin. Then you usually find out in a couple of seconds what's wrong with the original query.

If you don't give us your code/query, there's not much else we can do.

best of luck!

-monty

__________________
ReportATerrorist.net -- myBlog -- Peaches International

-Nick-

well if you are finding it in phpmyadmin then just clikc the create php code link on the top and copy-paste it.

__________________

tm

Here is the code:

$query = "SELECT * FROM `table` WHERE string = '$q'";
$result = mysql_query($query) or die("Query failed 2: " . mysql_error());
$num = mysql_numrows($result);


there is nothing else in that table part other than $q (not even spaces).

I do die($q) and it echoes the string.

__________________

SecondVersion

Your problem is quite simple:

__________________

tm

Still doesnt work.. :S

__________________

sdsinc

So you have a field called 'string' in your table ?
Isn't it a reserved keyword ? Be careful when using reserved keyword in field names as this can lead to unpredictable results.
Did you try your query in phpmyadmin ?

tm

Yes string is in the table.

Whats a reserved keyword? :s

Query in phpmyadmin returns:
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0248 sec)

__________________

aznchong91

then there is something wrong with the query. Can you echo the query and paste it here?

__________________

-----------------------------------------------------
|-----FREE BANNER EXCHANGE! 1:1 RATIO!!!!-----|
|-------------www.bannercenter.info-------------|
-----------------------------------------------------

Flubber

Try the following.



Run the query in phpmyadmin, and see what happens.

Flubb

Dan

If sdsinc is right, you need to change the name of it from string to something else.

Tree

MySQL Manuel entry for reserved words.

__________________
NCIDev.com

tm

It's not actually string.. sorry for confusion, its actually a different (non-reserved) word.

Flubber, i changed the query to that and it still doesnt work... not sure where you're supposed to run php in phpmyadmin though :S

__________________

Dan

Then $i will be the total number.. you shouldn't have to do this except you won't tell us the full code, or even the name of the row..

tm

OK here's basically the code i have atm:



It always echoes:

$q (eg A)
No Results Found

even though $q is DEFINATELY in the database

__________________

Dan

I think I know what it is.

Replace
$query = "SELECT * FROM `table` WHERE strng = '".$q."'";
With
$query = "SELECT * FROM table WHERE string = '$q'";

tm

Still no..

__________________

SecondVersion

Like many have mentioned, echo $query and paste it here.

__________________

ninedogger

escape the $ sign

__________________

Want to prove yourself?

My Domains

Dan