Ok. I'll set up indexes on those two fields.
I was also wondering whether a JOIN query might improve the performance. Any ideas?

No. Would that help significantly?

Hi all.
I am writing a utility to manage virtual users on a mailserver w/ mysql backed. Unfortunately I am having performance issues when querying for the user's last access date/time.

DB has...

kudos! :cool:

Hi all.
I have a table with a this records:


<!-- Table user_activity -->
<user_activity>
<id>1</id>
<event>LOGIN</event>
<username>user@domain.com</username>
...

do you have any tips on where to start?

Hi all.
I am attempting my first Gnome applet creation and I found a great
tutorial at http://projects.gnome.org/ORBit2/appletstutorial.html .
Unfortunately, I am stuck where the example goes to...

Hi all.
I am currently developing a CMS for a school project and I wanted to add the function to check, real-time, if a username is already taken. It should be a little bit like what happens when...

Hi guys.
I have a DB table looking like this:

#DATE #NAME #C1 #C2

2007-08-27 user 1250 2294
2007-08-28 user 1816 3096
2007-08-29 user 89 3153
2007-08-30 user 71...

thanks.
i'll see if it can solve my troubles :D

hi.
maybe the solution to my problem is quite obvious but I can't find it, so I'm asking here.I'm building a small movie db with the chance for users to borrow the title they want.
the movies' info...

Hi.
The code GliderPilot posted is great, but now it seems like the $pic_code[$pic_num] trick doesn't work.
Only the first picture gets displayed and all the other are broken.
This is what happens...

Thanks!
I'll see tonight if I can get it working

Hi.
I'm trying to write a script that fetchs image codes from a mysql database to display them into a 3 columns table.

I got this so far:

$selection = $_GET['scelta'];

$query = 'SELECT...

hi.
i am developing a small module for the linux 2.6.14 kernel.
so far i have been able to create the character devices that will contain any kind of char data i send them.

for example, if i...

hi.
my problem is plain simple but still i couldn't make it out.
it's all very basic stringwork (keyboard input, println, ...) but when I get to the point of writing the output file, nothing...

ok that solved that problem.
the thing i don't really get is how to tell it to read lines 2+3 then skip line 4 and read line 5 (ecc...)

thanks!that worked.
but now my problem is how to deal with the input file, in my code i tryed to select the needed infos but the output looks pretty awful.
this is a /proc/cpuinfo formatting


...

hi everybody.
i am trying to develop a program that will be able to read and export informations (hw, sw, kernel, netstats..ecc) from a linux computer.
my idea was to use the files in the /proc...

hi.
question 1:
i am writing a small C script to convert files to another format.
in this case i need my script to use all files in a directory that have extension .htm - how can i do this?
the...

hi.
i am planning to design a plugin for Evolution Groupware suite (Website (http://www.gnome.org/projects/evolution/)).
it's the first plugin i ever try to write so i'm not really sure of where to...

i am currently running windows xp, i have a floppy drive but not any usb storage devices.
i already tryed installing suse and debian directly from ftp (booting it first from floppy disks) but my...

i have a workstation with broken cd drive and i was intrested in installing linux.
what alternative methods can i use to do it, and with which distros?
tnx

god bless you it works perfectly now!
grazie mille :cheesy:

thanks alot the sinus problem is solved now.
this is the final code:

// Calcolo formula per Legge di Murphy (www.andreagozzi.com)
// Inclusione librerie in directory di sistema
#include...

i am confused now, that's sure...
so then if i want to get a decimal result of (1-sin((x/10)) what do i have to do considering x is a number between 0.00 and 9.00?

i just installed on my machine last version of slackware.for the moment it runs perfectly :cheesy: .
i wanted to be able to play media files but nothing seems to be able to run, neither mp3 or ogg...

ok i did that.thanks


the link is (#include <math.h>) ok but i'm not sure about the sin() function because somebody says the output is in radiants while other say in decimal numbers

// Calcolo formula per Legge di Murphy (www.andreagozzi.com)
// Inclusione librerie in directory di sistema
#include <math.h>
#include <stdio.h>
#include <string.h>
// Funzione Main()
main()
{...