I know i have asked a lot of questions here, but its teaching me new things, and you guys seem to know everything that i need to learn, and i can answer my questions myself.

I have two MySQL tables in my database;
itzeddie_pilot
itzeddie_flights

Both the tables have a varchar called "rank". I am viewing a route page, i need a php code to check the rank on the pilots table where the callsign currently in use (pilots id assuming im logged in), and then check the currently viewed flight rank is the same and if they are then it makes an echo of some random text.

Note; If anyone is willing to also add this, i have 7 other "columns" in my itzeddie_flights table, 'Monday, Tursday, Wednesday, etc'. If possible i would like it to check the current day and if also active marked by a "1" in the table then the text echo's.

I would find a way of doing it myself, or find a new method, i however i am quite tired, and it would be easier to learn the right way from you folks.

Would something like this start you off?

php code:

---

<?php
$id = "blah1" // Replace with Flight ID being viewed
$rank = "blah2"; // Replace with logged in user's rank
$rs = mysql_query("SELECT rank FROM itzeddie_flights WHERE id='{$id}'");

if(mysql_result($rs, 0, "rank.itzeddie_flights") == $rank)
{
  echo("random text!");
}
?>

---

Find me on WLM sometime in the next 6-8h and I'll give some help

quote:

---

Originally posted by MeEtc
Find me on WLM sometime in the next 6-8h and I'll give some help

---