Digital Workshop

Hi all,

I am using a Post Web Data action with a mySQL DB.
When I click on the button that has the action, nothing happens.
I traced this using Wireshark.

Usernames and passwords are ok.
I send a request to the server with no problem.
It seems like the server returns the string "articletitle" but this is the actual field name for my database and also my string and Opus variable.
So the server does not return the content of the field but just the field name.
I am really stuck here, any ideas?

Thanks
Dennis

See Wireshark output below, and my select.php below that.

POST /select.php HTTP/1.1

Accept: Accept: */*

Content-Type: application/x-www-form-urlencoded

User-Agent: Opus Publication

Host: [the host I am using]

Content-Length: 0

Cache-Control: no-cache



HTTP/1.1 200 OK

Date: Sat, 02 Nov 2013 19:49:50 GMT

Server: Apache/2.4.6 (Unix)

X-Powered-By: PHP/5.3.27

Cache-Control: max-age=86400

Expires: Sun, 03 Nov 2013 19:49:50 GMT

Transfer-Encoding: chunked

Content-Type: text/html

Connection: close



e

&articletitle=

0
=============================
==============================
Select.php:

<?php


$DBhost = "xxxx";
$DBuser = "xxxx";
$DBpass = "xxxx";
$DBName = "xxxx";

$connect = mysql_connect($DBhost,$DBuser,$DBpass);
$db = mysql_select_db($DBName,$connect);
$query = "SELECT * FROM cl40-dcms";
$result = mysql_query($query, $connect);

$row = mysql_fetch_array($result);

$data = "&articletitle=".$row['articletitle'];

echo $data



?>

Dennis,

I am surprised no-one has given some ideas here. Maybe it is just a busy time of year.

I have not used POST/GET, but in looking up some of these methods... I could raise one question.

Are you sure that your chosen SQL db allows hyphenated table names? And if so, should you put quote marks around the table name in the query.

One way to test this is to run you post/get on a table name that is not hyphenated, and see if that makes any difference.

Other than that, we'll have to wait until someone with PHP expertise chimes-in.

You say it's only showing the titles - I think that's due to this:
$data = "&articletitle=".$row['articletitle'];

you need to add more to the string e.g ... $data = "&articletitle=".$row['articletitle'].'&name='.$row['name'];

http://us1.php.net/mysql_fetch_array