Help on MySQL result

[takuma]

What happens if you have code like this:-
$sql = "SELECT column1, column2 FROM table WHERE condition == condition2";
$temp = mysql_query($sql);
$result = mysql_fetch_array($temp);
What will the $result would be, and how do you know the value of column1 and column2?
(This only returns one field).

Regards,

Takuma

[mrmufin]

First, testing for equality in SQL statements does not use two ==, just one, so your $sql variable should read like:

$sql = "SELECT column1, column2 FROM table WHERE condition='condition2'";

Next, since you're fetching an array from the MySQL result set, the values need to be processed as an array:

$temp = mysql_query($sql);

while($result = mysql_fetch_array($temp)) {
$column_1_value = $result[0];
$column_2_value = $result[1];
}

// Alternatively:
while($result = mysql_fetch_array($temp)) {
$col_1_val = $result["column1"];
$col_2_val = $result["column2"];
}

[Anon]

Thanks for you post "mrmufin". But how would new get the value of 2 columns when you have more than 1 result?

will you access it like $result["column1"][0] etc?

Regards,

Takuma Habu

[mrmufin]

$sql = "SELECT foo, bar, baz FROM table WHERE foo='jake'";

// Get a result set handle:
$r = mysql_query($sql);

// Get the number of rows in the result set:
$n = mysql_num_rows($r);

// Loop through each row in the result set
for($i = 0; $i < $n; $i++) {
while($data[$i] = mysql_fetch_array($r)) {
// business as usual
$current_foo = $data[$i]["foo"];
$current_bar = $data[$i]["bar"];
$current_baz = $data[$i]["baz"];
}
}

// Alternatively, make a second array to store your result arrays:

$my_results = array();
while($data = mysql_fecth_array($r)) {
$my_results[] = $data;
}

Remember that each element of $my_results is an array...

Have fun...

[Anon]

Thanks very much!

[mrmufin]

You're quite welcome.

Have fun...

[Anon]

$array contains the result of query and then first result.
if ya want to iterate through the array simply use
while ($result = mysql_fetch_array($temp){
echo $col1 = $result['colume1'];
echo $col2 = $result['colume2'];
}

thats it

Rgds
Mandar