acctman

thanks for all the tips ... I'm going to find a tutorial on mysqli to bring myself up to speed

can someone assistance me with converting this code over to mysqli. I know that mysqli requires 2 parameters instead of one... i tried $user = mysqli_real_escape_string($g_link, $en['user']); but no connection was passed. $user = mysql_real_escape_string($en['user']); $pass = mysql_real_escape_string($en['pass']); $sql = "SELECT m_id, m_user, m_pass, m_email, m_del FROM $membtable WHERE m_user='".$user."' AND m_pass='".$pass."' AND m_del!=1"; $result = mysql_query($sql); $line = mysql_fetch_assoc($result); Db Connection $g_link = false; function GetDbConn() { global $g_link; if( $g_link ) return $g_link; $g_link = mysqli_connect($db_server, $db_user, $db_pass) or die("Error " . mysqli_error($g_link)); mysqli_select_db($g_link, 'cialdb') or die('Could not select database.'); return $g_link; }

after re-reading your response I found the problem. I did not have the database in $con... the error checked worked.

but I have if (mysqli_num_rows($loadSession) == 0) { to had if it's 0 (false). Am I missing something?

I'm trying to resolve these to mysqli update changes. I've rewritten the statements a few times but just keep receiving errors. Can some show me how to rewrite the mysqli_result() correctly. - thanks Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in $loadSession = mysqli_query($con, "SELECT smo.* FROM social_members_online AS smo LEFT JOIN social_members AS sm ON smo.o_id=sm.m_id WHERE smo.o_id='".session_id()."' ...); $result = mysqli_fetch_assoc($loadSession); // Check the Result if (mysqli_num_rows($loadSession) == 0) { // User has no session, create one mysqli_query($con, "INSERT INTO social_members_online (o_id,o_start,o_last,o_session_id,o_ip) VALUES (".(int)$_SESSION['userid'].", ".time().",".time().",'".session_id()."','$ }

can someone help me change this to preg_replace_callback. i'm receiving the following error Warning: preg_replace_callback(): Requires argument 2, '@constant("\1")', to be a valid callback in //load current language foreach ($langs as $key => $value) if ($value['l_code'] == lang) break; $f = fopen('languages/'.$langs[$key]['l_file'],'r') or die('Cannot open language file '.$langs[$key]['l_file']); while (!feof($f)) { $s = chop(fgets($f,4096)); if ($s{0} == '#') continue; list($key,$value) = explode('=',$s,2); $value = preg_replace('/<%(.*)%>/sUe', '@constant("\\1")', $value); $def[$key] = $value; } fclose($f);