Sending form to the database

[TVining]

Sorry, but I don't have a lot of web script experience. I am a database guy, and haven't worked much with PHP.

I have a database containing some basic fields. These include: Sq, Dorm, Unit, Address and Zip.

When I use a web form to submit Sq and Dorm, I want to return the full record; Sq, Dorm, Unit, Address and Zip.

How do I use the form to send the request to the PHP database on MySQL?

What code do I put in the page?

[Rwap]

<?php

(connection stuff up here)


$sql=" select * from YOUR_TABLE order by WHAT_EVER desc ";

$rs = mysql_query($sql) or die(mysql_error());


while ( $row = mysql_fetch_assoc( $rs) )
{
echo '<center>
'.$row["Sq"].' || By:'.$row["Dorm"].' <br>
'.$row["Unit"].' || '.$row["Address"].' || '.$row["Zip"].'
<HR>
</center>';


?>


^
|
|
|

That should do nicely

[TVining]

Thanks for the help.

I ended up using a little different route, but based from the same script.

Here's the app: http://address.f-16.org

[codefetch]

A codefetch search for connect form database select found this short but complete example to display a form and retrieve database results based on it from the book Beginning PHP 5 and MySQL: From Novice to Professional.