Member Avatar for ztwalsh

Is it possible to display the tables of my database in alphabetical order one letter at a time on a page? I am going to try to explain my situation as concisely as possible.

Right now I have a page where I have a list of each letter in the alphabet. When "A" is clicked the url shows up as www.example.com/allmovies.php?p=a. But all of the information I have on ?p=a is entered in manually, which I am tired of doing. On ?p=a I just want to show info from tables beginning with "A"—on ?p=b I just want to show info from tables beginning with "B" and so on.

Does anyone have any experience with this?

  • 2 Contributors
  • 1 Reply
  • 65 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by Ole Raptor
Member Avatar for Ole Raptor

you can use a wildcard after your var

$query = mysql_query("SELECT * from table WHERE name LIKE '"$_GET['p']"%' ORDER BY name ASC") or die(mysql_error());
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.