[PHP-DB] Assistance on Query

Hi People, I would like some assistance on the following scenario. I have to pull out all records for a particular userid (easy enough) and then only show those entries where the follwing occurs. These records from the table will contain either an entry in the services_type field or the

RE: [PHP-DB] Assistance on Query

the entries by date. I hope that clears things up a little. - Shannon -Original Message- From: Jochem Maas [mailto:[EMAIL PROTECTED] Sent: Monday, January 17, 2005 1:37 AM To: Shannon Doyle Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Assistance on Query Shannon Doyle wrote: Hi

RE: [PHP-DB] Dates and Count

Hi Pablo, Its exactly what I wanted. Thanks. I now have an additional question. I need to show results that appear between two dates as specified by the site visitor. At the moment I am using the following SQL: WHERE NextContact = '$today' NextContact = '$week'; Second I need the same

[PHP-DB] Dates and Count

Hi People, I have two queries for the list:- First, I have two dates stored in a MySQL DB that I want to do a compare on and then only display via a web page those records that have a 5 or greater day difference in them. What would be the best way to achieve this. Second, I want to be able to

[PHP-DB] Date Manipulation

Hi People, Need some assistance in the following scenario:- Inserting a date into the database that is entered into a form by the site visitor. - This is easy enough. However I now need to use the same date that has been entered by the site visitor add 35 days and then insert into another

[PHP-DB] populating select and searching to criteria

Hi People, I have a three part question here. Well actually its 3 separate questions. First. How would I populate a select menu from a mysql databse with the entries from a particular field, but only showing those that are unique, ie not showing more than 1 of the same value. Second. How

RE: [PHP-DB] populating select and searching to criteria

Thanks Micah, while ($d = mysql_fetch_assoc($return)) { ?option value=?=$d['value']??=$d['name']?/option - I get a parse error on this line. while ($d = mysql_fetch_assoc($return)) { ?option value=?=$d['value']?? if ($other_table_value == $d['value']) echo selected;

[PHP-DB] REGEXP and Variables.

Hi People, Need a little assistance with the following MySQL query:- $query = SELECT employ_id,company FROM employers WHERE employ_id REGEXP '($employ_id)' OR company REGEXP '($name)' OR industry REGEXP '($industry)'; The above query gets the variables $employ_id, $name and $industry from a

RE: [PHP-DB] Mysql result resource error

of the same data. Its like it is doing each query three times or something. Don't know why it is doing that. - Shannon -Original Message- From: Jim Lucas [mailto:[EMAIL PROTECTED]] Sent: Friday, 21 December 2001 03:52 AM To: Shannon Doyle; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Mysql

[PHP-DB] Query Help

code in the Category Names, however, they are meant to be = dynamic as they will be changing on a monthly basis. Any help would be appreciated. Thanks Shannon ___ Shannon Doyle Web Design Consultant BIGBLUE Internet Pty Ltd 149 Hutt St, Adelaide SA 5000 Ph +61 8

[PHP-DB] MySQL Query structure

Hi people, I was approached by my boss today to construct a page to draw out the data from a recent survey that was conducted via the web. The data is stored in a mysql database by fieldname and the data that the user entered. The problem lies in the way that he wants the page constructed. The

[PHP-DB] Varible insert

Hi People, It seems like all I am doing lately is going into areas of php that I haven't done before and get stuck. Anyway, here is another small request that I have. I have a series of pages that must insert into a mysql database the results of the entries. I know how to insert these details

[PHP-DB] Some assistance please

Hi People, I have a sql query running an array'd result that should echo a different result depending on the result of the query. However, it successfully does one of the entries from the query, but then appears to stop. With no further results displayed. Could someone take a look at the code at

[PHP-DB] Stopping echo

Hi People, Below I have included some code that just doesn't seem to be functioning all correctly. I have this running and it appears to stop the query/echo after the first entry in the database. What is it that I am doing wrong here?? Regards, Shannon ? $roundnum = ""; $sql = "select * from

[PHP-DB] Echo function stopping

Hi People, Below I have included some code that just doesn't seem to be functioning all correctly. I have this running and it appears to stop the query/echo after the first entry in the database. What is it that I am doing wrong here?? Regards, Shannon ? $roundnum = ""; $sql = "select * from

[PHP-DB] Multiple Order By

Hi There, I have a situation that requires me to do a multiple orderby on a MYSQL /PHP query. ie select * from Blah where test='testing' order by field1 then by field2 I am wondering if this will work or is there some other way I can acomplish such a task. The ordering should be decending.