Gathering Data

[Cannibal_Monkey]

Could somone write a sample code that would retrieve a from row 1 of table b in database c. So far I have

 

<?php
$connection=mysql_connect("localhost","root","")
or die ("You're dead1");
$db=mysql_select_db("c",$connection)
or die ("You're dead2");
$query=mysql_query($a);
?>

 

I'm not sure if that's all correct though, I mean to do what I want to do.

[gin]

I suggest this tutorial for database connection:

http://www.phpfreaks.com/tutorials/142/0.php

 

The query to get the most recent row of data would be:

SELECT * FROM b LIMIT 1

 

The MySQL & PHP manuals are invaluable resources.