Linking an HTML form to a MySQL DB and inserting links to images

Hi all

I'm going mad (if I wasn't already!) trying to get a set
of pages to
work together.

I built Master and Details pages (www.webxcel.net/master.php
and
www.webxcel.net/details.php) in one operation (per MM Help
menu).  I
also have a  standard html form
(www.webxcel.net/searchfrm.php) but
cannot figure out how to set this up so that when a user
selects a
particular category on the form (Angling, Cricket .... Rugby
etc) from
the drop-down list the appropriate Master page appears. 
What I get is
the whole DB 10 records at a time instead of the relevant
slection 10
pages at a time.
Clicking on a CodeID in the Master page links to the
appropriate Detail
page.

There is also the problem of how to insert thumbnail images
into each
row on the master page and a larger image on the relevant
details page.

Just trying to sort out thes basic things first - at the
moment no
design elements have been considered.

Can anyone point me in the right direction please?

Thanks

Plato

X-Google-Language: ENGLISH,ASCII-7-bit
Received: by 10.11.53.63 with SMTP id b63mr82127cwa;
        Sat, 20 May 2006 06:08:37 -0700 (PDT)
X-Google-Token: wP1_qwwAAACXZ-jZxSe4NwQ8n6pP7SPO
Received: from 81.178.78.171 by 38g2000cwa.googlegroups.com
with HTTP;
	Sat, 20 May 2006 13:08:37 +0000 (UTC)
From: "Plato" <platodsl.pipex.com>
To: "PHP & MySQL" <phpmysqlgooglegroups.com>
Subject: Linking an HTML form to a MySQL DB and inserting
links to images
Date: Sat, 20 May 2006 06:08:37 -0700
Message-ID: <1148130517.246700.9217038g2000cwa.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows
NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR
2.0.50727),gzip(gfe),gzip(gfe)
Mime-Version: 1.0
Content-Type: text/plain

Hi all

I'm going mad (if I wasn't already!) trying to get a set
of pages to
work together.

I built Master and Details pages (www.webxcel.net/master.php
and
www.webxcel.net/details.php) in one operation (per MM Help
menu).  I
also have a  standard html form
(www.webxcel.net/searchfrm.php) but
cannot figure out how to set this up so that when a user
selects a
particular category on the form (Angling, Cricket .... Rugby
etc) from
the drop-down list the appropriate Master page appears. 
What I get is
the whole DB 10 records at a time instead of the relevant
slection 10
pages at a time.
Clicking on a CodeID in the Master page links to the
appropriate Detail
page.

There is also the problem of how to insert thumbnail images
into each
row on the master page and a larger image on the relevant
details page.

Just trying to sort out thes basic things first - at the
moment no
design elements have been considered.

Can anyone point me in the right direction please?

Thanks

Plato


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "PHP & MySQL" group.
To post to this group, send email to phpmysqlgooglegroups.com
To unsubscribe from this group, send email to
phpmysql-unsubscribegooglegroups.com
For more options, visit this group at http://groups
.google.com/group/phpmysql
-~----------~----~----~----~------~----~------~--~---

What's going on at the bottom of the form?
The fact that the following lines are visible suggests that
you've left
out "<? ?>"

do {

} while ($row_rs_search = mysql_fetch_assoc($rs_search));
  $rows = mysql_num_rows($rs_search);
  if($rows > 0) {
      mysql_data_seek($rs_search, 0);
	  $row_rs_search = mysql_fetch_assoc($rs_search);
  }

X-Google-Language: ENGLISH,ASCII-7-bit
Received: by 10.11.88.14 with SMTP id l14mr28865cwb;
        Sat, 20 May 2006 11:11:08 -0700 (PDT)
X-Google-Token: DsVOWAwAAABcgpnFOUS0-vHtKJBDP4NW
Received: from 213.246.184.19 by
j33g2000cwa.googlegroups.com with HTTP;
	Sat, 20 May 2006 18:11:08 +0000 (UTC)
