mySQL, php and $result

[kikidonc]

Hiya!

I'm learning php and mySQL.
I already know basics about how to connect a DB, how to fetch the result and have a quite "nice" page.

($result = connect_db($db,$query)😉

Now, my problem is that I want to use a result several times to built my page. But I can't fetch twice the result (maybe because of a pointer system or...).

Does anyone know how I could avoid connecting twice my db to get exactly the same data? maybe a kind of function like "cursor_move_first()"... I saw nowhere anything about that :-(

I would be very glad to hear that someone do :-).

Thank you very much,
Fred.
[e-mail]

[Anon]

mysql_data_seek($result, 0)

[aspbyte]

hi

Try this

// create a connection
$connection = mysql_connect($host,$dbunmae,$dbpass);

//select the DB

mysql_select_db($dbname);

save this info as connect.php

now include this file with all the DB query pages

// As in

include "$connect.php";

To use this

$result = mysql_query($sql,$connection) or die mysql_error();

// Hope this is fine

Pradeep

[kikidonc]

Dear Craig H,

Thank you very much for your help, It's exactly what I was looking for and it works perfectly well.

All the Best,

Fred.

[Anon]

please ignore

[Anon]

another test