joomla–developer.com

Posts Tagged ‘Mysql’

I have a custom table in Joomla that I know how to enter data in. My problem is I have no idea how to list all records in the applicable table!
I’ve tried tutorials but something always goes wrong when trying to display data!
Details:
database name: firstdatabase
password: password
host: localhost
table: jos_customform_1
Field Type Collation Extra
cf_id int(11) auto_increment
recordtime text utf8_general_ci
ipaddress text utf8_general_ci
sku longtext utf8_general_ci
Price longtext utf8_general_ci
description longtext utf8_general_ci
I want to be able to list all data the table on a webpage!
Can one of you experts help me here….I’m a techie but not a developer!
Thanks

I’m a tech, not a programmer! Discovering that I’m a pretty useless programmer actually! However, I’m toying with PHP/MySQL and can’t understand why I cant get a simple query to work! I’m trying to display data from a form I made in Joomla using FacileForms.
I put:

I keep getting the following error:
Parse error: syntax error, unexpected ‘`’ in C:\wamp\www\testdb\test1.php on line 13
Can some please spell it out for me! I saved the above script in test1.php and pull up the file in my browser. Just how wrong am I?!
Please enlighten me!
Thanks