Retrieving Data from MySQL.

[DamienRoche]

I am totally confused about how to go about this.

 

Say someone has just entered some details on my web page, they submit and the data is put into a database and assigned a unique id. How do I pull there information in a single row of the table using that id?

 

As in how do I pull data from that particular row, and use the information from the fields separately.

 

I'd love to know what you guys do.

 

Regards,

Damien.

 

[waynew]

<?php

$result = mysql_query("SELECT * FROM tablename WHERE id = '$id'") or die(mysql_error());

while($row = mysql_fetch_assoc($result)){

     echo $row['col_name']; //or assign to array or something
}

?>

[secoxxx]

http://www.google.com/search?hl=en&q=Retrieving+Data+from+MySQL.+&btnG=Google+Search

 

hundreds of tutorials.

[DamienRoche]

Cheers waynewex I'll try that. Secoxxx, I always search Google first but I'm just not getting this. I'll try the code and carrying on reading guides.

 

Ta

[samshel]

did you already try some code your self? check out functions

 

mysql_connect()

mysql_select_db()

mysql_query()

mysql_num_rows()

mysql_fetch_array()