shirvo Posted December 12, 2006 Share Posted December 12, 2006 $sql = "SELECT password FROM users WHERE username = '".$_POST['username']."'"; $result = mysql_query($sql);$password= mysql_fetch_array($result)That is how i would normally do it with MYSQLbut how do i do it with peari have this so far but what do i add to fetch$get_pass = $db_object->query("SELECT password FROM users WHERE username = '".$_POST['username']."'"); if (DB::isError($get_pass)) { die($get_pass->getMessage());} Quote Link to comment Share on other sites More sharing options...
drifter Posted December 12, 2006 Share Posted December 12, 2006 are you using like DB or MDB2? Quote Link to comment Share on other sites More sharing options...
shirvo Posted December 12, 2006 Author Share Posted December 12, 2006 DB but if you know both of them then you can give me both Quote Link to comment Share on other sites More sharing options...
drifter Posted December 12, 2006 Share Posted December 12, 2006 in my conn file I use$db->setFetchMode(DB_FETCHMODE_ASSOC);immediately after my connection this means I can use $res =& $db->query($sql); while($myrow =& $res->fetchRow()){ }and all the rows will be assoc arrays. - for the rare time I want something other then the assoc array, there is a way to override the fetch more for that one instance (not sure what that is, but it is in the docs.)Also, if you are just starting an app, go with the MDB2 - DB is stopped future updates, so switch now - looks like almost a drop in replacement, however I have not done it yet. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.