Tagged questions

1000 results found

What is best practice for data manipulation like concatenation? June 05, 2016

Just wondering what is considered best practice for this sort of data manipulation? e.g If I am writing a script in PHP, am I better off to manipulate the data all in the database using SQL and bring

7

views

0

votes

1

answers

Why do different Databases use different keyword syntax?June 05, 2016

I'm just curious why different Databases like MySQL and MS SQL Server use different syntax for keywords. Wouldn't it be simpler and easier to use a unified language syntax? I bet you it's frustratin

7

views

0

votes

3

answers

SQL RAND() ErrorJune 05, 2016

I could not open index.php due to this error. PDOException: SQLSTATE[HY000]: General error: 1 no such function: RAND in /home/treehouse/workspace/inc/functions.php:25 Stack trace: #0 /home/treehouse/w

18

views

0

votes

0

answers

Why this is wrong???June 05, 2016

I got bummer with this sql line: INSERT INTO companies (name, city) VALUES (Treehouse, Portland) why???? Chris Ramacciotti

23

views

0

votes

1

answers

Why do we use quotes for the Date datatype in SQL?June 05, 2016

I am curious about the Date datatype in and why it needs quotes in SQL. If enter a date where year month and day are separated with a hyphen I guess the entry could be read as one single block of info

11

views

0

votes

1

answers

Teacher's NotesJune 05, 2016

Hi. I've noticed that the HAVING link is the same as the GROUP BY link; click on HAVING takes you to the GROUP BY page.

8

views

0

votes

1

answers

What does it mean by "return the pagination value"June 05, 2016

Am I supposed to use a literal return? Where? index.php <?php include "pagination.php"; /* add function here */ function pagination ($total_pages, $current_page, $section, $search){ $pag

14

views

0

votes

1

answers

SQLite to PHPMyAdminJune 05, 2016

Does anybody know what steps need to be taken to move this to PHPMyAdmin rather than SQLite?

14

views

0

votes

1

answers

Typo in Teacher’s NotesJune 05, 2016

This isn’t a question, but I noticed there’s a typo in the teacher’s notes: "Mode Analtyics” should be “Mode Analytics"

12

views

0

votes

0

answers