[PHP-DB] Compare columns

Hi guys, I really need some help. I have two tables tbl_question with 2 columns question_id , question_name and tbl_answers with 3 columns answer_id,answer_name and questionFK. I want to get values from question_id and compare them with questionFK if some values are missing in questionFK then I

[PHP-DB] delete multiple query

Hi guys , Maybe this question was posted earlier but I could not find it I have couple of tables tblCountry tblCity tblStreet tblUser I have foreign keys tblUser.street_FK = tblStreet.street_id tblStreet.city_FK = tblCity.city_id tblCity.country_FK = tblCountry.country_id I have PHP Version 4.3.2

Re: [PHP-DB] how to find

-{ Rene Brehmer }- [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 1. learn the basics of arrays 2. RTFM At 12:27 11-11-2004, peppe wrote: Hi , I have numbers in my array 0 0 0 1 1 1 1 1 1 1 1 0 0 0 0 or 0 0 0 0 0 0 1 1 1 1 0 0 0 0 0 or 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 how

[PHP-DB] how to find

Hi , I have numbers in my array 0 0 0 1 1 1 1 1 1 1 1 0 0 0 0 or 0 0 0 0 0 0 1 1 1 1 0 0 0 0 0 or 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 how can I find the first 1 and the last is there a function for it Regards -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] search query

Hi I have a option box with values select name=prijsklasse class=bodyzwart id=prijsklasse option value=1 selectedLess than 150.000 option value=2tot 175.000 option value=3tot 200.000 option value=4tot 250.000 option

[PHP-DB] how to show this querry

Hi , I have a problem with showing a query I have a table project with start date end date and project title I want to show only the projects that they are given in table for that month, for example project that starts 06-09-04 and ends 09-09-04 or ends 12-02-05 but nt the projects that starts

Re: [PHP-DB] how to show this querry

, project_title from tablename where month(start_date)=09 and year(start_date)=04 this will show only the data pertaining to 09 month and 04 year. hope this will resolve your problem. with best wishes balwant -Original Message- From: peppe [mailto:[EMAIL PROTECTED] Sent: Monday

[PHP-DB] SELECT

Hi I have a table users with columns name email and access In email I have values [EMAIL PROTECTED] etc in access I have values 1,2,3,4,7,8 How can I filter value 2 ? Beacause I need only users with value 2 to send email Greetings -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] SELECT

The problem is in access values are like string 1,2,3,4,5 Richard Davey [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello peppe, Thursday, March 4, 2004, 11:28:30 AM, you wrote: p Hi I have a table users with columns name email and access p In email I have values [EMAIL

Re: [PHP-DB] SELECT

_ - Original Message - From: peppe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 04, 2004 12:28 Subject: [PHP-DB] SELECT Hi I have a table users with columns name email and access In email I have values [EMAIL PROTECTED] etc in access I have values 1,2,3,4,7,8 How

Re: [PHP-DB] SELECT

- From: peppe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 04, 2004 13:22 Subject: Re: [PHP-DB] SELECT Hi I made this query $sql= SELECT * FROM users WHERE FIND_IN_SET( 2, access ) 0 ; $result = mysql_query($sql); $numRows = mysql_num_rows($result

[PHP-DB] array months

Hi I realy need help hier I have a aaray of months $lang['months'] = array ( 1 = Januari, 2 = Februari, 3 = Maart, 4 = April, 5 = Mei, 6 = Juni, 7 = Juli, 8 = Augustus, 9 = September, 10 = Oktober, 11 = November, 12 = December ); and a function function showMonths2($montharray) { $maand =

[PHP-DB] Query

Hi I have this query $sql = SELECT * FROM events WHERE ( YEAR(datum) = ' . $year . ') ORDER BY datum ASC; $result = mysql_query($sql); $numRows = mysql_num_rows($result); for ($row = 1; $row = $numRows; $row++) { $rowArray = mysql_fetch_array($result); $datum=

[PHP-DB] array

Hi I have a variable cold $access and there are values 1,2,3,4,5 How can I check for example If ($access =='2'){ echo go further; } How can I make this work Thanx in advance -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] array

a function called in_array(value,array); http://www.php.net/manual/en/function.in-array.php here is the php manual link Hope this is what you want Brett -Original Message- From: peppe [mailto:[EMAIL PROTECTED] Sent: 11 December 2003 16:07 To: [EMAIL PROTECTED] Subject: [PHP-DB

[PHP-DB] Re: array

Hi Pete I forgot to write that $acces is a field from Db and there are values 1,2,3,4 a need to split those values to make that IF Brettking I think that is solution Peppe [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi I have a variable cold $access and there are values 1,2,3,4,5