From: "strawberry" <zac.careygmail.com>
To: "PHP & MySQL" <phpmysqlgooglegroups.com>
Subject: Re: Linking an HTML form to a MySQL DB and
inserting links to images
Date: Sat, 20 May 2006 11:11:08 -0700
Message-ID: <1148148668.670444.94220j33g2000cwa.googlegroups.com>
In-Reply-To: <1148130517.246700.9217038g2000cwa.googlegroups.com>
References: <1148130517.246700.9217038g2000cwa.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1;
en-US; rv:1.8.0.3) Gecko/20060426
Firefox/1.5.0.3,gzip(gfe),gzip(gfe)
Mime-Version: 1.0
Content-Type: text/plain

What's going on at the bottom of the form?
The fact that the following lines are visible suggests that
you've left
out "<? ?>"

do {

} while ($row_rs_search = mysql_fetch_assoc($rs_search));
  $rows = mysql_num_rows($rs_search);
  if($rows > 0) {
      mysql_data_seek($rs_search, 0);
	  $row_rs_search = mysql_fetch_assoc($rs_search);
  }


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "PHP & MySQL" group.
To post to this group, send email to phpmysqlgooglegroups.com
To unsubscribe from this group, send email to
phpmysql-unsubscribegooglegroups.com
For more options, visit this group at http://groups
.google.com/group/phpmysql
-~----------~----~----~----~------~----~------~--~---

strawberry wrote:
> What's going on at the bottom of the form?
> The fact that the following lines are visible suggests
that you've left
> out "<? ?>"
>
> do {
>
> } while ($row_rs_search =
mysql_fetch_assoc($rs_search));
>   $rows = mysql_num_rows($rs_search);
>   if($rows > 0) {
>       mysql_data_seek($rs_search, 0);
> 	  $row_rs_search = mysql_fetch_assoc($rs_search);
>   }

Hi

Thanks for your reply.  Originally I had a second drop-down
menu but
deleted it as I thought I would sort out one at a time. 
That said I'm
not sure if that's the reason!  If not then I have to
answer "I don't
know!!"

Any ideas?

Thanks

Plato


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "PHP & MySQL" group.
To post to this group, send email to phpmysqlgooglegroups.com
To unsubscribe from this group, send email to
phpmysql-unsubscribegooglegroups.com
For more options, visit this group at http://groups
.google.com/group/phpmysql
-~----------~----~----~----~------~----~------~--~---

Not really - although I wonder if the following line in your
form is
wrong:

      <td><input type="submit"
name="Submit" value="Send Request"
/></td>

should read?

      <td><input type="submit"
name="Submit" value="Send
Request"></td>

X-Google-Language: ENGLISH,ASCII-7-bit
Received: by 10.11.53.63 with SMTP id b63mr99761cwa;
        Sun, 21 May 2006 05:24:21 -0700 (PDT)
X-Google-Token: 6vP7cAwAAADXyji5v0W82SjHP4DjP0o4
Received: from 213.246.184.19 by 38g2000cwa.googlegroups.com
with HTTP;
	Sun, 21 May 2006 12:24:21 +0000 (UTC)
From: "strawberry" <zac.careygmail.com>
To: "PHP & MySQL" <phpmysqlgooglegroups.com>
Subject: Re: Linking an HTML form to a MySQL DB and
inserting links to images
Date: Sun, 21 May 2006 05:24:21 -0700
Message-ID: <1148214261.618440.1098038g2000cwa.googlegroups.com>
In-Reply-To: <1148208801.770327.197940j73g2000cwa.googlegroups.com>
References: <1148130517.246700.9217038g2000cwa.googlegroups.com>
   <1148148668.670444.94220j33g2000cwa.googlegroups.com>
   <1148208801.770327.197940j73g2000cwa.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1;
en-US; rv:1.8.0.3) Gecko/20060426
Firefox/1.5.0.3,gzip(gfe),gzip(gfe)
Mime-Version: 1.0
Content-Type: text/plain

Not really - although I wonder if the following line in your
form is
wrong:

      <td><input type="submit"
name="Submit" value="Send Request"
/></td>

should read?

      <td><input type="submit"
name="Submit" value="Send
Request"></td>


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "PHP & MySQL" group.
To post to this group, send email to phpmysqlgooglegroups.com
To unsubscribe from this group, send email to
phpmysql-unsubscribegooglegroups.com
For more options, visit this group at http://groups
.google.com/group/phpmysql
-~----------~----~----~----~------~----~------~--~---