Re: [PHP] Re: MySql or flat database using PHP ?

2001-08-18 Thread Hugh Danaher
Sorry Emilio, this should have gone to Dave. - Original Message - From: Hugh Danaher [EMAIL PROTECTED] To: Emilio Panighetti [EMAIL PROTECTED] Cc: Php-General [EMAIL PROTECTED] Sent: Saturday, August 18, 2001 5:16 PM Subject: Re: [PHP] Re: MySql or flat database using PHP ? Dear Emilio

[PHP] Re: MySQL Queries - Which to Use?

2001-08-17 Thread _lallous
It all depends on you, I basically get used on using mysql_fetch_array which returns an associative array. example: $result = mysql_query(SELECT name, lastname, age FROM table); $ra = mysql_fetch_array($result); or $ro = mysql_fetch_object($result); or $rr = mysql_fetch_row($result); now: echo

[PHP] Re: MySQL Multi-Table Select Query Problem

2001-08-15 Thread Hugh Bothwell
Charles Williams [EMAIL PROTECTED] wrote in message 008801c12588$80bc7960$fe0aa8c0@chucks">news:008801c12588$80bc7960$fe0aa8c0@chucks... Hey folks, if you go to http://www.acnsnet.com/czc/show.php?state=Bayern You can see my problem with this query. This thing is killin me so if you have

[PHP] Re: mysql escape character \'

2001-08-07 Thread hassan el forkani
thanks everybody for your help, i actually had the solution before posting :)) my question was not a 'how to' but why do we need to escape single quotes on unix systems and not on windows using the same version of php and mysql? At 21:44 07/08/01, you wrote: Dear PHP-General (bit of strange,

Re: [PHP] Re: mysql escape character \'

2001-08-07 Thread David Robley
On Wed, 8 Aug 2001 09:28, hassan el forkani wrote: thanks everybody for your help, i actually had the solution before posting :)) my question was not a 'how to' but why do we need to escape single quotes on unix systems and not on windows using the same version of php and mysql? You

[PHP] Re: Mysql join and aliasing with mysql_fetch_object()

2001-08-03 Thread Richard Lynch
select tableA.*, tableB.* from tableA, left join tableB ON tableA.keyfield = tableB.keyfield When I then try to access the column keyfield, after using select tableA.keyfield as mykeyfield, tableA.*, tableB.* ... Unless you actually need *EVERY* field, do *NOT* use tableA.*, tableB.* Every

[PHP] Re: mysql error

2001-07-15 Thread Leon
Maybe you run out of diskspace?? Greets, Leon Elias wrote: Table is full? did you try searching MySql.com for Table is full error message? Andreas ) [EMAIL PROTECTED] wrote in message 000c01c10b81$c765aa60$8d0a@devel01">news:000c01c10b81$c765aa60$8d0a@devel01... hi all, my

[PHP] Re: mysql error, dont see why.. please help

2001-05-22 Thread Joseph Bannon
Correct, SET must be before WHERE. Joseph CollegeSucks.com -Original Message- From: Tyler Longren [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 4:04 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] mysql error, dont see why.. please help Shouldn't it be:

<    1   2   3   4