[PHP-DB] Storing sesssions in a db bad for the performance?

Hi there, I am wondering if it is producing a lot of extra load if I would store the sessions inside a mysql db. I use phbb as a discussion board as well, and I saw that those guys are doing that. Does anybody have some experiance on that? Or knows a good article? Thanx for any help, ANdy --

[PHP-DB] text area

I am wondering where I could find a good tutorial on displaying the contents of a database field within a textarea for editing. Any help would be great! Thanks in advance, Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] select rows from more than one table, how?

Hello, I want to make a query that will select rows from more than one query, does anybody know how to do that? I already tried this: SELECT * FROM table1, table2 WHERE (conditions) But I get a error with this query. I also looked at the mysql site for this case, but I didn't find any answer (I

RE: [PHP-DB] select rows from more than one table, how?

First: show us your exact query Second: show us your exact error response Third: show us your exact code and table structure -Original Message- From: Sander Peters [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 3:03 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] select rows from m

[PHP-DB] how can i join this two selects

hy, maybe im blind about this problem: thats a row of my table(sql follows at the endof that mail) named immo_kat kat_id - immo_id - cr_uid - tstamp -- --- -- -- ... 35 - 318- 1- 1015874898 34 - 318- 1- 0 ... now i like to get all immo_i

RE: [PHP-DB] how can i join this two selects

Vieliecht: SELECT kat_id,immo_id FROM immo_kat WHERE immo_id=318 &&(kat_id = '1' OR kat_id = '35' OR kat_id = '34') ORDER BY immo_id; -Original Message- From: Michael Plies [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 4:01 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] how can i jo

[PHP-DB] Ooops- i need it in mysql -i forgot to say

Ooops- i need it in mysql -i forgot to say Michael Plies wrote: > hy, > > maybe im blind about this problem: > thats a row of my table(sql follows at the endof that mail) named > immo_kat > > kat_id - immo_id - cr_uid - tstamp > -- --- -- -- > ... > 35 - 318- 1

[PHP-DB] GREATEST, LEAST

Could anyone give me an example of how to use GREATEST and LEAST in a MySQL query. I want to look through the last 15 records in a certain field and find the highest and/or lowest number. Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php

RE: [PHP-DB] GREATEST, LEAST

Is it perhaps actually MAX and MIN? SELECT MAX(profit) FROM schemes WHERE revenue>expenses (not tested, confirmed etc :P) HTH Beau // -Original Message- // From: Jeff Oien [mailto:[EMAIL PROTECTED]] // Sent: Tuesday, 12 March 2002 10:20 AM // To: PHP-DB // Subject: [PHP-DB] GREATEST,

Re: [PHP-DB] GREATEST, LEAST

>I want to look through the last 15 records ORDER BY ?? LIMIT 0,15 >d find the highest and/or > lowest number SELECT MAX(field),MIN(field) Op dinsdag 12 maart 2002 03:19, schreef u: > Could anyone give me an example of how to use GREATEST > and LEAST in a MySQL query. I want to look through th

[PHP-DB] An interesting query that needs a different pair of eyes

Howdy, group! Well, I sure felt like I was on the right track with this one, but just can't get around the last curve. Hopefully I can explain it well enough that somebody could help navigate... What I'm trying to do is display a list of division names assuming that each division has at least 2

[PHP-DB] Creating an array of mySQL results with PHP

I am working on the creation of Web-based database where parents log the hours they spend participating in school activities. (The school requires that parents spend two hours each week.) I have a prototype demonstration site at http://fuzzheads.org/demo As currently constructed, the parent log

RE: [PHP-DB] Creating an array of mySQL results with PHP

Well, you could use the power of PHP arrays and just name your input fields in such a way that would create an array upon submittal. For example: Then, after submittal, you just loop through the array $log like such: foreach($log as $week_no => $data) { $sql = "UPDATE table SET classroo

Re: [PHP-DB] Creating an array of mySQL results with PHP

OK. I can see how that works, assuming that the value would be \"log[$week_no][classroom]\" as well. What would the mysql_fetch_array look like? - Original Message - From: "Shrock, Court" <[EMAIL PROTECTED]> To: "'John Hughes, Jomari Works'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent:

RE: [PHP-DB] Storing sesssions in a db bad for the performance?

Hi I do this and have no problems. I don't have two similar sites to compare , but performance seems fine. HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL P

RE: [PHP-DB] Creating an array of mySQL results with PHP

Actually, you want the value of the input to be just "$classroom". That is because it is within the while loop. Can I ask for a little more information regarding the structure of the table that you are querying--what is(are) the primary keys in the table; I am assuming that the "week_no" field i

Re: [PHP-DB] Creating an array of mySQL results with PHP

First, I admit to being VERY new to PHP and mySQL and, to make matters worse, I'm self-taught.. If you visit the demo site at http://fuzzheads.org/demo you might better understand what I'm attempting to do and that might help better explain my confusion with your suggestion. The Parent Log displ