PHP - Crypto Market Order Functions That Create And Cancel Order With Php And Javascript

I need to make 0, which displays as POA appear at the ned of the list not at the begining, I currently just use
order by price asc

and 0 is at the beginning, i need to make 0 at the end

Hi there, just registered and in need of help, this looks a good place to start!
I'm a php beginner so please bear with me

I have a mysql database which holds 3 pieces of info
id:
match:
1:

I'm trying to sort the results using ORDER BY match ASC but for some reason it's just not for having it...
Can't work out if it's an error with my php code or my table. I can order by "ID" no problem but I when I try ordering alphabetically by "match" it won't.

my code is:

Code: [Select]
mysql_connect("***.***.***") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());


$query = "SELECT * FROM employees WHERE flag = 'tv' ORDER BY match ASC";
$result = mysql_query($query) or die ("Query failed");

$numrows = (mysql_num_rows ($result));


       

// loop to create rows
if($numrows >0){
echo "<table width = 100% border = '0' cellspacing = '2' cellpadding = '0' >";
// loop to create columns
$position = 1;
while ($row = mysql_fetch_array($result)){
if($position == 1){echo "<tr>";}
 
echo " <td align = 'center'><a href=\"http://www.website.eu/sport-stream/1/{$row['id']}.html\" target=_blank>{$row['match']}
<br>
<img src=\"{$row['8']}\" width=\"100\" height=\"70\" /> </a>
</td>

";
if($position == 4){echo "</tr> "; $position = 1;}else{ $position++;}
}//while

$end = "";
if($position != 1){
for($z=(4-$position); $z>0 ; $z--){
$end .= "<td></td>";
}
$end .= "</tr>";
}

echo $end."</table> ";
}//if
And here's a cap of my database:


any help for a php n00b would be greatly appreciated!

Hello,


I have classes in a database with no set UNIX date, just the day like Wednesday and in two other columns the start and end dates.


I want to be able to order by the day first and then by end_time but php orders the day column by spelling and not the day it holds in chronological order.


Is there anyway to change the query to order the day column as a date?


See the query below?


Code: [Select]
$query = "SELECT * FROM zumba_timetable WHERE end_time>'$current_time' ORDER BY day, end_time ASC LIMIT 0,1";

Greetings! I am really stock on this situation.

1. I have a variable $uc_order_created.
2. I have a code like this:

<b><?php echo t('Due Date:'); ?></b>
             </td>
                <td width="98%">
             <?php $duedate = mktime(0,0,0,date("m"),date("d")+30,date("Y"));
        echo "".date("F jS Y", $duedate);?>

3. How do I code if I want the result of $uc_order_created get displayed as Due Date using the code above? Or other modifications?
4. The situation now, the code is working when printing the invoice but its not based on $uc_order_created. So, every time I will edit the Order because of the change of items among others the Due Date will also update. All I want that when Order is edited the value of Due Date will still remain based on the $uc_order_created.

Thank you so much in advance for your help.

Hi all,

I have a script that is essentially a log file of all preious versions of an article (versioning)

You can see the script I am talking about in action at:

http://danielrhyshardy.com/AWT/forumadmin.php

What I would like to do is, instead of displaying the title of each instance (you will see there are two instances named "apple", as they are two previous versions of an article), I would like to display that title once, and then all of the instances of that title be displayed below.

I hope that makes sense.

Here is the code Code: [Select]
<?

$sql = "SELECT id,title,message,date_added FROM messages2 ORDER BY id "; 
 
 
 
 
   $result = mysql_query($sql) or trigger_error(mysql_error(),E_USER_ERROR);
   
   



   while(list($id,$title,$message,$date_added)=mysql_fetch_row($result)){





     
echo '<div style="color:#bb0000;width:250px;text-align:center;float:left;margin-left:15px;margin-bottom:15px;padding-bottom:20px;"><b>'.$title.'<br>'.$date_added.'</b>
 
<input id="'.$message.'" type="radio" name="admin[]" value="'.$id.'"  onclick="javascript:document.form22.car.value=this.id"
  >


</font></div>'."\n";
   
   

   

 
}



?>

