[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 problems in my db. So let me re-ask it again

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] INPUT TYPE=CHECKBOX NAME=DELETE[?php echo message_id ?] VALUE=Y you will get an array named DELETE. check for every element in array DELETE

[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 any help would be appreciated. if i have a variable

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

2003-03-18 Thread Foong
equals to $ message_id } } hope this help Foong Mark [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] hello i have been trying to delete items from a guestbook using multiple checkbox fields but have had no success this is the code i have been using to add the checkbox's

[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 [EMAIL PROTECTED] wrote

[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... Hi all, I'm tryin

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

2003-01-16 Thread Foong
the $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_connect($host, $user,$password) //15

[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... Hello PHP world!!! i've just f

[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( 'localhost', 'root', 'thepassword' ) or die (

[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?? Foong