[PHP-DB] Re: multiple queries in PHP to mysql database.

2003-03-27 Thread Foong
sorry i am abit slow it would be helpful if you can describe what's store and purpose of the 2 tables Foong "Jerry" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Hi, > > I just noticed a problem with my question which would > cause major

Re: [PHP-DB] Re: deleting records using a checkbox

2003-03-19 Thread Foong
oh yes, Sorry my mistake should be: if($val == 'Y') Foong "John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > VALUE="Y"> > > > > > > you will get an array named DELETE. > > > >

[PHP-DB] Re: deleting records using a checkbox

2003-03-18 Thread Foong
helo, make your checkbos name into array: you will get an array named DELETE. check for every element in array DELETE foreach($_POST['DELETE'] as $message_id => $val) { if($val ==1) { // delete record where messahe ID equals to $ message_id } } hope this help

[PHP-DB] Re: Really easy question

2003-03-18 Thread Foong
try $with_quote = '"0"'; $without_quote = str_replace('"', '', $with_quote); Foong "Jeremy" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hey folks, Im apologize that this is just a really easy general php question but

[PHP-DB] Re: mysql - first element missing

2003-03-07 Thread Foong
i guess the problem is the last line of your Query function: $this->ligne = @mysql_fetch_row($this->result); this line fetch the first row of the result. therefore, when you call afficheResultatRequete(...) you start from the second row of the result. Foong "F.Collineau" &

[PHP-DB] Re: SUM(colname)

2003-01-18 Thread Foong
if i am not mistaken SELECT SUM(colname) WHERE value = 'value' only return one row, and that's the sum you want i guess. Foong Cesar Aracena <[EMAIL PROTECTED]> wrote in message 01c2be5d$087868a0$7a00a8c0@NOTEBOOK">news:01c2be5d$087868a0$7a00a8c0@NOTEBOOK.

[PHP-DB] Re: MySQL problem with RedHat 8

2003-01-16 Thread Foong
did you compile php with mysql support? foong "Daniel Elenius" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi! > > I'm trying to connect to my mysql database using something like > > mysql_connect( 'loc

[PHP-DB] Re: SELECT problem

2003-01-16 Thread Foong
try put the following line right after you call mysql_query(): echo mysql_error(); see what's the error. Foong "Sabina A. Schneider" <[EMAIL PROTECTED]> wrote in message 001001c2bde8$de3c95d0$489346c8@mansa">news:001001c2bde8$de3c95d0$489346c8@mansa...

[PHP-DB] Re: $user=$email

2003-01-16 Thread Foong
$user and $pass see if they are the correct. hope this help Foong "Addison Ellis" <[EMAIL PROTECTED]> wrote in message news:a05010410ba4b2c6694e9@[65.80.190.170]... > hello, > i am trying to do the following: > case "login": >$connection = mysql_

[PHP-DB] Informix

2003-01-14 Thread Foong
Hello, Does any one know how to connect to Informix database on a Different server?? I have searched on google, php.net but couldn't get a details guide on what to set. the ifx_connect() does not give me an option to pass in the database server ip. Do I need to set it somewhere else??