botlife

That is a really good idea. Let me whip something up.

Okay, when I echo the query, the first entry has results and every other entry is echoing SELECT Name, Phone, BillingCity, BillingState from Account WHERE Id = '003G00000184ong'array(0) { } with no results. The ID though is different on each one so that is working, it just isn't running the second query more than once. Maybe it is because $query is the same variable name each time. Maybe there should be ++ on each $query and $response. I didn't join the tables because one is on a Wordpress database and the second is using Salesforce API. I have joined on the same database before, but not to separate entities.

The array has only one row because the query is focused on only one ID and not all the IDs. The main loop is pulling the Salesforce IDs I have stored in Wordpress. The second loop is then taking that ID and running the second query through Salesforce. So without the second loop it will only return that one result which happened in the Dump and is happening in the second loop currently. Each run through should re-run the Salesforce query to yield a result and it isn't doing that. I can echo all the IDs so that isn't the problem. The problem seems to be that I can only use the second query once. I think I am doing something backwards.

Hey there, so I have a custom Wordpress loop that is working just fine. Inside that loop I have a second loop using Salesforce API. What is happening is that the main loop is looping but the secondary Salesforce loop is showing the same record for each and not looping. There is a unique ID for each so that isn't the problem. while ($wp_query->have_posts()) : $wp_query->the_post(); $sid = get_the_ID(); $SalesForceId = get_post_meta($sid, 'SalesForceId', true); $query = "SELECT Name, Phone, BillingCity, BillingState from Account WHERE Id = '" . $SalesForceId . "'"; $response = $mySforceConnection->query(($query)); foreach ($response->records as $record) { $Name = $record->{Name}; $Phone = $record->{Phone}; $BillingCity = $record->{BillingCity}; $BillingState = $record->{BillingState}; } echo $Name; echo $BillingCity; echo $BillingState; endwhile; ?>

$cnt1 = mysql_num_rows($rs1); is generating the error. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in <? session_start(); $userid = $_SESSION['sess_id']; $sql1 = "select t_username,t_password,id from twitter_user where userid='".$userid."'"; $rs1 = mysql_query($sql1); $cnt1 = mysql_num_rows($rs1); if($cnt1 > 0) {

Thank you I will try it. I couldn't really find that much info before even though it is so common.

Hi, I am trying to integrate my shopping cart with a payment gateway. When I test it, it works but here lies the problem. It says to use the Direct Post Method and when I use it on my form it directs to their payment URL and parses my variables and I get my response. How do I parse the variables to their site where the gateway is located and not leave my site? So that I just get a response on the same page.

Okay finally got it to work. Thanks for all of your help. Here is the corrected code. $reg_pass = $_POST['reg_pass']; $reg_email = $_POST['reg_email']; $query = " SELECT * FROM login WHERE reg_email='$reg_email' AND reg_pass='$reg_pass' "; $result = mysql_query($query) or die (mysql_error()); if (!$result) { echo mysql_error(); exit; } while($row = mysql_fetch_array($result) ) { echo $row['reg_firstname']; }

This is the output I am getting - SELECT * FROM login WHERE reg_email='' AND reg_pass='' 0 $reg_email = $_POST[$reg_email]; $reg_pass = $_POST[$reg_pass]; $query = " SELECT * FROM login WHERE reg_email='$reg_email' AND reg_pass='$reg_pass' "; $result = mysql_query($query); $num = mysql_num_rows($result); if (!$result) { echo "CRAP!"; } while ($row = mysql_fetch_array($result)) { echo $row['reg_firstname']; } print $query; $numrows = mysql_num_rows($result); print $numrows; ?> I looked at the database and all of the information is in there.

Not getting an errors at all. It just isn't printing the variable reg_firstname. I can see it in the database and everything is correct.

I successfully made a registration page that updates to a mysql database. My problem is my login verification page. I am trying to echo the user's name from the database and it isn't working. $reg_email = $_POST[$reg_email]; $reg_pass = $_POST[$reg_pass]; $query = " SELECT * FROM login WHERE reg_email='$reg_email' AND reg_pass='$reg_pass' "; $result = mysql_query($query); $num = mysql_num_rows($result); if (!$result) { echo "CRAP!"; } while ($row = mysql_fetch_array($result)) { echo $row['reg_firstname']; } Please help, I am sure I am doing something very simple wrong.