Posted by Tom on 11/03/07 19:29

On Fri, 02 Nov 2007 21:12:42 -0500, Jerry Stuckle wrote...
>
>jcage@lycos.com wrote:
>> I have four fields, "name", "date", "task", and "title" - and am
>> trying to PHP code where if I click 'All', all rows for 'Bob' followed
>> by all rows in a MySQL datebase for 'Jim' and then all rows for 'Joe'
>> would be displayed alphabetically (by name), with all of Bob's rows
>> grouped together and then all of Jim's and then all of Joe's, etc
>> (versus the way they may reside in the MySQL table).
>>
>> My query works well for individual names and also for 'All' but it
>> would look and be easier to read if I could group the rows by name and
>> maybe list alphabetically. My 'All' code portion currently looks like
>> this:
>>
>> $query =
>> "SELECT *
>> FROM $table
>> WHERE 1 = 1 ";
>> if($name != "All") $query .= "and name = '".$name."'";
>>
>> $result = mysql_query($query);
>>
>>
>> thanks for any help...
>> John
>>
>>
>
>You're asking about SQL, not PHP. Try comp.databases.mysql.
>


I get alt.php.sql on my newsgroup list, and that's helpful for SQL related
questions too.


Tom
--
NewsGuy Free Trial Accounts
Now a massive 20 Gigabytes of unrestricted downloads !
http://newsguy.com/

[Back to original message]