Keep database results as variable?

[squallm1]

Hi, I need to keep the results of a search as a variable to send it by email.

The code for the web page is:

<?php do { ?>
<p><?php echo $row_Recordset1['id']; ?><br>
<?php echo $row_Recordset1['identificador']; ?><br>
<?php echo $row_Recordset1['tipo']; ?><br>
<?php echo $row_Recordset1['descripcion_c']; ?> </p>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

I have not idea how to do it, I tried as:

<?php $resultado = " do {
$row_Recordset1['id'];
$row_Recordset1['identificador'];
$row_Recordset1['tipo'];

$row_Recordset1['descripcion_c'];
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>"

But nothing.

Any suggestions?

Thanks a lot.

Miguel Mendez.

[cgraz]

The following will email all the records in the database to you:

$body = "";
$to_address = "[e-mail]";
$subject = "Message Subject";

$query = mysql_query("SELECT * FROM yourtable");

while ($a_row=mysql_fetch_array($query)) {

$body .= "ID: " . $a_row["id"] . "\n";
$body .= "Identificador: " . $a_row["identificador"] . "\n";
$body .= "Tipo: " . $a_row["tipo"] . "\n";
$body .= "Descripcion: " . $a_row["descripcion_c"] . "\n\n";

}

mail($to_address, $subject, $body);

If you only want the first record emailed to you, [either] delete the while loop or SELECT * FROM yourtable WHERE id=7 (for example).

Cgraz

[squallm1]

Thanks a lot cgraz!

It worked great!!

Miguel.

[cgraz]

No problem 😉

Cgraz