[FuzzyLogik]

Perhaps my problem is I cannot echo the value, as it returns a resource ID.

Here is my code:

if ($word != "") {
        if ($word == "encyclopedia") {
        echo("

Welcome to the encyclopedia!  Here you will find the meanings of key phrases, such as JavaScript, CSS, and XML.  Remember, you can always access words in the enyclopedia by appending it to the url, e.g. \"http://phazm.net/AJAX\". This will bring up the description of that word.  Enjoy!"); } else {
        $spaces = array("%20", " ", "_", "+", "-", ".");
        $word = str_replace($spaces," ",$word);
        require_once($includes . "connect.php");
        $query = "SELECT * FROM resource WHERE title = '" . $word . "'";
        $result = mysql_query($query);
        $number = mysql_numrows($result);
        $row = mysql_fetch_row($result); 
        $wordid = $row[word_id];
        echo($row . "- Row
WordID is " . $wordid);
        if($number != 0) {
        $query = "SELECT * FROM redirect WHERE word_id = '" . $wordid . "'";
        $result = mysql_query($query);
        $number = mysql_numrows($result);
            if($number <= 1) {
            echo($result);
            } else {
            echo("There are " . $number . " entries for " . $word . ".");
            }
        } else {
        $word = str_replace($spaces," ",$word);
        echo("<h2>" . $word . "</h2>

We have no documentation for " . $word . ".  Please check back later.</p>");
        }
        }
        }
    ?>

Most of that you don't need, but to put at ease those who say "SHOW THE FULL CODE!" - there ya go

Basically, I want to return the ID of the first call.

Search for: Search Engine Optimization

"Search Engine Optimization" is in "title" column of "resource" table, and it's ID (auto_increment) is 8.

How do I get 8?

If I am confusing you, I will rephrase, just ask

Thanks

[office politics]

use mysql_fetch_assoc() to retrieve row results
http://www.php.net/manual/en/functio...etch-assoc.php

PHP Code:

<?php

$conn = mysql_connect("localhost", "mysql_user", "mysql_password");

if (!$conn) {
   echo "Unable to connect to DB: " . mysql_error();
   exit;
}
  
if (!mysql_select_db("mydbname")) {
   echo "Unable to select mydbname: " . mysql_error();
   exit;
}

$sql = "SELECT id as userid, fullname, userstatus 
       FROM  sometable
       WHERE  userstatus = 1";

$result = mysql_query($sql);

if (!$result) {
   echo "Could not successfully run query ($sql) from DB: " . mysql_error();
   exit;
}

if (mysql_num_rows($result) == 0) {
   echo "No rows found, nothing to print so am exiting";
   exit;
}

// While a row of data exists, put that row in $row as an associative array
// Note: If you're expecting just one row, no need to use a loop
// Note: If you put extract($row); inside the following loop, you'll
//      then create $userid, $fullname, and $userstatus
while ($row = mysql_fetch_assoc($result)) {
   echo $row["userid"];
   echo $row["fullname"];
   echo $row["userstatus"];
}

mysql_free_result($result);

?>