Help with printf

keigowei

Hi all, i am really new to PHP and i am trying to learn off the tutorial that many of you have posted here for newbies, so if it sounds like i am asking a really stupid question then i am sorry in advance but would appreciate your help.

I have been able to get a database going but i have a slight problem, below i understand that it will display the fields "name" and "type" and a delete that will delete a entry in the table. What i cant figure out is how do i sort this by "name" so it will display all fields in name in alphabetical order?, also the name and type is a link that allows you to edit both the name and type but how do i show the 2 fields but make it so that the name is a link which you click on to edit both the name and field? hope this makes sense

printf("<a href=\"%s?id=%s\">%s %s</a> \n", $PHP_SELF, $myrow["id"], $myrow["name"], $myrow["type"]);

printf("<a href=\"%s?id=%s&delete=yes\">(DELETE)</a><br>", $PHP_SELF, $myrow["id"]);

Thanks again for your time and sorry if this problem has already been asked.

keigo

james_holden

Not sure about the last part of your post, however:

To order things you can use two routes, array_sort or (and a better route) is to sort the data within the mysql query:

Select * from TableSource where data like 'x' order by field

You are using printf which is good but php is easier - using echo and such lets you insert variables within the string.

echo "This is a <a href=$PHP_SELF>Link $foo</a> ".array["name"]." and some more text";

The last part of your question is hard to understand..? Can you explain it a little clearer.

keigowei

Thanks for your help James_Holden i will try that out.

yeah the second part is a little confusing what i have is a link that looks like [URL=http://]keigo operations[/URL] which allows me to edit the contents of that link so for example i have name Keigo and type Operations then when i click on the link i can change either the name or the type but what i want to do is to display both the name and type but i want to only be able to click on the name to edit both the name and type... umm... hope that is more clearer, its quite hard to explain unless i post up all the code.

alright PHP is really hard to explain... well to make it easier i am using this tutorial and if you put all that together you might be able to understand what i am trying to explain

Sorry about my poor explanation of the problem but thanks for your patience and your help, its very appreciated.

Thanks again
keigo

Bunkermaster

use querystring to pass your name (or more likely the row ID) from link to a second script who will query the database with a WHERE clause stating you want the ID's name and type.
Querystring ::
editnameandtype.php?ID=12
SQL ::
     SELECT
          name,
          type
     FROM
         &nbsp nameandtypetable
     WHERE
          id = $_REQUEST['ID']