query construction help please

knickerlas

Hi folks,
Could some on help me make a query to select all the records as indicated below

TABLE

ID LINK

1 NULL // this one I have already
2 1 // need this
3 2 // and this
4 3 // and this
5 NULL // but not this as its a new 'series'

Thanks

Nick

trellie

select id from table having (link, NOT NULL)

knickerlas

Sorry, should have mentioned that the table extends in a similar fashion so that would return results outside of the series!

Nick

Anon

hey hey its a emergency

i need a help on how to display the output pagewise i mean if a result of query is huge and i want to display it 10 at a page and rest to another page i think php god got it please help me?????????

knickerlas

what?

knickerlas

Had to use multiple queries

function content_series_links($page_id) {

/ First all the error checking /

$this->verify_integers($page_id);
$qry="SELECT  prev, title FROM ";
$qry.="$this->master_table WHERE ";
$qry.="page_id = '$page_id'";
$result=mysql_query($qry);
$row=mysql_fetch_array($result);
if(!$row["prev"] || $row["prev"] != NULL) {
	return FALSE;
}

// set the first element based on the input id.
$links[$page_id]=$row["title"];

$continue=TRUE;	// Flag signifies data is to be added to links array
while($continue) {
$qry="SELECT prev, page_id, title FROM ";
$qry.="$this->master_table WHERE ";
$qry.="prev = '$page_id'";

$result=mysql_query($qry);
$row=mysql_fetch_array($result);

if ($row["prev"] != $page_id) {	//if its not linked thats the end of the loop
	$continue=FALSE;
	} else {
		$links[$row["page_id"]]=$row["title"];	//add link to array
		$page_id=$row["page_id"];
		$continue=TRUE;
	}

}
return $links;