Search results for query: *

I'm trying this but I think the syntax is wrong... WHERE coCity = '".mysql_real_escape_string($_SESSION['userinfo->city'])."' AND coStProv = '".mysql_real_escape_string($_SESSION['userinfo->stProv'])."'"; Any help is appreciated

I have a query that executes when I hardcode the username but not when I try to use the session var. Works: $q = "SELECT * FROM ".TBL." WHERE username = 'Me'"; Doesn't work: $q = "SELECT * FROM ".TBL." WHERE username = '$username'"; I have used: <?php print_r($_SESSION); ?> to print out...

Hello all, I have a php mailer that I would like to have redirect if the subject is != "accepted", I've never used a redirect on a mailer so it's new to me. So somethng like the code below $email = "name@mydomain.com"; if($subject = "accepted";){ $email = "name@mydomain.com"; $subject...

Hello all, I have a form that submits to a php mail and works just fine. I'd like to add to the submit button an "onclick" that loads up a .pdf document as well as submit the form. Any tips on this would be really helpful

It's been some time since I've used PHP and I've ran into a formatting issue in the body of an email I'm trying to send. The email works and the data is passed just fine but it all ends up on one line. What is the correct syntax for inserting a line break between my two html form values after...

Hello, I am trying to get the innerHTML of a specific a tag's href on my page. The a tag has a unique css class <a class="myClass" href="myURL"> I'd like to do something like this <script language="javascript"> function hello(){ var foo = document.getElementsByTagName("myClass")[0]; if...

Hello all, I'm running a web app in C# .NET and am trying to backfill my query by re-querying the DB if it returns less than three results. This is probably not a hard one but I don't know where to begin. Any tips are appreciated

Has anyone ever seen a browser specific js error? I'm experiencing one right now that has me baffled, throws the error in IE and Opera but not in firefox. Makes it hard to troubleshoot. Is there a list of the diffences between how browsers handle javascript somewhere? It is simply trying to...

Is it possible to grab the contents of a browsers address bar in C#? I know you can do it with JavaScript but I'm trying to get away from using client side scripts. TIA

I am new to XML and have tried at least a dozen ways to call an image in an XML file. I tried googling and reading the posts here but still no luck. Any help is appreciated.

I'm trying to run a while loop that will insert </td><td> after "RowCount" hits 20. I am using a DataReader to collect the data RowCount++; VAR+="<a href='my-page.aspx?data="+VAR+"'>"+LINK+"</a><br>"; Any help or suggestions are welcome

Hello all, I am trying to set up a "tip of the day" feature for one of our sites which reads the term from a text file, I am relatively new to C# so I am kind of struggling a little. public class textFromFile { private const string FILE_NAME = "termOfTheDay.txt"; public static void...

Hello all, I'm new to C# and am having some trouble with an update query // create DB connection string mydbdsn="server=SERVER; database=DB; user id=USER; pwd=PW;"; SqlConnection connection = new SqlConnection(mydbdsn); connection.Open(); strNewABS="UPDATE <TABLE> SET <COLUMN> = 'L' WHERE ID...

Hello everyone, This might be an easy one for some but I'm a newbie... I have a temp table that holds all of the items the user has put in their cart, when the order is actually submitted I would like to move the rows with orderID "blah" to the permanent table that will store the order info...

Hello all, I first want to say that this site and it's patrons have been incredibly helpful and an invaluable resource, thanks tek-tips I have a for loop which inserts data fine, the problem is that the variables in the loop can contain more than one item (i.e. multiple items in one order)...

Hello All, I have some some variables that can hold one or more pieces of data depending on what the user orders. I would like to be able to insert the data in individual rows (with the same orderID) if there is more than one item in these variables. The values are currently seperated by...

I'm relatively new to ASP and have been trying to troubleshoot this query for sometime now... sqlText = "INSERT INTO itemsOrdered " _ & " (orderID, productDesc, productID, itemPrice, beforeTax, sAmt, GST, PST, quantity) values " _ & " ("&intOrderID&"...

Hello All, I am stumped on this one... I have one version of this update query that works set rsPutItemOrder = Server.CreateObject("ADODB.Recordset") rsPutItemOrder.Open "itemsOrdered", Conn, adOpenStatic, adLockOptimistic, adCmdTable rsPutItemOrder.addnew...

Back Again, I have a project that was originally developed to run on an access db due to it's lack of traffic, now I trying have the same project use MySQL as it's db in anticipation of more traffic. Below is the connection string for my Dev (local) site. ConString = "Driver={MySQL ODBC 3.51...

Hello All, I'm new to MySQL and am trying to use MySQL Front with version 4.1.10 of MySQL, I'm having difficulties accessing MySQL with MySQL Front. It comes back with one of two errors: (if i put "root" user and "root" in pw) Client does not support authentication protocol requested by server...