Bonjour,
j'utilise chronoforms et je veux mettre les resultats dans un article
je n'arrive pas a utiliser chronoconectivy je ne connais pas le PHP
pouvez vous me dire ou ecrire les lignes PHP dans le logiciel et quoi ecrire
ma table s'appelle _chronoforms_data_conducteur.
je veux afficher dans un tableau dans un article qu'il reprendra de ma table
nom
prenom
mail
Hi nefertiti,
This looks like a ChronoForms question, not a ChronoConnectivity one. You can add data from a database table to your form by using the DB Record Loader in CFv4.
Bob
Hello,
I have my data in my table but I want to ChronoForms ness appear in an article.
I arrive with chronoconectivity see id but I do not know how to bring up the name, surname and email.
j'ai un message d'erreur
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 `cf_id` LIMIT 0,30' at line 1 SQL=SELECT * FROM `c9yqu_chronoforms_data_conducteur1` WHERE $sql = "SELECT * FROM `c9yqu_chronoforms_data_conducteur1` ORDER BY `c9yqu_chronoforms_data_conducteur1`.`Nom` ASC LIMIT 0, 30 "; ORDER BY `cf_id` LIMIT 0,30
what I should put myself out for his name fields, first name, and email
removed by an oder?
Hi nefertiti,
I'm sorry, I don't understand your question.
Bob
I made a sql table with ChronoForms c9yqu_chronoforms_data_conducteur1 with as given name, surname, email. I want to be displayed in a given section.
with chronoconectivity I can display it but I do not know how I get an error with chronoconectivity
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 `cf_id` LIMIT 0,30' at line 1 SQL=SELECT * FROM `c9yqu_chronoforms_data_conducteur1` WHERE $sql = "SELECT * FROM `c9yqu_chronoforms_data_conducteur1` ORDER BY `c9yqu_chronoforms_data_conducteur1`.`Nom` ASC LIMIT 0, 30 "; ORDER BY `cf_id` LIMIT 0,30
What I put in "where sql"
Hi nefertiti,
We are going found in circles.
The Error is that there are two ORDER BY clauses: ORDER BY `c9yqu_chronoforms_data_conducteur1`.`Nom` ASC and ORDER BY `cf_id` The first one sorts by Nom the second by cf_id.
I don't know where they come from but having two breaks the MySQL query.
Bob