mySQL Query problem

Mikalux

Hello!

I have a problem, and don´t know to fix it...

I generate via php a query string for mysql:

$Selektiert="SELECT * FROM ".$Tab_bilder." WHERE ".$MyString." ORDER BY Galerie desc LIMIT $Offset, $Limit";

echo $Selektiert:

"SELECT * FROM art_bilder WHERE Galerie='1' OR Galerie='3' OR Galerie='4' ORDER BY Galerie desc LIMIT 0, 10"

If I echo the $Selektiert String and put it in phpmyadmin, all is working fine, if I code this string direct in the php page it is working too.

Only the "generated" string isn´t working in the page, but in phpmyadmin

Sorry, about my worse english!

Thank you!

Mikalux

hand

Do you connect to the db without errors? (hostname, userid, passwd)
Do you select the correct database?

Somewhere in the skript you execute your select-statement with mysql_query(). Please add there an "or"-command to print out a mysql error. Make it like this:

$Selektiert="SELECT * FROM ".$Tab_bilder." WHERE ".$MyString." ORDER BY Galerie desc LIMIT $Offset, $Limit"; 
$result = mysql_query($Selektiert)
	or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

Let us know, if there an error is displayed now.

Das Select-Statement ist syntaktisch voll in Ordnung. Vielleicht bringt der Einbau des or weitere Erkenntnisse, schaun wir mal ...

Mikalux

... for your reply!

I made a silly mistake and found it.

In the string was a "nbsp;" :0(

Greetings,

Mikalux