9 replies to this topic

[yonghan]

Hi all,i'm wondering how to use mysql_fetch_array inside function..Suppose i create a function which i'm intending to get the values in a row.I got no problem without using function..Here is my code :

<?php

$member=$_SESSION['id'];

$sql="Select email,nama,alamat,kota,propinsi from users where member_id='$member'";

$exec=mysql_query($sql);

$result=mysql_fetch_array($exec);

?>

<form id="edit" name="edit" method="post" action="">

<label for="email">Email</label>

<input type="text" name="email" id="email" value="<?php echo $result['email'];?>"/>

<div class="spacer"></div>

</form>

Is it possible to use a function to fetch array?Thanks guys...

[Brandon W]

function return($sql) {
        $exec = mysql_query($sql);
        $result = mysql_fetch_array($exec);
        while($row = mysql_fetch_array($exec) {
            echo $result['nama'];
            echo $result['email'];
        }
        return true;
}

$query = "SELECT `email`, `nama`, `almat`, `kota`, `propinsi` FROM `users` WHERE member_id = '$member'";

echo return($query);

NOTE: This function will only work if you are echoing the right results in the PHP function. Let's say you might of wanted to execute the sql query that return the results email and almat. But in this function it returns nama and email. You could change this with a few modifications.

This should work :)

[mikelbring]

I am not sure if printing a string from the function and then returning true is such a good idea. Id have to maybe return a array with the information and then print it.

[Orjan]

and can you really create a function named return? return is a reserved word, I believe?

[mikelbring]

I didnt even think about that, probably not. To lazy to go test it.

[Brandon W]

OK well if return is a reserved work, you can use whatever you want, that isn't a reserved word ;)

[yonghan]

Thanks a lot guys..I'll try it out..Anyway,where can i find the tools to mark threads as solved??

[Brandon W]

Not really, there is no need. Because people will still come here asking a similar question and they could get the answer. And if yourself need further help, we can still help you :)

[yonghan]

Ok brandon..Thanks a lot..May God bless you..

[Brandon W]

Your welcome mate, just helping a fellow member :)