Posted by Rik on 10/26/06 19:03

bokke wrote:
> Hey Rick,
>
> I have always used
> <a href="Contributor.php?action=&SubCat=<?php echo $row["writer"];
>> "><?php echo $row["writer"];?></a>
> to feed the variable - and then used
> $query = "SELECT * FROM news WHERE writer='$SubCat' ";
> - I only use POST and GET with forms - not simple links.
>
> -"quote strings" - not sure which string you would like me to quote?
>
> -as for
> "> - Offcourse, there's always spelling errors.
>> - Echo the query-string, to check wether the query is built correctly
>> (which it wasn't in this case).
>> - Use backticks around field- and tablenames
>> - Echo mysql_error(), and check what it sais."
>
> -Checked the spelling again and again - but thats not it
> -I use or die ("no can do."); so I know when it's not working - in
> this
> case it works just not reading the variable. Again, if I change the
> WHERE writer='$SubCat' "; to WHERE writer='Bob Smith' "; it works
> fine ???
>
> and as for "blindly post this to a newsgroup/forum" man - I am on day
> two of this problem - you can only spell writer so many ways before
> you realize it is not spelling. I think I have exchased all my tricks
> ... it must be a header issue or a .... damn i just don't know?
>


Well, it would help a lot if you:
echo $query;
echo mysql_error();

And come back to us with that.
An or die() construct is fine, but if something indeed goes wrong, one
would like to know what, not just 'something'. You could temporarily make
it or die(mysql_error()); (do not do this on production servers...).
--
Rik Wasmus

[Back to original message]