1st Get your SQL to ORDER BY points DESC
2nd use PHP to get the details on row at a time and display the results
in an HTML table.
The specifics will depend on what your table looks like, for example if
you don't have a points column then you may need to get SQL to calculate it.
graeme.
Vikas N
Check for the slashes (/).
Even in Windows you must use UNIXish paths.
>From the httpd.conf file
# NOTE: Where filenames are specified, you must use forward slashes
# instead of backslashes (e.g., "c:/apache" instead of "c:\apache").
# If a drive letter is omitted, the drive on which Apache.exe i
* Ron Piggott <[EMAIL PROTECTED]>:
> Am I able to use the OR logic in mySQL queries?
>
> $query = "SELECT * FROM table WHERE date_received LIKE '$todays_date' OR
> '$yesterdays_date' ORDER BY prayer_request_reference ASC";
>
> In this above example will the " OR '$yesterdays_date' " work?
>
> In re
No - OR and AND tests work like this:
(first conditional test) OR (second conditional test)
therefore
((date_received LIKE '$todays_date) OR (date_received LIKE
'$yesterdays_date'))
And of course you will check the MySQL docs to confirm that OR does work in
the WHERE clause, won't you?
Another
You might want to pattern you SELECT statement in this manner:
SELECT * FROM `tablename` WHERE status = 3 OR status = 1
Notice I called the field name explicitly on each side of the OR.
Be sure to check the data type for the date field -- if it is a datetime
stamp or date stamp, it might complai
Am I able to use the OR logic in mySQL queries?
$query = "SELECT * FROM table WHERE date_received LIKE '$todays_date' OR
'$yesterdays_date' ORDER BY prayer_request_reference ASC";
In this above example will the " OR '$yesterdays_date' " work?
In reality I am wanting to preview new entries to the
Hi
I am new to php and mysql and am having a few problems that I hope someone can
help with.
What I am trying to do is to display ratings for particular teams using some
basic code. I needed to print the information out on a table with the highest
average at the top and then ascending. I ha
the standard things apply here
check spelling and case
check folder permissions
bastien
From: chintan <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] stuck on module of apache
Date: Sun, 17 Apr 2005 11:00:14 +0530
hey guys i stuck on that old error
the specified module cannot be foun
pete M wrote:
I've got a database table with a whole list of "windows" file paths.
eg
Advent Tower PC\C\Program Files\Microsoft Office\Microsoft Binder.lnk
Advent Tower PC\C\Program Files\Microsoft Office\Microsoft Excel.lnk
Advent Tower PC\C\Program Files\Microsoft Office\Microsoft Office Setup.ln
