[[SOLVED] help on selecting a single unquie record]

Hi All,

I am trying to make an "application" on my website.

What I am trying to write is a results database that pulls data from F1 races to a web page. the system will therefore have more than one instance of each team.

what I want it to do, is look at the db and select one instance, and one instance only, not list the whole lot. You can see what It is doing here   http://www.pumaf1.org.uk/res/infobase/teamall.php

 

the code i have so to select the data from the db is:

 

 // connect to the server
   mysql_connect( '', '', '' )
      or die( "Error! Could not connect to database: " . mysql_error() );
   
   // select the database
   mysql_select_db( '')
      or die( "Error! Could not select the database: " . mysql_error() );
   
   // retrieve all the rows from the database
   $query = "SELECT * FROM `infobase` ORDER BY team asc";
   
   $results = mysql_query( $query );

   // print out the results
   if( $results )
   {
?>

$query = "SELECT * FROM 'infobase' ORDER BY team asc";

 

if anyone could help me it would be greatly taken

 

[dynamic list to select certain data from db]

Thanks-i have the list made, i need help on how to get it to pull the remaining data from the database

[dynamic list to select certain data from db]

hi,

my second question -

on my website i am programming a interactive db, please see http://www.pumaf1.org.uk/res/infobase/search.php to see what i mean

 

want i would like to do is the following -

 

grab data to build the "drivers" drop down list from the db - done (as you can see)

from that list enable a user to click on the driver name and go to a page for that driver that pulls out all the results for that one driver.

 

thats the problem. for example you click on "raikkonen, kimi", and you get the url

 

http://www.pumaf1.org.uk/res/infobase/Raikkonen,%20Kimi

 

now what i am TRYING to do is

 

have a page that you load the results page http://www.pumaf1.org.uk/res/infobase/search.php select your driver, and it would pull out every race result for that driver. That driver will have more than one result in the db so it needs to be a repeat region

 

I am using dreamweaver mx 2004, and am really stuck. Please be aware I am only learning PHP and MYSQL so please make it easy if you can.

 

you can see what I would expect (albeit for engines output)(there will be more than one drop down list when its finished)

 

www.pumaf1.org.uk/res/infobase/engine-ferrari.php

 

of course anyone that helps me with this will get a mention in the credits section of the site if they so wish

 

 

thanks in advance

 

Dave

[[SOLVED] xls to sql]

hits head against wall......

 

grrr just twigged thanks!

[[SOLVED] xls to sql]

sorry i dont understand? am i just being stupid?

[[SOLVED] xls to sql]

Hi All,

I am looking for a free peace of software which will alloy me to convert a spreadhseet with approx 3,000 rows into a mysql db. I have found a peace called xls2sql which does the job (really bloody well), but since i will only use it once, (once the data is collected) I would be a bit upset since the site doesnt make any money!

if anyone can help i would really be happy!

 

dave