[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 nee

[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

[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: http://www.php.net

Re: [PHP-DB] how to find

ing stupid questions "-{ 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 &

[PHP-DB] search query

Hi I have a option box with values Less than 150.000 tot 175.000 tot 200.000 tot 250.000 tot 300.000 tot 350.000 tot 400.000 More than 400.000 I need help when the user

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

T start_date, end_date, 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

[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 06-

Re: [PHP-DB] SELECT

2"? > > _____ > - Original Message - > From: "peppe" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, March 04, 2004 13:22 > Subject: Re: [PHP-DB] SELECT > > > > Hi > > I made

Re: [PHP-DB] SELECT

; ... > FROM users > WHERE FIND_IN_SET( 2, values ) > 0 > > Ignatius > _ > - Original Message - > From: "peppe" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, March 04, 2004 12:28 > Subject: [PHP-DB] SEL

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

[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 unsubscribe

[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 showMonth

[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= $ro

[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 $acces

Re: [PHP-DB] array

what I can work out you need to use 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] &

[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