wompus

This would be your drop-down <input name="something"> This would be your php [php:1:9d98bc23a5] $query = \"SELECT * FROM tablename WHERE Title = $something\"; $result = mysql_query($query); while($row = mysql_fetch_array($result)){ echo($row[\'Text\']); } ?>[/php:1:9d98bc23a5][/code]

Convert all your posted variables <?php foreach($_POST as $key => $item) { $key = $_POST[$key]; } ?> $_POST[\'name\'] could then be used just as $name

Sort the results in descending order based on points. $query = "ALTER TABLE tablename ORDER BY points DESC"; $result = mysql_query($query); Then get the data like this $query = "SELECT * FROM tablename"; $result = mysql_query($query); while($row = mysql_fetch_array($result)){ if($count=="") {$count=1;} else {$count = $count+1;} echo("This is ".$count." with ".$row[points]."<br>"); } This should repeat for every entry in your table.

Nevermind. I got it. I changed the type of field to an integer. Now it sorts correctly without 0s infront of numbers.

OK. I use this field to sort entries in an online journal. I was fine till i hit 100 entries. Now when I sort in descending order, entry #100 ends up with entry #10. If I could put an extra zero infront of every entry number currently in the table it will fix this. I have no problem entering data into this table in the correct format. My question is, can I add the number 0 before every value in a specified column or do i have to edit each one using phpmyadmin.

I just started learning mysql today so this might sound stupid. I have a field in a table called id. I would like to add a the number 0 before each value in this field. How can i do this throughout the whole table? Thanks

We got it working now. We found where to set the modem to open port 80 and point to the right machine. Thanks

I recently installed apache on a machine on my local network. I connect through an external dsl modem. When i type in the lan ip of the computer that is running apache i see my webpage. When i try to view it using the external ip of my dsl modem, i am brought to to a configuration screen for my modem. Can anyone recomend how i could type in the ip address of my dsl modem and it would display my webpages on the apache server. What ports do i need to enable?