[PHP] help with query

Hello All, I have this string defined for my query and it shows the different types of categories fine, but when I change a.categoryid = c.categoryid to a.categoryid = 1 which is only one of the categories It shows me the same record twice. $query = select a.startdate, a.articleid,

Re: [PHP] help with query

Jack jacklistm...@gmail.com wrote: Hello All, I have this string defined for my query and it shows the different types of categories fine, but when I change a.categoryid = c.categoryid to a.categoryid = 1 which is only one of the categories It shows me the same record twice. $query =

Re: [PHP] help with query

On 06/07/2012 09:37 AM, Jack wrote: $query = select a.startdate, a.articleid, c.name, a.title, a.intro, a.datecreated from articles as a, categories as c where (a.startdate = -1 or a.startdate= {$now}) and (a.enddate = -1 or a.enddate= {$now}) and a.categoryid = c.categoryid order by a.startdate

RE: [PHP] help with query

Thanks Jim, worked like a charm. -Original Message- From: Jim Lucas [mailto:li...@cmsws.com] Sent: Thursday, June 07, 2012 4:08 PM To: Jack Cc: PHP Subject: Re: [PHP] help with query On 06/07/2012 09:37 AM, Jack wrote: $query = select a.startdate, a.articleid, c.name, a.title

[PHP] Help with query MySQL and PHP

Hi, I want to create a new column or table from queries of the values of columns I( already have. My table is : PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS products_id products_extra_fields_id products_extra_fields_value 1 1

[PHP] Help: DOMXPath-Query, quotes and apostrophes

I seem to be hitting a wall here. I have the need to run an XPath query on strings that may contain quotes, apostrophes or both. Going through google turned up some interesting information, but nothing that solved my issue. An example of what I am trying to do is as follows: $query = '\'foobar';

[PHP] Help with query

Hi I need the students that didn't take an exam. The tables: exams(id_test, title, desciption, ) results(id_student, id_test, date, qualification...) I'm using a version of MySQL that doesn't support NOT IN, then I tried in this way: SELECT * FROM exams LEFT JOIN results ON

[PHP] Help with query

Hi, i can´t seem to get my head to wake up... How would i do to count how many different values that exists in a mysql field? Ie i have a date-field and need to know how many different dates that exists in the table. Regards # Daniel Alsén| www.mindbash.com # # [EMAIL PROTECTED] | +46 704

Re: [PHP] Help with query

$number=mysql_num_rows(mysql_query(SELECT DISTINCT date FROM $table)); Op zaterdag 09 februari 2002 13:41, schreef Daniel Alsén: Hi, i can´t seem to get my head to wake up... How would i do to count how many different values that exists in a mysql field? Ie i have a date-field and need to

Re: [PHP] Help with query

Hi, i can?t seem to get my head to wake up... How would i do to count how many different values that exists in a mysql field? Ie i have a date-field and need to know how many different dates that exists in the table. select count(distinct name) from site; in Mysql Valentin Petruchek (aki

SV: [PHP] Help with query

Thanks guys! - Daniel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php