Help me fast pleas! :)

Anon

Why do I get this error? :" Notice: mysql_db_query is deprecated; use mysql_select_db() and mysql_query() instead in "

Anon

maybe cause you are using mysql_db_query() to perform your query, you should just use mysql_query(), that should fix the problem. hope this helps.

Anon

Yes, I tried that, but I just got more errors.. " Warning: Wrong parameter count for mysql_query() in C:\Inetpub\wwwroot\iwcommunity\community\default.php on line 15

and

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\iwcommunity\community\default.php on line 17
" HELP!

dc2_jspec

why don't you paste a snippet of your code that contains you connecting, building your query, and fetching your array. That would probably help us help you!

Anon

<?php @session_start();
@$user = $iwcuser;
@$pass = $iwcpass;

  if(!$user) {

     echo("<script language=JavaScript>"); 
     echo("self.location.replace('http://localhost/iwcommunity/login/ouch.php')"); 
     echo("</script>"); 

  }

  $open = mysql_connect("localhost", "iwcommunity", "iwcx");

  $info = mysql_db_query("iwcusers", "SELECT * FROM users WHERE username = '$user'", $open);

  $rad = mysql_fetch_array($info);

     if($user == $rad["username"] & $pass == $rad["password"]) { ?>

<?php // top.inc ?>
<?php require ('c:\inetpub\wwwroot\iwcommunity_inc\top.inc'); ?>

and

<?php $x = 0;
$oppna = mysql_connect("localhost", "iwcommunity", "iwcx");
$sql = mysql_db_query("iwcusers", "SELECT * FROM users ORDER BY id", $oppna);

     while ($rad = mysql_fetch_array($sql)) {
     $x = $x + 1;
     } 

     mysql_close($oppna); ?>

dc2_jspec

Instead of this:

$info = mysql_db_query("iwcusers", "SELECT * FROM users WHERE username = '$user'", $open);

Try doing this:

$sql = "SELECT * ";
$sql .= "FROM users ";
$sql .= "WHERE username = '".$user."'";

$info = mysql_query("iwcusers", $sql, $open);

--I believe you are getting the variable (user) messed up while doing the query. The single quotes around it will not evaluate a variable, it will actually display $user instead of the value of $user. Also, looks much cleaner this way...hope this helps, and let us know if it works.

dc2_jspec

actually, I just tested what I just told you and unfortunately I was wrong...it might be that first mysql_fetch_array(), I am not sure...Give me a sec to test it.

dc2_jspec

ok, here is my last suggestion, sorry if it doesnt work, but atleast I tried, right? Anyway here it is:

try changine your mysql_query() to just the following:

$info = mysql_query("SELECT whatever ...");

$info = mysql_query("$sql");

and you might have to change your top mysql_fetch_array to be in a "while" loop to use it that particular way, just like you did at the bottom. I am not sure though. Well, I hope this helped you a little.

Anon

Ok, Tnx VERY much for your help, I gonna test it right now.. 🙂 /Alex

okyejr

actually,the function mysql_db_query() is not supported by the php if the version is greater then 4.2.1

Anon

But if I change to a older php version, should it work then?