Zeoslib Portal

Well Michael, I really don't know.
The code you supplied works ok, but its when I try to add "INSERT INTO" the other db table, it all goes belly-up.

The search continues...

Ok. Well, erm thanks Michael, but my frustration factor has set in! I've tried loads of ways to make it work, but failed (again). This is the most sensible way I can think of writing the code: [syntax="php"]<?php mysql_pconnect("db","ddbname","password"); mysq...

Whoops! Sorry'bout that. Here's what I meant to put: Hi. I wondered if anyone can help with this: I want to select from one database table and insert the result into another. There will be multiple rows, so I don't know if "mysql_query" is the right choice. Something like this (except it d...

[syntax="php"]<?php mysql_pconnect("db","db","pw"); mysql_select_db("db"); $result=mysql_query("SELECT TeamName FROM telford_teams WHERE Division='1'"); mysql_query("INSERT INTO telford_1 (match_no, div, hometeam, sets_home, awayteam, ...