Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

simple question I think...about PHP/mySQL

 
   Database Help (Home) -> PHP SQL RSS
Next:  Delay in ADO Rst property value availability  
Author Message
Larneman

External


Since: Feb 07, 2005
Posts: 7



(Msg. 1) Posted: Mon Feb 07, 2005 11:40 am
Post subject: simple question I think...about PHP/mySQL
Archived from groups: alt>php>sql (more info?)

I want to make a website that starts with letters A thru Z .

Click on the letter A you get a list of surnames beginning with A....

Click on surname A..... you get a table with all the information from a
mySQL on the people with that surnames.

My simple question is about clicking the letter A or surname A.....

What do I use, I can only find information about using FORM with "post"
or "get" I cannot work out how to use them in the above example.

The table is not a problem as I have found many examples?

I see this on WAREZ sites and others but how dos it work.....Puzzled

 >> Stay informed about: simple question I think...about PHP/mySQL 
Back to top
Login to vote
Du

External


Since: Feb 03, 2005
Posts: 10



(Msg. 2) Posted: Mon Feb 07, 2005 2:40 pm
Post subject: Re: simple question I think...about PHP/mySQL [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Try this ...

For the link for linkA and surnameA:
// Link for clicking on letter A
<a rel="nofollow" style='text-decoration: none;' href="http://www.yourwesite.com/look_script.php?type=link&startwith=A" target="_blank">http://www.yourwesite.com/look_script.php?type=link&startwith=A</a>

// Link for clickin on actual ppl with surname "goodman"
<a rel="nofollow" style='text-decoration: none;' href="http://www.yourwesite.com/look_script.php?type=surname&name=goodman" target="_blank">http://www.yourwesite.com/look_script.php?type=surname&name=goodman</a>


Since the value is on the address you have to use $_GET to get the value.

-------------------------------
In your 'look_script.php' <- this script work as ur index and ur
lookup too

if (!empty($_GET['type'])){
do ur magic here: is it linkA or surnameA?
}
else {
show the A to Z listing
}


Hope that helps,

Du


"Larneman" wrote in message

 >I want to make a website that starts with letters A thru Z .
 >
 > Click on the letter A you get a list of surnames beginning with A....
 >
 > Click on surname A..... you get a table with all the information from a
 > mySQL on the people with that surnames.
 >
 > My simple question is about clicking the letter A or surname A.....
 >
 > What do I use, I can only find information about using FORM with "post"
 > or "get" I cannot work out how to use them in the above example.
 >
 > The table is not a problem as I have found many examples?
 >
 > I see this on WAREZ sites and others but how dos it work.....Puzzled

 >> Stay informed about: simple question I think...about PHP/mySQL 
Back to top
Login to vote
Larneman

External


Since: Feb 07, 2005
Posts: 7



(Msg. 3) Posted: Mon Feb 07, 2005 3:40 pm
Post subject: Re: simple question I think...about PHP/mySQL [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks for the help, Du. It is great, the help here.



Du wrote:
 > Try this ...
 >
 > For the link for linkA and surnameA:
 > // Link for clicking on letter A
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://www.yourwesite.com/look_script.php?type=link&startwith=A</font" target="_blank">http://www.yourwesite.com/look_script.php?type=link&startwith=A</font</a>>
 >
 > // Link for clickin on actual ppl with surname "goodman"
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://www.yourwesite.com/look_script.php?type=surname&name=goodman</font" target="_blank">http://www.yourwesite.com/look_script.php?type=surname&name=goodman</font</a>>
 >
 >
 > Since the value is on the address you have to use $_GET to get the value.
 >
 > -------------------------------
 > In your 'look_script.php' <- this script work as ur index and ur
 > lookup too
 >
 > if (!empty($_GET['type'])){
 > do ur magic here: is it linkA or surnameA?
 > }
 > else {
 > show the A to Z listing
 > }
 >
 >
 > Hope that helps,
 >
 > Du
 >
 >


 >
  >>I want to make a website that starts with letters A thru Z .
  >>
  >>Click on the letter A you get a list of surnames beginning with A....
  >>
  >>Click on surname A..... you get a table with all the information from a
  >>mySQL on the people with that surnames.
  >>
  >>My simple question is about clicking the letter A or surname A.....
  >>
  >>What do I use, I can only find information about using FORM with "post"
  >> or "get" I cannot work out how to use them in the above example.
  >>
  >>The table is not a problem as I have found many examples?
  >>
  >>I see this on WAREZ sites and others but how dos it work.....Puzzled
 >
 >
 >
 >> Stay informed about: simple question I think...about PHP/mySQL 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
simple question I think... - I want to make a website that starts with letters A thru Z . Click on the letter A you get a list of surnames beginning with A.... Click on surname A..... you get a table with all the information from a mySQL on the people with that surnames. My..

MySQL - question about displaying data - I am working an some pages that have database content on them. I'm sorry that I don't have any versions of it online yet, but it isn't hard to explain. The site lists restaurants with contact information. All of the information is kept in a MySQL..

php + MySQL problems - I'm trying to get php + MySQL running on my web server. I tested the setup on an old RH8 server install that I was going to upgrade; everything worked fine. So I wiped out the old RedHat, installed Fedora Core 2, and repeated the installation. No dice...

Accounts in Mysql - Hello, Learning about Mysql Accounts, there is something I like to ask for. I have made some database tests as root mysql with [gastonv@telenetPC ~]$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL....

php and mySql - I get an error message while trying to follow these procedures: http://www.howtoforge.com/intrusion-...on-ubuntu-7.10 Here is the error: Fatal error: Call to undefined function mysql_connect() in /var/www/adodb5/drivers/adodb-mysql.inc.php on line 363..
   Database Help (Home) -> PHP SQL All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]