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
Question about ShowWindow()
Hello....
I'm struggling with sumpin, and I hope y'all can help.
I've got a CFormView
how to read and write into a word document using php...?
hi,
I need,reading and writting into a word document using php.
Thank u inadva
Call to undefined function mysql_fetch_accoc()
New to php/mysql coding. What's wrong with this sequence, or am I
just not seeing to obvious?
Variables and Include
Code: [Select]<?php
$header = $_COOKIE['mss']['header'];
$body = $_COOKIE['mss']['b
checkbox update
I am having a brain fart right now and i cant remember how to do this. if anyone could help that wou
Help with Contact Form
I have this Form on an html page and the associated code on page.php (below).
I keep getting the
Not "Just Another" MMORPG - text based.
Hello,
I've been learning MySQL and PHP for the last 2-3 years.
Though, I've had long paus
php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecu
Embed Video Problem
Hey, thanks for looking!
File to be embedded:
Code: <playlist version="1&q
mysql select with $_get ?
Hi, i have this code:
Code: // If char id is 0 and character dont exist do:
if ($_GET["id