6 replies to this topic

[techker]

hey guys my script was working fine all month..now today i try it out and it gives me an error?

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/openshar/public_html/check.php on line 12
You'll be redirected to your Home Page after (2) Seconds in energie

Unknown: Your script possibly relies on a session side-effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a source of data, unless register_globals is enabled. You can disable this functionality and this warning by setting session.bug_compat_42 or session.bug_compat_warn to off,

my code

<?php


$myusername=$_GET['user'];

require('config.php'); 

// Connect to server and select databse.


mysql_connect("$host", "$dbusername", "$dbpass")or die("cannot connect");

mysql_select_db("$dbname")or die("cannot select DB");


$sql="SELECT *  FROM 'members' WHERE 'username'= '$myusername'";

$res3 = mysql_query($sql);

$row3 = mysql_fetch_assoc($res3);



?>


<?


 { 

echo "You'll be redirected to your Home Page after (2) Seconds in <b>$myusername</b>";

          echo "<meta http-equiv=Refresh content=2;url=".$row['directory_name'].">";

		  }

?>

it just basicly grabs the user that logs in and gets the path to his folder in a database...

[techker]

so what happend?i know i modified it when it stopped working but it's about the same..

so whats wrong?

[techker]

ok but why was it workiing before??

[techker]

shure i did.the $_GET is in the login form.

cause the login forms goes to a check login to see ho is login in.sessions.

afther i made a check.php page to check ho is login in to redirect him in the good folder.

cause in the databse when i register a new memeber i creat a folder with his information and what he needs in it.so every memeber has a diffrent level of scripts.

so the get users name and seclects the information in the databse.

just by replying to this i realized that i should of but it in the check login page..