I'm trying to display specific rows from my database. I've played around with my code for a while, but just can't seem to get it working. Here's an example of what I've tried:

do { echo $row_ClientsRS['ClientName']; } while ($row_ClientsRS['CategoryID'] = 1);

The clients are all put in Categories and associated using 'CategoryID'. I just want to be able to change what the CategoryID is in my php code to display the specific category I want.

___________________________________
* Sorry... how do you do that again?... *

ive been using php for like a week, but shouldn't this go in a variable as a query?

forgive the syntax, but maybe something like this

<pre id=code><font face=courier size=2 id=code>
$categories = mysql_query("SELECT * FROM yourtable WHERE CategoryID = 1";

for($j = 0; $j &lt; mysql_num_rows($categories); $j++)
{
$category = mysql_fetch_array($categories);

echo ......
}
</font id=code></pre id=code>

regards

Dave Thomas
<b>DMX Zone Manager</b>

Ah yes, that makes sense. I'll give it a go. Thanks <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

___________________________________
* Sorry... how do you do that again?... *

now that ive just read that post again my answer was soooo wrong :/

regards

Dave Thomas
<b>DMX Zone Manager</b>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>now that ive just read that post again my answer was soooo wrong :/ ....Dave Thomas<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Fix it! <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

Not quite sure, but I think I worked it out. Thanks all the same though <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

___________________________________
* Sorry... how do you do that again?... *