Table sorting
Posted on
16th Feb 2014 07:03 pm by
admin
Hi,
I'm trying to modify the following in order to make the output table sorted alphabetically according to $event_name but so far have not succeeded. Any pointers?
Code: function display_all_events(){
global $wpdb;
$events_detail_tbl = get_option('events_detail_tbl');
$curdate = date("Y-m-d");
$paypal_cur = get_option('paypal_cur');
$sql = "SELECT * FROM ". $events_detail_tbl;
$result = mysql_query ($sql);
echo "<table width = '100%'>";
while ($row = mysql_fetch_assoc ($result))
{
$event_id = $row['id'];
$event_name=$row['event_name'];
$event_identifier=$row['event_identifier'];
$cost=$row['event_cost'];
$active=$row['is_active'];
echo "<tr><td width='100%'>".$event_name." - ".$paypal_cur." ".$cost."</p><hr></td><td>";
echo "<form name='form' method='post' action='".$_SERVER['REQUEST_URI']."'>";
echo "<input type='hidden' name='regevent_action' value='register'>";
echo "<input type='hidden' name='event_id' value='".$row['id']."'>";
echo "<input type='SUBMIT' value='REGISTER'></form></td></tr>";
}
echo "</table>";
}
Am relatively new to php so please excuse me for posting stuff that may seem obvious to others but I really need to sort this out as the workaround is very time consuming...
Thanks
No comments posted yet
Your Answer:
Login to answer
297
53
Other forums
dinamic "textboxes"?
Ey all, my first post here, i hope its not a hard one
I display mysql results in a table
Data Function is Its Not working IN IE8
This is my first time to use formums. I hope i can get solution for this problem.
view plaincopy to
PHP and Javascript
Hello Everyone,
I have a page that needs a javascript code to be written between PHP code but
Simple Variable Question
Hi everyone.... again,
I am really getting into php still. Learning more every day. I love it
How could I combine these arrays??
Hello.. I'm trying to figure out a way to combine these first two arrays to get the last array..
How can you detect variable string in a massive string?
Ok guys, i need some help with this one.
I am going to be getting a large string, like 10-20
Displaying Column Names
I have a question regarding the ability to show the column names from my table/query.
What I'm lo
with clause
hi all, i have a big query that usually access the same table more than once. for example, i have s
Edit MySQL Row Using PHP and HTML Form
Hello,
Here's what I'm trying to do. Build a page where a user enters a MySQL row number in.
getAlexaRank($url) function not working
I have made a function to get alexa rank
the site is here: http://mytestsite.rack111.com/1