Page 7 of 7

Posted: Sat 22 Feb 2014 11:48 am
by Riksen
Both lines 302 and 303 are empty in the script ....

Posted: Sat 22 Feb 2014 4:09 pm
by 22GCT_Gross
your pilot_photos table seems empty.
What you posted is the table structure, could you post the table data view?

Adding data:
if you want to add data to a MySql table you have one of these options:
1. manually insert data if the browser allows you.
2. import data from a csv or sql file
3. execute a sql script

By phpmyadmin choose the database and the pilot_photos table and:
1. select the Insert option, fill the "Value" for both fields (Pilot_Name and Photo_Name) and click on Execute;
2. select Import option, choose the file to load you must have prepared before;
3. select SQL option, type:

Code: Select all

INSERT INTO `pilot_photos`(`Pilot_Name`,`Photo_Name`)VALUES ('JAGER_Knoke','JAGER_Knoke.jpg');
then click on execute
Note the difference between ` (qualifying database objects) and ' (qualifying strings)

Posted: Sat 22 Feb 2014 5:33 pm
by Riksen
THANK YOU GROSS!!!

THANK YOU THANK YOU THANK YOU!!!

I know it was such a noob question but i figured it out... It was a damn typo!

instead of .jpg i had jgp.. lol

THANK YOU for ur help friend.. It finally works!

Posted: Sun 23 Feb 2014 8:38 pm
by CC_Gosdatura
IV/JG7_4Shades wrote:Don't use phpMyAdmin, it is horrible. :twisted:

Try to get a free version of Navicat or SQLyog, these are much easier to use.

Cheers,
4S
I'm using HeidiSQL, free and good enougth IMO.

Salut!