Jump to content
Larry Ullman's Book Forums

short.fuse.5254

Members
  • Content Count

    11
  • Joined

  • Last visited

Community Reputation

0 Neutral

About short.fuse.5254

  • Rank
    Newbie
  1. I'm having issues with Page 214 -Chapter 7-... This is how the book showed the example turning out: This is how mine turned out: This example on page 215 is not working right either: I don't understand where I went wrong & why the examples aren't turning out like the author's on these. I downloaded the sql commands that go with the book & ran this on the sql tab in PhpMyAdmin: CREATE DATABASE banking CHARACTER SET utf8 COLLATE utf8_general_ci; USE banking; CREATE TABLE customers ( customer_id INT UNSIGNED NOT NULL AUTO_INCREMENT, first_name VARCHAR(20) N
  2. Your welcome @JohnD... It took me a while to figure out how to do this myself. I think I was on Google for an hour or two trying to find an article on how to do this.
  3. I think I've got this all sorted out now, so I figured I should post how I got everything done to help anyone else who has the same problem. First, I clicked the xampp control panel, & clicked the stop buttons next to Apache & MySQL. Next, I went to: http://downloads.mysql.com/general/timezone_2011n_posix.zip , & I downloaded the zip folder (It has all of the 15 tables files in it.). I extracted the folder, selected all of the 15 files in it, copied them, & pasted them in the folder C:\xampp\mysql\data\mysql. A window will come up asking you if you want to r
  4. Hi everyone, I just finished reading Chapter 6, & I'm stuck on Page 190 on the part Using Time Zones in MySQL... I'm not sure where to start. I checked out this page http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html, but I can't make too much sense out of it! I installed Xampp in C:. I found this folder with the Time Zone tables, but I have no idea what to do even after reading the time zone support page on the MySQL website...: C:\xampp\mysql\data\mysql It has all 15 of the time zone files, but I don't know what to do. I'm using Version 3.2.1 of Xampp, Ver
  5. Thank you Emilie! I appreciate all of the help! & I also voted your answer up for answering what I needed to know & the quick reply...
  6. Hi Emilie, I was just judging by the examples in the book & thought what I did was supposed to match the examples exactly. I was thinking that if the registration_date wasn't the same as the author's in the book, then I might run into problems later on in the book... So, do I need to edit the registration_date in phpMyAdmin to make the registration dates the same as the authors? I just thought I might run into issues if the registration dates didn't match the authors exactly. &, by the way, thanks for the quick reply & for explaining this!
  7. Hello everyone, This is what I'm having trouble with in Chapter 5 on the part 'Sorting Query Results' on page 146: Show all of the non-Simpson users by date registered C: SELECT * FROM users WHERE last_name != 'Simpson' ORDER BY registration_date DESC; This is how it turned out when I followed the example: I don't understand why it's not turning out like the example in the book & why the registration date turned out like this! I followed the authors examples & downloaded the scripts that go along with the book. I copied & pasted this -from the books scri
  8. Thank you very much Emilie. I finally figured this out sometime last night after being about ready to pull my hair out! You described it best tho & added more about the $_POST array so I voted your answer up!
  9. This is the script that I'm having trouble with: <?php # Script 3.6 - calc3_2.php // This sets the page's title: $page_title = 'Trip Cost Calculator'; // This includes the header: include ('includes/header.html'); // Check for form submission: if ($_SERVER['REQUEST_METHOD'] == 'POST') { // Minimal form validation... Checks if distance, gallon_price, & efficiency are set & numeric... if (isset($_POST['distance'], $_POST['gallon_price'], $_POST['efficiency']) && is_numeric($_POST['distance']) && is_numeric($_POST['gallon_price']) && is_numeric($_POS
×
×
  • Create New...