What order to code this?

07-01-2007, 4:17 PM

In article <b8aYa.1800855$mA4.252215@news.easynews.com>, Wm
<LAshooter@hotmail.com> wrote:

> I have an add (insert) page that takes the data from an input form and
> inserts it into mySQL. I added a couple of sections to validate the Email
> address for formatting, then list any existing entries if that address is
> already in the database. Unfortunately, that info now appears on the page
> above my heading and page content.
> I'm not sure where to put this or how to
> arrange this code to get the data where I want it? Below is an abstract to
> try to illustrate how things are arranged now.
>
> <?PHP
> extract ($_POST);
> ... validate Email address format...
> include ('dbconnect.php');
> $query...
> if (mysql_num_rows($result) > 0) {
> ... get all other listings...
> echo other listings...

If you want these at the bottom then why are you echoing them here?
Either perform another query (slow is large db), or if you don't
destroy the variable just echo it at the bottom. If you require to
destroy or write over the variable copy it to a variable or array.

> echo "are any of these you?";
> } else {
> echo "your formatting is wrong...";
> }
> //assuming no errors...
> $query = "insert...";
> ?>
> <HTML>
> <HEAD>
> ...etc...
>
>
> What I *need* is for the results of the validation to appear below in the
> body of the page:
> <TABLE>
> <TR><TD colspan="2">...header and banner...</TD></TR>
> <TR><TD> menu </TD> <TD> main content here, incl errors </TD></TR>
> </TABLE>
>
> If I try to do my PHP processing beforehand, how can I "save" the results to
> include them down in the body? Do I need to define the "get all other
> listings" and "echo other listings" as if they are a function, and call it
> (and presumably its results) in the body? Or am I way overthinking this?
>
> BTW, my current version DOES work as intended with the exception of putting
> my other listings above my HTML...
>
> Wm
>
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
date order by	Adi	PHP	0	07-01-2007 3:37 PM
readdir() order	Tim Hussein	PHP	3	07-01-2007 3:36 PM
sort order	Kurt Milligan	PHP	2	07-01-2007 3:35 PM
Halo 2 Pre-order	Andy	Console Subjects	1	06-26-2007 11:01 AM
Order By Problem	Jeff Grossman	Database	5	05-31-2007 8:47 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)