[Beds] PHP AND MYSQL

[Stephen Elliott]

Hi,

Cheers for that. I've managed to sort it out myself with a bit of research
on the net.

Steve...

-----Original Message-----
From: beds-bounces at mailman.lug.org.uk
[mailto:beds-bounces at mailman.lug.org.uk]On Behalf Of
beds-request at mailman.lug.org.uk
Sent: 27 November 2005 12:16
To: beds at mailman.lug.org.uk
Subject: Beds Digest, Vol 54, Issue 2


Send Beds mailing list submissions to
	beds at mailman.lug.org.uk

To subscribe or unsubscribe via the World Wide Web, visit
	http://mailman.lug.org.uk/mailman/listinfo/beds
or, via email, send a message with subject or body 'help' to
	beds-request at mailman.lug.org.uk

You can reach the person managing the list at
	beds-owner at mailman.lug.org.uk

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Beds digest..."


Today's Topics:

   1. Re: PHP AND MYSQL (Lee Larcombe)


----------------------------------------------------------------------

Message: 1
Date: Sat, 26 Nov 2005 15:29:37 +0000
From: Lee  Larcombe <lee at larcombe.uk-internet.org.uk>
Subject: Re: [Beds] PHP AND MYSQL
To: <beds at mailman.lug.org.uk>
Message-ID: <BFAE2FE1.1512%lee at larcombe.uk-internet.org.uk>
Content-Type: text/plain;	charset="US-ASCII"

I don't really do php - if you wanted perl then I could help more. However,
I think the query should be something like this:

<?

mysql_connect(localhost);
@mysql_select_db(contacts) or die( "Unable to select database");
$query="SELECT firstname, lastname FROM addressbook";
@result=mysql_query($query);

mysql_close();

$details=mysql_result($result,$i,"addressbook");

echo "$details";

?>

Sorry I can't help you fully, but it might be a start. If you want a
solution in perl, then I would be happy to send you something a bit more
useful.

Regards

Lee


On 26/11/05 11:21 am, "Stephen Elliott" <techweb at ntlworld.com> wrote:

> Hi,
>
> I have got a database called contacts with a table called addressbook
inside
> it. I need to create a PHP/HTML form where the user can enter the contacts
> firstname or lastname and it will run a query and display the results in a
> table.
>
> Does anyone have any ideas on how to do this?
>
> Cheers
> Steve...
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.362 / Virus Database: 267.13.8/183 - Release Date: 25/11/2005
>
>
> _______________________________________________
> Beds mailing list
> Beds at mailman.lug.org.uk
> http://mailman.lug.org.uk/mailman/listinfo/beds





------------------------------

_______________________________________________
Beds mailing list
Beds at mailman.lug.org.uk
http://mailman.lug.org.uk/mailman/listinfo/beds

End of Beds Digest, Vol 54, Issue 2
***********************************
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.8/183 - Release Date: 25/11/2005

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.8/183 - Release Date: 25/11/2005