[calixtoMember]

I am submitting to a pod page the following

PHP

<?php $nomcomplet = $_POST['nomcomplet']; $message = $_POST['txtzone']; $slug = $_POST['slug']; $decede= $_POST['decede']; $api = new PodAPI(); // all of the values to save and options to use $params = array('datatype' => 'condoleances', 'columns' => array('name' => '$nomcomplet', 'description' => '$message', 'avisid' => '$decede')); $params = pods_sanitize($params); // create the item $condoleances_id = $api->save_pod_item($params) ?>

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

<?php $nomcomplet = $_POST['nomcomplet']; $message = $_POST['txtzone']; $slug = $_POST['slug']; $decede= $_POST['decede'];   $api = new PodAPI(); // all of the values to save and options to use $params = array('datatype' => 'condoleances',               'columns' => array('name' => '$nomcomplet',                                  'description' => '$message',                                  'avisid' => '$decede')); $params = pods_sanitize($params); // create the item $condoleances_id = $api->save_pod_item($params)   ?>

SQL_CALC_FOUND_ROWS DISTINCT

PHP

t

1

t

.

PHP

name

1

name

,

PHP

t

1

t

.

PHP

description

1	description

FROM

PHP

SCMS_pod

1

SCMS_pod

AS

PHP

p

1

p

INNER JOIN

PHP

SCMS_pod_tbl_condoleances

1	SCMS_pod_tbl_condoleances

AS

PHP

t

1

t

ON

PHP

t

1

t

.

PHP

id

1

id

=

PHP

p

1

p

.

PHP

tbl_row_id

1	tbl_row_id

LEFT JOIN

PHP

SCMS_pod_rel

1	SCMS_pod_rel

AS

PHP

rel_avisid

1	rel_avisid

ON

PHP

rel_avisid

1	rel_avisid

.

PHP

field_id

1

field_id

= 22 AND

PHP

rel_avisid

1	rel_avisid

.

PHP

pod_id

1

pod_id

=

PHP

p

1

p

.id LEFT JOIN

PHP

SCMS_pod_tbl_avis

1	SCMS_pod_tbl_avis

AS

PHP

avisid

1

avisid

ON

PHP

avisid

1

avisid

.

PHP

id

1

id

=

PHP

rel_avisid

1	rel_avisid

.

PHP

tbl_row_id

1	tbl_row_id

WHERE

PHP

p

1

p

.

PHP

datatype

1

datatype

= 4 AND (

PHP

avisid

1

avisid

.

PHP

id

1

id

= ) ORDER BY

PHP

t

1

t

.

PHP

id

1

id

DESC LIMIT 0,15; Response: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) ORDER BY

PHP

t

1

t

.

PHP

id

1

id

DESC LIMIT 0,15′ at line 13

What am I doing wrong ?
I would like the user redirected to the previous page once the information is submitted, that is why i post the $slug.

The pod I am saving to have the following structure:
name (txt) *
description (desc)
avisid (pick avis)

Thanks !

[chris.pilkoMember]

You edited your code, but did your SQL error change?

[sc0ttkclarkKeymaster Post count: 803]

He fixed it, it was a pod page conflict somewhere that was running code elsewhere. There was a findRecords running somewhere that wasn’t populating avisid.id which threw the MySQL error above.

[calixtoMember]

Thanks Chris and Scott. I am in love with PODS now ! It is truly a magnificent piece of work !

[Author]

Posts