grid not displaying data

[aid123]

Hi, great tool, thank you.

Please help.
I'm trying to just display one column of data (the first), not all the columns.
When I comment out all addColumn lines except the first column (using your demo), then no data is displayed in the grid.

It appears only if I include the columns 'country' or 'continent' does the grid show results.
If I exclude both those columns, the grid returns no rows, even though the other columns are there.

Thanks

[NicksMacLife]

you need to change the line with

This is in the loaddata.php file

$result = $mysqli->query('SELECT *, date_format(lastvisit, "%d/%m/%Y") as lastvisit FROM '.$mydb_tablename );

to

$result = $mysqli->query('SELECT * FROM '.$mydb_tablename );

Let me know if that works

[aid123]

Hi, thanks but it still doesn't work.

-------- Original message --------

From: nickmacwiz

Date:27/10/2015 1:11 AM (GMT+02:00)

To: jybeaujean/editablegrid-mysql-example

Cc: aid123

Subject: Re: [editablegrid-mysql-example] grid not displaying data (#26)

you need to change the line with
$result = $mysqli->query('SELECT *, date_format(lastvisit, "%d/%m/%Y") as lastvisit FROM '.$mydb_tablename );

to

$result = $mysqli->query('SELECT * FROM '.$mydb_tablename );

Let me know if that works

---

Reply to this email directly or view it on GitHub:
#26 (comment)

[NicksMacLife]

Are you trying to pull the data from the first column of the demo database or another database?

[NicksMacLife]

If you are still using the demo database. attach your loaddata.php file and if not please upload your loaddata.php file and a screen shot of your sql table from myphpadmin.

[aid123]

The same demo database. Even having just the first few columns doesn't return results. Only if country or continent are included does the grid return data.

Many thanks

-------- Original message --------

From: nickmacwiz

Date:27/10/2015 5:09 PM (GMT+02:00)

To: jybeaujean/editablegrid-mysql-example

Cc: aid123

Subject: Re: [editablegrid-mysql-example] grid not displaying data (#26)

Are you trying to pull the data from the first column of the demo database or another database?

---

Reply to this email directly or view it on GitHub:
#26 (comment)

[NicksMacLife]

I just tried taking the oritional project and removing those 2 and it works fine. Please upload you loaddata.php file so i can take a look

[aid123]

Hi, I see it does work in IE, but not in chrome. I've been using chrome as my preferred browser, hence the problem.

It only works in chrome when all columns including country and continent are included.

Are you able to fix this?

Thanks

-------- Original message --------

From: nickmacwiz

Date:27/10/2015 5:22 PM (GMT+02:00)

To: jybeaujean/editablegrid-mysql-example

Cc: aid123

Subject: Re: [editablegrid-mysql-example] grid not displaying data (#26)

I just tried taking the oritional project and removing those 2 and it works fine. Please upload you loaddata.php file so i can take a look

---

Reply to this email directly or view it on GitHub:
#26 (comment)

[NicksMacLife]

I have only been using Chrome and Firefox sometimes.

Sent from my iPhone 6 Plus

On Oct 27, 2015, at 11:28 AM, aid123 [email protected] wrote:

Hi, I see it does work in IE, but not in chrome. I've been using chrome as my preferred browser, hence the problem.

It only works in chrome when all columns including country and continent are included.

Are you able to fix this?

Thanks

-------- Original message --------

From: nickmacwiz

Date:27/10/2015 5:22 PM (GMT+02:00)

To: jybeaujean/editablegrid-mysql-example

Cc: aid123

Subject: Re: [editablegrid-mysql-example] grid not displaying data (#26)

I just tried taking the oritional project and removing those 2 and it works fine. Please upload you loaddata.php file so i can take a look

---

Reply to this email directly or view it on GitHub:
#26 (comment)
—
Reply to this email directly or view it on GitHub.

[NicksMacLife]

Do you have the ability to check another computer with chrome.

Sent from my iPhone 6 Plus

On Oct 27, 2015, at 11:28 AM, aid123 [email protected] wrote:

Hi, I see it does work in IE, but not in chrome. I've been using chrome as my preferred browser, hence the problem.

It only works in chrome when all columns including country and continent are included.

Are you able to fix this?

Thanks

-------- Original message --------

From: nickmacwiz

Date:27/10/2015 5:22 PM (GMT+02:00)

To: jybeaujean/editablegrid-mysql-example

Cc: aid123

Subject: Re: [editablegrid-mysql-example] grid not displaying data (#26)

I just tried taking the oritional project and removing those 2 and it works fine. Please upload you loaddata.php file so i can take a look

---

Reply to this email directly or view it on GitHub:
#26 (comment)
—
Reply to this email directly or view it on GitHub.

[NicksMacLife]

what verison of php are you using on your server?

[aid123]

php 5.5.12using chrome Version 46.0.2490.80 mon windows 8mySql 5.6.17

Date: Tue, 27 Oct 2015 12:21:53 -0700
From: [email protected]
To: [email protected]
CC: [email protected]
Subject: Re: [editablegrid-mysql-example] grid not displaying data (#26)

what verison of php are you using on your server?

—
Reply to this email directly or view it on GitHub.

[NicksMacLife]

same setup on my end except i am using a different mysql but that wouldnt make a difference.

if you can upload or copy paste your loaddata.php file
so i can see whats going on.

also try uninstalling and reinstalling chrome.

[aid123]

I finally figured it out.
I must have done a search using a filter in the past, and the filter didn't clear, even though the filter box was empty and I was refreshing using shift+F5 each time.
I've had to add the below into the initialiseGrid function.grid.currentFilter = "";
Date: Tue, 27 Oct 2015 12:35:16 -0700
From: [email protected]
To: [email protected]
CC: [email protected]
Subject: Re: [editablegrid-mysql-example] grid not displaying data (#26)

same setup on my end except i am using a different mysql but that wouldnt make a difference.

if you can upload or copy paste your loaddata.php file

so i can see whats going on.

also try uninstalling and reinstalling chrome.

—
Reply to this email directly or view it on GitHub.