I would use something like
Code: [Select]
if ($title = "apple") {

but this would obviously not work for new posts, unless I wanted to constantly update my code.

I am sure there is a simple way to achieve this.

Perhaps someone can tell me!?

Thanks in advance

Dan

Hi, I've been trying to re-order an array and I can't seem to even do it let alone neatly. I've ran out of time and would appreciate any help!


$array = array(
  '0' => array(
    'filepath' => 'files/image_site1.png',
    'title' => 'Website',
  ),
  '1' => array(
    'filepath' => 'files/image_id.png',
    'title' => 'Identitity',
  ),
  '2' => array(
    'filepath' => 'files/image_site2.png',
    'title' => 'Website',
  )
)

I'm looking to re-order the arrays within the parent array depending on whether the 'filepath's contain a sub string of '_id' or '_site'.

I've been using:
$type = '_site';
foreach ($array as $item){
  if (preg_match("/$type/i", $item['filename'])){
    //add this $item to the top of array, somehow...
  }
}

So with $type set to '_site', I'd like to re-arrange the array so both arrays containing _site1.png and _site2.png appear at the top of the parent array. I.e:
$array('0' = array(...), '2' => array(...), '1' => array(...));

I hope I've explained it well enough.

Thanks,

I'm pulling a list from a DB and inserting it in a drop down menu. Each item on the list has a numerical id associated called marketid in the DB. It works, but it orders the list alphabetically. I need it to order by marketid which is the column name. What code do I need to add? Here is what I have now....

<option value="<?=$market['marketid']?>"><?=$market['name']?></option>

Thanks in advance all!!

Tony

Really need a hand from someone mysql query is pretty basic.

I have been ask to add a random order to this query.

 $query = "SELECT rd.user_id
            FROM {$regions_data_table} rd
            WHERE rd.field_id = {$regions_field_id} AND rd.value LIKE %s
                  AND rd.user_id NOT IN (SELECT um.user_id
                                         FROM {$wpdb->base_prefix}usermeta um
                                         WHERE ((um.meta_key='wp_ul_disabled' AND um.meta_value=1) OR (um.meta_key='wp_ul_inactive' AND um.meta_value=1))
                                         GROUP BY um.user_id)";

I have tried so many options but cannot seem to get it to work i am trying to insert order by rand().

Any help please?

I have a database of assorted.  Each row contains defined QUANTITIES for each column item.
Example: columns for shirt, tie, pants, socks.
A row would indicate a purchase of 2 shirts, 1 tie, 0 pants, 3 socks for customer A.
Followed by a row indicate a purchase of 1 shirts, 1 tie, 4 pants, 2 socks for customer B, etc.

Now I want to sort EACH item, group them by quantity, and get an ordered list by quantity, that provides me with something like this:

1 shirt customer B
2 shirt customer C
3 shirt customer F
3 shirt customer H
4 shirt customer D, etc.

I am using this code for my query:
$query = "SELECT brisket, COUNT(brisket) FROM pass GROUP BY brisket ORDER BY brisket ASC";

but it is not organizing the info in a correlated manner.

Help?

Currently I have where the User can search for records, then the records are displayed on a page. I then have a drop down box to where the user can Order by 2 different categories to make it easier for the user to see things but for some reason it is not working. Here is my code.

Oh and the error I get is mysql_num_rows(): supplied argument is not a valid MySQL result resource in

<?php
$qry_str="SELECT * FROM timeslip WHERE 1 ";  

if($_POST['Initials']) 
{ 
   $Initials=$_POST['Initials'];  
   $qry_str.="and Initials='$Initials' "; 
} 

if($_POST['Identifier']) 
{ 
   $Identifier=$_POST['Identifier'];  
   $qry_str.="and Identifier LIKE '%$Identifier%' "; 
} 

if($_POST['Type']) 
{ 
   $Type=$_POST['Type'];  
   $qry_str.="and Type LIKE '%$Type%' "; 
} 
if($_POST['Terms']) 
{ 
   $Terms=$_POST['Terms'];  
   $qry_str.="and Terms LIKE '%$Terms%' "; 
} 
if($_POST['Memo']) 
{ 
   $Memo=$_POST['Memo'];  
   $qry_str.="and Memo LIKE '%$Memo%' "; 
}
if($_POST['date1']) 
{  
   $date1=$_POST['date1'];
   $date2=$_POST['date2'];
   $start=date('Y-m-d', strtotime($date1));
   $end=date('Y-m-d', strtotime($date2));
   $qry_str.="and Date >= '$start' and Date <= '$end' "; 
}
if($_POST['order1'] && $_POST['order2'])
{
$order1=$_POST['order1'];
$order2=$_POST['order2'];
$qry=$_POST['qry'];
$qry_str="$qry ORDER BY $order1 ASC, $order2 ASC ";
}
if($_POST['order1'])
{
$order1=$_POST['order1'];
$qry=$_POST['qry'];
$qry_str="$qry ORDER BY $order1 ASC";
}
if($_POST['order2'])
{
$order2=$_POST['order2'];
$qry=$_POST['qry'];
$qry_str="$qry ORDER BY $order2' ASC ";
}
$result=mysql_query($qry_str); 
$count=mysql_num_rows($result); 
if ($count>0){

?>

<form action="" method="post">
<input type="hidden" value="<?=$qry_str?>" name="qry"/>
Order Results By
<select name="order1" >
<OPTION value="<?=$order1?>"><?=$order1?></OPTION>
<OPTION value="Identifier">Identifier</OPTION>
                <OPTION value="Type">Type</OPTION>
             <OPTION value="Terms">Terms</OPTION>
                <OPTION value="Date">Date</OPTION>
             <OPTION value="Cost">Cost</OPTION>
              
</select> 
Then
<select name="order2" >
<OPTION value="<?=$order2?>"><?=$order2?></OPTION>
<OPTION value="Identifier">Identifier</OPTION>
                <OPTION value="Type">Type</OPTION>
             <OPTION value="Terms">Terms</OPTION>
                <OPTION value="Date">Date</OPTION>
             <OPTION value="Cost">Cost</OPTION>
              
</select> 
<input type="submit" name="submit">
</form>

Evening everyone

I wonder if you can help me with the below code
<table width="823" cellspacing="0" id="mytable" summary="User Transactions Summary"> 
<caption>Transaction Summary</caption> 


  <tr> 
    <th width="136" class="nobg" scope="col" abbr="Merchant Name">Merchant Name</th> 
    <th width="154" scope="col" abbr="Order Value">Order Value</th> 
    <th width="145" scope="col" abbr="Comm">Cash Back</th> 
<th width="278" scope="col" abbr="Status">Status</th> 
  </tr> 
<?php 
$result = mysql_query("SELECT * FROM transactions WHERE u_id = '$u_id' ORDER BY order_date DESC LIMIT 10 "); 
echo mysql_error() ;
 
while($row = mysql_fetch_assoc($result)){

$m_name = $row['m_name'];
$orderval = $row['order_val'];
$status = $row['order_status'];
$m_affid = $row['m_affid'];

$query = mysql_query(" SELECT percent FROM merchants WHERE m_affid = '$m_affid' LIMIT 1");
$num = mysql_num_rows($query);
$i=0;
while ($i < $num) {

$per=mysql_result($query,$i,"percent");

$i++;
}

$com1 = $orderval / 100;
$com2 = $com1 * $per;

$u_comm = round($com2,2);

?>
    

    

  <tr> 
    <th scope="row" abbr="<?php echo $m_name;?>" class="spec"><?php echo $m_name;?></th> 
    <td class="alt">&pound<?php echo $orderval ;?></td> 
    <td class="alt">&pound<?php echo $u_comm ;?></td> 
    <td class="alt"><?php echo $status ;?></td> 
    
  </tr> 
  <?php
}?>  

</table> 

Basically it is meant to simply show fields from a database in a table.

If there is only 1 entry for  a u_id it works fine, however if their is more than one then the $u_comm value shows the same for all results, which is for the last result/row found.

Hope this makes sense!

Hi everyone,

I'm looking for a point in the right direction. I just about to start my biggest coding project yet. (A Simple PHP Order form).

The client has suggested that they want a form for users to enter a reference code (from a catalog) of a product type how many items they want. It will generate a sub total. And if the total is over a certain amount discount will be given.

The form will also have the regular form fields as well. e.g Name, email, address etc...

Then all this will post to a email. I've created contact form scripts before. But is there any links or tutorials that could help me do this or even point me in the right direction.

Thanks for all the help

Barry

I have quite a long .php page but I've attached the end of it. I was wondering if I can change the order it is displayed. Basically $j is a year. And currently it goes from 1894 until 2019. I don't think anything is currently telling it to sort either way, it just by default shows that way. But I want it to show 2019 first and go down to 1894. I had this written for me by someone who I can no longer get hold of.

	$total_record=count($session_player);
	$i=0;
	$palyerslink="";
	foreach($session_player as $var=>$val)
	{
		$i++;
		if($i==$total_record)
			$palyerslink.="<a href='/history/?pid=$var' title='view this in more detail'>$val</a>";
		else
			$palyerslink.="<a href='/history/?pid=$var' title='view this in more detail'>$val</a>, ";
		
	}
	if(!empty($session_player))
	{
		$tr++;
		$records.="<tr class=row>
		            <td class=border-right><a href='/history/browse?season=$j'>$j-$value</a></td>
		            <td class=border-right>$max_goal_season</td>
		            <td>$palyerslink</td>
		            </tr>";
	}
}
$records.="</table></div>";
echo $records;
?>

 

This is the end of the page where the records are then displayed using the echo.

I'm not sure if more code is needed though, I could post it in full if needed

Edited May 29, 2020 by alxne

I need to add ORDER BY name ASC to this code

Code: [Select]
foreach($db->query("SELECT * FROM company_subcategory WHERE category_id = ".(int) $category_id) as $row) { $r[] = new CompanySubCategory($row['subcategory_id'], $row);}
Tried to do it like this, but it doesn't work

Code: [Select]
foreach($db->query("SELECT * FROM company_subcategory WHERE category_id = ".(int) $category_id ORDER BY name ASC) as $row) { $r[] = new CompanySubCategory($row['subcategory_id'], $row);}
Any help much appreciated

Thanks in advance