[Ported Valhalla]

Just wondering if anyone had any pointers for a problem I've got.

I've got 2 tables within my db (results and fixtures)

The results table is added to each time a game takes place.

Is there way of linking the 2 tables so that when a result is added, the script sees the id or similar field and displays the next fixture.

Ie: If the id of the last result is 3 then is there a way to display id 4 from the fixtures table.

So, in sum, whatever id the latest entry in the results table is, the id of the entry requested from the fixtures table needs to be 1 higher.

Hopefully, I've made myself understandable without being to vague.

[NeverMind]

yeah that's possible and even easy
all you need is something like that :

PHP Code:

$check=mysql_query("SELECT id FROM results WHERE id='$the_last_id_sent'")or die(mysql_error());

$id=mysql_fetch_row($check);



settype($id[0], "integer");//convert the id into integer

$new=$id[0]+1



/*now we fetch the next fixture */

$bring=mysql_query("SELECT nextfixture FROM fixture WHERE id='$new'")or Die(mysql_error());



$fixture=mysql_fetch_row($bring);



echo $fixture[0]; 

I assumed that you know the last ID of the result ..

[NeverMind]

just incase you are not aware of the last id of the resutl .. you could just use the max() in the first SELECT statment .. like this :

PHP Code:

check=mysql_query("SELECT max(id) as last_id FROM results")or die(mysql_error()); 

and the rest is the same ..
this time I assumed you are using auto increment in your ID number .. so it would take the highest id number ..