Jim Lucas <[EMAIL PROTECTED]> wrote in message
012301c16d3a$6def13c0$96def5cc@bendcom">news:012301c16d3a$6def13c0$96def5cc@bendcom...
> Here are a few pointers to make it run just a little faster also.
>
> don't extract the entire $GLOBALS array. just use the $var that you need.
> function GetData($Query)
> {
> return(mysql_query($Query, $GLOBALS[db_conn]));
> }
The problem with this approach is that I do not know ahead of time which
GLOBALS
I will need (other than $db_conn). For instance, once query may depend of
the $ClassID
and $Attendance variables while another depends on the $StudentID and $Grade
variables
>
> why are you using a define to set an SQL query string?
I am using define to set SQL query strings because there are a limited
number (30 or so)
of queries used by the application, but they are used in different contexts.
So, for example,
I may have:
"SELECT FirstName, LastName, Grade, Attendance FROM Students, Classes
WHERE Students.StudentID = Classes.StudentID AND ClassID = $Class"
defined as StudentsByClass. I can then pass the function the constant and
use it in
different situations. For example:
PrintMenu("Students",GetData(StudentsByClass));
will print a menu of student names whereas:
PrintAttendance(GetData(StudentsByClass));
would print an attendance report
Fred
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
