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

I have a Table with the follwing, +----+------+-----------+ | id | type | vendor | +----+------+-----------+ | 1 | ppc | google | | 2 | ppc | quigo | | 3 | ppc | quigo-aol | | 4 | ppc | pulse360 | | 5 | ppc | yahoo | | 6 | ppc | msn | +----+------+-----------+...

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))

My code works fine other than the loop... I will clean it up when it works, the question was why the second query only has a result for the first row... it doesn't grab the info on the next loop through. From what i can gather the $r["pcc_concerns_contact_id"] is empty on the second loop. Will...

I have a query I am attempting that allows a manager to hover on an icon and see who the last assigned user to a patient was, I am nesting a loop inside a loop, it works but only on the first result... I have done this in the past and had it work fine but cant seem to see my mistake here. the...

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...

Are you trying to enter the user input and then run the php from it? if so, simply create a "hidden" form, have the prompt be part of a function that writes the value to the form then submits it with a onload js submit, something like below... <script>your function</script> echo "<form...

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!!

I am not very fluent in VB, I have the following macro for drawing points in the cam program I use to program wire EDMs Sub cdb() 'Macro Recorder 8/31/2007 by Mike On Error Resume Next 'Declare the variables Dim App As Esprit.Application Dim doc As Esprit.Document Dim...

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...