Search results for query: *

I meant to say it returns no results, if I run ... SELECT `lrc_visits_tmp`.* FROM `lrc_visits_tmp` WHERE `lrc_visits_tmp`.`vendor` IN('google','quigo','quigo-aol','pulse360','yahoo','msn'); I GET results Sorry Mike

...= 'ppc' I get, 'google','quigo','quigo-aol','pulse360','yahoo','test','msn' I am running the following... SELECT `lrc_visits_tmp`.* FROM `lrc_visits_tmp` WHERE `lrc_visits_tmp`.`vendor` IN(SELECT GROUP_CONCAT('\'',`lcr_vendors`.`vendor`,'\'') FROM `lcr_vendors` WHERE `lcr_vendors`.`type`...

That did it, I had tried that earlier and it was only showing something like 00:45:45 in excel, I just realized that, when I double click the cell in excel it turns it into a date... strange. anyway thank you, it worked great as you wrote it.

I have a query i use in access that looks like this, DateAdd("s",dbo.scheduling_timerange.begintime/1000,#1/1/1970#) when i use it in MSSQL it throws and error at the # what i am attempting to do is convert a bigint to a date time in MS ACCESS i run the query on 1210164900000 and i get...

Resolved! I discovered why this was happening... This line of code... include 'grab_pa.php'; Had a connection string to another database for dynamically creating a user drop down from the login database, It was killing the connection for the query as the loop ended. You guys would've...

Clive, no luck... I thought you were on to something :( It wouldnt even pull the first row with that... which is weird... I changed it dropping the pcc_patient. and it brought the first row back. Is this something that should be doable? I could swear I have done this before. Mike

Clive, The second query "requeries" the table and lists all previous concerns and dumps them into a <div></div> that allows the Patient Advocate to hover on an image and uses js/css to pop up the div and show all previous calls and who made them... its an assigning tank and the PA wants to make...

this is a model of the data i get... [Name ][SX Date ][Blah ] [Doe, John][2008-01-01][Other Stuff] <main query> [Concern Date][Patient Manager] <second query> [2008-01-11 ][someuser ] [2008-01-15 ][someuser2 ] [2008-01-11 ][someuser2 ] [2008-01-12 ][someuser...

jpadie I thought of that, thats why i put that known multiple patient concern ID in ... from my first messy post lol... the 102023 id... it has 6 results which return in the first row only... its weird. the first row of the first query works perfect. Clive, hard coding the 102023 id in should...

the second query actually is like this... $inner_result = mysql_query("SELECT pcc_concerns_date, pcc_concerns_prac_int FROM pcc_concerns WHERE pcc_concerns_contact_id = '". $r["pcc_concerns_contact_id"] . "' ORDER BY pcc_concerns_date desc"); while($ir=mysql_fetch_array($inner_result))

...the $r["pcc_concerns_contact_id"] is empty on the second loop. Will it not carry into the second loop? $result = mysql_query("SELECT pcc_concerns.*, pcc_patient.*, pcc_patient_sx.* FROM pcc_concerns JOIN pcc_patient ON pcc_patient.pcc_patient_contact_id =...

...$color22 = "#B7DBEC"; $color11 = "#FFFFFF"; $row_count = 0; // Start Main Query $result = mysql_query("SELECT pcc_concerns.*, pcc_patient.*, pcc_patient_sx.* FROM pcc_concerns JOIN pcc_patient ON pcc_patient.pcc_patient_contact_id = pcc_concerns.pcc_concerns_contact_id JOIN pcc_patient_sx on...

Hi all, i am trying to make an array that looks like this ... 40,55,40,55,56,122,652,37 i can create 40,55,40,55,56,122,652,37, with an echo. I have always echoed for html, now i need to store the 40,55,40,55,56,122,652,37, then i was going to use sub_str() to remove the last comma. the...

...return false;\">"; } ?> Your whereyoursqlis.php file would contain something like this <? $php_var = $_POST['php_var']; $q=mysql_query('select * from table where usercode="$php_var"') ?> <another redirect here (meta or js)> doing it this way, your php runs AFTER the js prompt runs

Hello, I am trying to come up with a way in Mysql to use a stored procedure to connect to our web database and update table in our internal database. I have php script that does it now once a day What i would like to accomplish is sweeping our WEB DB every Five minutes to grab new leads. Is...

Tank you very much!!

...Dim", "Input L Dimension") X1 = 0.0569 Y1 = 0.6874 X2 = 0.273406 Y2 = 0.8124 X3 = 0.150719 Y3 = 1.0249 XSINE = Sin(30) * S YSINE = Sin(60) * S S1X1 = X1 + XSINE S1Y1 = Y1 - YSINE S2X1 = X2 + XSINE S2Y1 = Y2 - YSINE 'Add a Point Set...

What I was wondering was, Is there a way to use the .htpasswd and not effect internal connection? I want to make some of our Intranet available so folks can work from home. I already use php with a login system, but I was hoping for a little extra security when coming from the outside by adding...

Ok, thank you much :) Mike

I spose I could do that, but its kinda risky to mess with a major query that would change over 500,000 phone numbers on a system that is running 24/7 with over 75 users. Really all I wanted to know is... is there a function like php.. preg_replace("/[^0-9]/", "", $phone) For Mysql :) Thanks...