Subject: Database Management Problem
Posted By: talk2learner Post Date: 12/20/2006 12:18:26 PM
I am feeling problem when I post or retrieve values in/form databas. Function is made by  me which is called by the form page , but values are not posted in database. No error declared by browser:-

function select()
   {
    $qry = "select * from donarinfo where pk_id=7";
    $row=mysql_query($qry);
    $result= mysql_select_db($databaseName);
    return $result;
   }


Reply By: jhanny007 Reply Date: 12/20/2006 2:21:11 PM
hi try like this:

{
    $qry = "SELECT * from donarinfo
    WHERE pk_id=7";
    $result= mysql_select_db($qry)or die(mysql_error());
    $row=mysql_query($result);
    
    extract ($row);
   }

______________________________________
.::If you quit you loss, If you survive you win::.

.::JHANNY::.


Reply By: surendran Reply Date: 12/21/2006 11:47:44 PM
try with this,

$link = mysql_connect('localhost', 'user', 'pass')
    OR die(mysql_error());
 mysql_select_db("databasename",$link)or die("did not select database");
$sql="SELECT * from donarinfo WHERE pk_id=7";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
extract ($row);
}


surendran
(Anything is Possible)
http://ssuren.spaces.msn.com
Reply By: vivekananth Reply Date: 1/25/2007 12:09:39 AM
i am new

Reply By: vivekananth Reply Date: 1/25/2007 12:10:59 AM
how to create a database in mysql through php


Go to topic 55350

Return to index page 53
Return to index page 52
Return to index page 51
Return to index page 50
Return to index page 49
Return to index page 48
Return to index page 47
Return to index page 46
Return to index page 45
Return to index page 44