[CS-FSLUG] sql queries

[Timothy Butler]

Do you have a column that has a numerical id in it, perhaps an index  
column so we can tell for sure which row is row 1 and which is row 2?

	-Tim

On Dec 20, 2008, at 4:11 PM, David McGlone wrote:

> Hi all,
>
> I've been brushing up on my PHP and MySQL and I'm trying to create  
> something.
> :-)
>
> That something is, a database full of text with each ID of the  
> database
> appearing on certain pages. I have accomplished this, but I am  
> having problems
> restricting what appears on each page.  for instance: I have a table  
> named
> site_text and in that table I have 3 fields ID sub_heading and
> sub_heading_text. Let's say I just want the first 2 sub_heading's and
> sub_heading_text id's 1 and 2 to appear on the index page and  
> sub_heading and
> sub_heading_text id 3 to appear on a different page. How could I  
> accomplish
> this? currently what I have come up with is showing all 3 id's on  
> the index
> page.
>
> Here's the query I'm using:
>
> $query = "SELECT * FROM all_text";
> $result = @mysql_query($query);
>
> while ($row = @mysql_fetch_array($result))
> {
>    echo "<h1><span> $row[sub_heading]</span></h1>";
>
>    echo "$row[sub_heading_text]";
>  }
>
> This is displaying as I expected, but it is adding the 3rd row that  
> I do not
> want.
>
> I changed the while loop to an if statement, but got no results. I was
> probably doing it wrong. Also if I take out the while loop, then all  
> the ID's
> that I want to appear on 1 page will not display past the first ID.
>
> Any Ideas?
>
>
> Thanks,
> -- 
> David M.
> http://www.dmcentral.net
>
> _______________________________________________
> ChristianSource FSLUG mailing list
> Christiansource at ofb.biz
> http://cs.uninetsolutions.com

---
Timothy R. Butler | "Do  not forget that  the value and interest of
Editor, OfB.biz   | life is not so much to do conspicuous things...
tbutler at ofb.biz   | as to do ordinary things with the perception of
timothybutler.us  | their enormous value."
                                       -- Pierre Teilhard de Chardin