[PHP is being stupid ... "undefined" function exists]

the purpose of the function is to see if the current part of the site is restricted. the name of the page in question is passed via the $page variable.

$restrict is the name of the page that cannot be viewed

the first if statement checks to see if the given page is resricted

the second sees if the whole site is restricted

[PHP is being stupid ... "undefined" function exists]

index.php
[code]
<?php
require ("http://inc.johnluetke.net/site_status.php");

if (isRestricted("home")) {
    include ("http://inc.johnluetke.net/unavailable.php");
    die();
}
?>
[/code]

site_status.php
[code]
<?php
function isRestricted ( $page ) {

    $restrict = "home";
    
    if ($page == $restrict) {
        return true;
    }
    else if ($restrict == "all") {
        return true;
    }
    else {
        return false;
    }
}
?>
[/code]


when loading index.php, PHP tells me that isRestricted is undefined....am i missing something?

[Wierd MySQL Problem]

wow...changing the encoding of the file worked perfectly, thanks sasa...thats the last thing i would have tried to do.

ps. don't assume thats everyone uses windows (notepad) :P

[Wierd MySQL Problem]

[!--quoteo(post=352848:date=Mar 8 2006, 06:08 AM:name=XenoPhage)--][div class=\'quotetop\']QUOTE(XenoPhage @ Mar 8 2006, 06:08 AM) [snapback]352848[/snapback][/div][div class=\'quotemain\'][!--quotec--]
That error means that no rows were returned. Basically, you queried the database and it returned nothing. You failed to check the number of return rows and assumed something came back. Because it didn't any further calls to work on the result (fetch row, etc) will fail.
[/quote]

Yes, I know this. An empty resultset is empty. (0 rows, I performed check with mysql_num_rows())

[!--quoteo(post=352848:date=Mar 7 2006, 09:51 PM:name=johnl1479)--][div class=\'quotetop\']QUOTE(johnl1479 @ Mar 7 2006, 09:51 PM) [snapback]352848[/snapback][/div][div class=\'quotemain\'][!--quotec--]
But wait, it gets even better. When i take the above query, and run it through phpMyAdmin, i get the desired result. the id number is returned. What gives?
[/quote]

As you can see what from i said, the data does exist in the database. The exact same query in phpMyAdmin returned the desired result.

--EDIT--
What do you mean by wierd characters? i have checked the page from multiple computers running different O/S's and different browsers, nothing shows wierd characters

[Wierd MySQL Problem]

Ok, so here's my scenario:

I have a text file that contains data structered kind of like a database, each line is a different row. One element of the row, column #4, contains a string. I have a table in my database that associates the string with and id number. Using a foreach loop (every line of the file), i am trying to extract that string, run a mysql query, and retrieve the id number from the database. Here is the query from one of the lines of the file (using a php echo statement)

[code]
SELECT * FROM albums WHERE name = 'Away From the Sun'
[/code]

See the query? No syntax errors at all. Now, when I execute that query with a mysql_query() function, all goes well. No errors. Now, when i take the resultset from the query and put it into mysql_result, i get and error that says [b]Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 4 in /home/john/public_html/music/upload.php on line 17[/b]. But wait, it gets even better. When i take the above query, and run it through phpMyAdmin, i get the desired result. the id number is returned. What gives?

Here is the code of the file:

[code]
<?php

$file = "Music.txt";

$source = file($file);

mysql_connect("localhost","john","********************");
mysql_select_db("john_music");

for ($i = 1; $i < count($source); $i++) {

    $data = explode("    ",$source[$i]);
    
    $sql = "SELECT * FROM albums WHERE name = '".$data[3]."'";
    $resultset = mysql_query($sql);
    echo "> > $sql<br />";
    echo $resultset."<br />";
    echo "> > ".mysql_result($resultset,0,'id')."<br />";
    
    $sql = "INSERT INTO songs VALUES ('','".$data[0]."','".$data[3]."','".$data[10]."','','','')";
    echo $sql . ";<br /><br /><br />";
}

?>
[/code]

and here is the output that i get: [a href=\"http://johnluetke.net/music/upload.php\" target=\"_blank\"]Click For Script Output[/a]

What gives?

[Changing include() path]

i modified the php.ini file to have the new include path, but it inst changing. GAH!!!

 

i want the path to be '/home/wagnerg/public_html/php_inc' but the phpinfo() shows '/usr/lib/php' as the include path. HELP ME!!!

 

php: v. 4.3.11

os: linux