[PHP-DB] Arraying JOINED tables

Hi all. This should be an easy one for all of you. I want to make a basic SELECT query from two tables and fetch all the results into one array. I’m doing it like this: $query = "SELECT * FROM logins,auth WHERE logins.authname = $variable1 AND auth.authid = $variable2"; $result = mysql_query($qu

Re: [PHP-DB] Arraying JOINED tables

Try find out if you have an error in your query, like this: $query = "SELECT * FROM logins,auth WHERE logins.authname = $variable1 AND auth.authid = $variable2"; if ( $result = @mysql_query($query) ) { $row = mysql_fetch_array($result); } else { echo mysql_error(); } and the other thing... m

[PHP-DB] Extracting Time??

Hi all and sorry for bothering again. I need to fetch one time and date from a MySQL DB where is stored as TIMESTAMP (MMDDHHMMSS) to print it in a page but in common format (DD MM at HH:MM:SS). Actually, I don’t care ‘bout the st, nd and th extensions after the day. Thanks for any help

RE: [PHP-DB] Arraying JOINED tables <--- SOLVED

Thanks a lot. It was an error... a HUGE one though :-) César Aracena IS / MCSE+I Neuquén, NQN (0299) 156-356688 (0299) 446-6621 > -Mensaje original- > De: Denis Arh [mailto:[EMAIL PROTECTED]] > Enviado el: Domingo, 16 de Junio de 2002 04:28 a.m. > Para: [EMAIL PROTECTED] > Asunto: Re: [P

RE: [PHP-DB] Extracting Time??

Well... actually, I care about displaying it in Spanish instead of English ( Enero instead of January). Does anybody has accomplished this for Spanish or any other language? Is it possible? Thanks again, Cesar Aracena CE / MCSE+I Neuquen, Argentina +54.299.6356688 +54.

[PHP-DB] Re: [PHP] RE: [PHP-DB] Extracting Time??

I don't think there's a fucntion out-of-the-box for this, but it's only 12 months, so it'd be quite a simple function that you'd only ever have to write once :) Justin French on 16/06/02 6:20 PM, César Aracena ([EMAIL PROTECTED]) wrote: > Well... actually, I care about displaying it in Spanish

[PHP-DB] making sub dirs ?

Hi All I have been hunting the answer to this for ages now and hope one of you clever prople could help. I wish to create a subdirectory in my images directory using my visitors id number. So i have an /img dir for all images and wish to create a directory based on clients id num from db

Re: [PHP-DB] making sub dirs ?

On Monday 17 June 2002 23:45, Dave Carrera wrote: > Hi All > > I have been hunting the answer to this for ages now and hope one of you > clever prople could help. > > I wish to create a subdirectory in my images directory using my visitors id > number. > > So i have an /img dir for all images and

Re: [PHP-DB] Extracting Time??

On Sunday 16 June 2002 16:20, César Aracena wrote: > Well... actually, I care about displaying it in Spanish instead of > English ( Enero instead of January). Does anybody has accomplished this > for Spanish or any other language? Is it possible? > > Hi all and sorry for bothering again. > > > >

Re: [PHP-DB] making sub dirs ?

On Monday, June 17, 2002 at 4:45:30 PM, Dave Carrera wrote: > I wish to create a subdirectory in my images directory using my visitors id > number. Have a look at: http://www.php.net/mkdir -- Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/