School Closings Table with MySQL and PHP

  • (2 Pages)
  • +
  • 1
  • 2

18 Replies - 312 Views - Last Post: 19 February 2019 - 01:38 AM Rate Topic: -----

#16 benanamen   User is offline

  • D.I.C Head

Reputation: 34
  • View blog
  • Posts: 234
  • Joined: 28-March 15

Re: School Closings Table with MySQL and PHP

Posted 18 February 2019 - 10:45 PM

And you are running ONLY the code I gave you? Somewhere you have something asking for a table named school_business.

Run the code I gave you with SELECT * all by it self with no other code in the page.

This post has been edited by benanamen: 18 February 2019 - 11:01 PM

Was This Post Helpful? 0
  • +
  • -

#17 awnweather   User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 31
  • Joined: 08-August 18

Re: School Closings Table with MySQL and PHP

Posted 18 February 2019 - 10:52 PM

View Postbenanamen, on 18 February 2019 - 10:45 PM, said:

And you are running ONLY the code I gave you? Somewhere you have something asking for a table named school_business.

Run the code I gave you with SELECT * all by it self with no other code in the page.


Ok. I hope I did the thing you wanted me to do correctly. I took all of the items out of the select leaving just $sql = "SELECT *";

It then gave me this error:

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1096 No tables used in /srv/disk7/2753050/www/awn-weather.atwebpages.com/closings_list.php:25 Stack trace: #0 /srv/disk7/2753050/www/awn-weather.atwebpages.com/closings_list.php(25): PDO->prepare('SELECT *') #1 {main} thrown in /srv/disk7/2753050/www/awn-weather.atwebpages.com/closings_list.php on line 25

This post has been edited by awnweather: 18 February 2019 - 10:53 PM

Was This Post Helpful? 0
  • +
  • -

#18 benanamen   User is offline

  • D.I.C Head

Reputation: 34
  • View blog
  • Posts: 234
  • Joined: 28-March 15

Re: School Closings Table with MySQL and PHP

Posted 18 February 2019 - 10:58 PM

No. SELECT * FROM YOURtablenameHERE

From what you have posted it would be SELECT * FROM valid_closings

This post has been edited by benanamen: 18 February 2019 - 11:01 PM

Was This Post Helpful? 0
  • +
  • -

#19 andrewsw   User is online

  • Stealth IT
  • member icon

Reputation: 6745
  • View blog
  • Posts: 27,775
  • Joined: 12-December 12

Re: School Closings Table with MySQL and PHP

Posted 19 February 2019 - 01:38 AM

awnweather It is apparent that you need to spend time studying basic SQL statements, you need to understand what you are writing in order to make progress.
Was This Post Helpful? 1
  • +
  • -

  • (2 Pages)
  • +
  • 1
  • 2