PHP/MySQL

[anuj_web]

hI

Is there something wrong with the code

$result = @mysql_query("SELECT * FROM dc WHERE DCID='$id'");
$pass1=mysql_result($result,"pass" );
$phone=mysql_result($result,"phone" );

Actually i want to fetcha row from the database and take data from that row ....

this is not working...

 

[LHVWB]

Why the '@'?

This link shows another way of doing it, its more complicated but more useful also, especially if you just want to get data from a particular row.
http://hudzilla.org/phpwiki/index.php?title=Reading_data

 

[anuj_web]

can u please explain the code...its just goin' o'er my head

while ($row = mysql_fetch_assoc($result)) {
print "Row $rowcount<br />";

while(list($var, $val) = each($row)) {
print "<B>$var</B>: $val<br />";
}

print "<br />";
++$rowcount;

 

[LHVWB]

Here's a better example for what you need.

$result = mysql_query("SELECT * FROM dc WHERE DCID='$id'");

// Make sure that there is a result from the table
if ($result && mysql_num_rows($result))
{   
   //    Loop through all the results
    while ($row = mysql_fetch_assoc($result))
    {
        //    Store the information from the current row.
        $pass1=$row['pass'];
        $phone=$row['phone'];
    }
}

 

[anuj_web]

I can understand this better,thanks

works beautifully ....

One more thing ..do i need to set variables back to null everytime i load the PHP file or it happens by its own..if yes then wat should i do
$var=0
or
$var=''

 

[konekt]

I can understand this better,thanks

works beautifully ....

One more thing ..do i need to set variables back to null everytime i load the PHP file or it happens by its own..if yes then wat should i do
$var=0
or
$var=''

Every time a script is loaded all the variables are as they were when you first coded it (reset).