PHP - Simple Order By

I've got.

Hi everyone,

I'm trying to select either a class or an id using PHP Simple HTML DOM Parser with absolutely no luck.  My example is very simple and seems to comply to the examples given in the manual(http://simplehtmldom.sourceforge.net/manual.htm) but it just wont work, it's driving me up the wall.

Here is my example: http://schulnetz.nibis.de/db/schulen/schule.php?schulnr=94468&lschb=

I think the HTML is invalid: i cannot parse it.

Well i need more examples - probly i have overseen something!

If anybody has a working example of Simple-html-dom-parser...i would be happy.
The examples on the developersite are not very helpful.

your dilbertone

Hello, im very green to php and I am having trouble creating a simple log in script. Not sure why this is not working, maybe a mysql_query mistake? I am not receiving any errors but nothing gets updated in the members table and my error message to the user displays.  any help is appreciated! here is my php:


<?php
session_start();

$errorMsg = '';
$email = '';
$pass = '';

if (isset($_POST['email'])) {
   $email = ($_POST['email']);
   $pass = ($_POST['password']);
   
   $email = stripslashes($email);
    $pass = stripslashes($pass);
   $email = strip_tags($email);
   $pass = strip_tags($pass);
   
if ((!$email) || (!$pass)) {
   $errorMsg = '<font color="#FF0000">Please fill in both fields</font>';
}else {
   include 'scripts/connect_db.php';
   $email = mysql_real_escape_string ($email);
   $pass = md5($pass);
   
   $sql = mysql_query("SELECT * FROM members WHERE email='$email' AND password='$pass'");
   
   $log_check = mysql_num_rows($sql);
   
if ($log_check > 0) {
    while($row = mysql_fetch_array($sql)) {
      
      $id = $row["id"];
      $_SESSION['id'];
      $email = $row["email"];
      $_SESSION['email'];
      $username = $row["username"];
      $_session['username'];
      
      mysql_query("UPDATE members SET last_logged=now() WHERE id='$id' LIMIT 1");
      
   }//Close while loop
   echo "You are logged in";
             exit();
}
else {
   $errorMsg = '<font color="#FF0000">Incorrect login data, please try again</font>';
}


     }
}
?>



and the form:

<?php echo $errorMsg; ?>
<form action="log_in.php" method="post">
Email:<br />
<input name="email" type="text" /><br /><br />
Password:<br />
<input name="password" type="password" /><br /><br />
<input name="myBtn" type="submit" value="Log In" />
</form>

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!

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

I got this code from a previous thread:

Code: [Select]
mysql_query("SET @rows = 0;");
$res = mysql_query("SELECT @rows:=@rows+1 AS view_rank,COUNT(id) AS views, credit_members_id FROM vtp_tracking GROUP BY credit_members_id ORDER BY views DESC");
$n   = array(1 => 'st', 2 => 'nd', 3 => 'rd');
while($row = mysql_fetch_row($res))
{
   if ( $row[2] != $members_id )
      continue;
   if ( substr($row[0], -1) < 4 )
   {
      $row[0] .= $n[$row[0]];
   }
   else
   {
      $row[0] .= 'th';
   }
   echo ' You are in ' . $row[0] . ' place with ' . number_format($row[1]) . ' views.';
   break;
}
Everything seems ok except it orders by the "credit_members_id" and not "views" as entered.

Can someone explain why, and how to fix this?

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";

Currently i have a query which at the end has this
Code: [Select]
order by (value/counter) desc");

which works fine, however i was wondering, if in the case that 2 rows have the same, is it possible to set a second value to order by?

Hey everybody, i'm building a website for the softball league i play in.... so far the website is pretty good... with all the stats and profiles.... i'm having a little problem with the ORDER of the leaders in the categories i have to calculate the result...

for example... avg. is the result of the total hits divided by the total number of at bats... both numbers are coming from the database... the problem comes when i have to order the leaders from first to last...

this is my php:

Code: [Select]
$sql = "select profile_id, SUM(total_hits) AS hitstotal, SUM(ab) AS abtotal from batters WHERE year = '2010' GROUP BY profile_id";

$cons = mysql_query($sql);
while ($result = mysql_fetch_array($cons)) {
$sumaab = $resultad['abtotal'];
$sumahits = $resultad['hitstotal'];
$p_id = $resultad['profile_id'];
$prom = round(($sumahits."") / ($sumaab.""),3);

that gives me all the batting averages for the players.

and here is my question:
how can i order that $prom result from first to last?

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

hi, i have a field for price that gets returned.

is there a way to do ORDER BY 'category' so that i can have tally at the bottom of each category that adds all the prices together?

by the order in which they were entered?   like i dont want to order by a specific row in my table, i want to list the data by which it was entered.     maybe i can add a row that enters column #s somehow??

Can someone please explain to me what's the importance of node order? Does certain nodes that appear first or last have impact on traversing time?

Any suggestions much appreciated!

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?