ok great i think

what does 'so read on SQL' mean?

If you're interested in doing more of this stuff I would highly recommend picking up a book on PHP/MySQL web development. Once you learn all the basics books stop being that useful but starting out having a big old tome that actually explicitly covers all the basic stuff is super helpful. Hell I learned C from "C for dummies"!

he means go read about SQL

im kinda in a weird spot right now. i have a handful of things i want to learn/do but dont have time for any of them really, let alone all of them. so i just try to figure out the coding stuff only as much as i need (which isnt much at all).

i want you all to know, i just figured out and wrote my first if else line.
i mean, i used them in the past, but it was cut and paste stuff
this one was cut and paste too, but i figured out what i needed to do and figured the if else was the solution and then was able to put all the right stuff in the right places. shipping info from a radio button to another page and had to create a result depending on the result of the radio selection.
i dont even know if im describing it right, but im excited about it

chips, im reading up on this now.
given this code:
[php]
// Get a specific result
$query = "SELECT * FROM table WHERE name <> ' ' ";


$result = mysql_query($query) or die(mysql_error());

// Print out the contents of each row
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "['".$row['name']."',".$row['number'].",".$row['number2']."],";
}[/php]


and assume i have multiple names and i want to have a name and a percentage for each name as we talked about.
so i do the query using select and the sum as you said. does that do it for all names or just one name?
like will the array become
name %
name %
name %

or just
name %

(the code above says number and number 2, i think thats wrong but im not at that point yet)

looks like the code below is going to answer my question?[php]
<?php
// Make a MySQL Connection

$query = "SELECT type, SUM(price) FROM products GROUP BY type";

$result = mysql_query($query) or die(mysql_error());

// Print out result
while($row = mysql_fetch_array($result)){
echo "Total ". $row['type']. " = $". $row['SUM(price)'];
echo "<br />";
}
?>
[/php]

SELECT type, SUM(price) as sum_price FROM products GROUP BY type

then in PHP it can be $row['sum_price']

which is easier to manage

easier to manage than what?

i did it. its done
very crude still, but the basis is done
will announce in a new thread
im excited

I wonder if C for Dummies part 2 ever came out. I really wanted to read it.

I worked with a guy who wrote a "for Dummies" books. He was ungodly smart.

is python worth learning?

yes

Do you know any other languages? Python is a nice one to start out with.

i know a little php. very little. mostly i just look up code snippets and paste them in

Python is awesome. Less "manly" than some other languages, but the code is so intuitive and so readable.

Extremely worth it then

I can't write code without { }

((lambda (arg) (display arg)) "lol @ u")

yeah I can't write lisp

I've even tried

I think when I become enlightened I'll probably know lisp

I can write C code in at least 5 languages though

You can't track hard posts in a soft programming language.

INFINITE HEARTS

oh god, my gas company (vectren) has a button I can press to get my password in plain text when logged in. Time to use a password I won't use for anything else, ever!

What can I do with it? Anything good or am I only going to gain familiarity with coding so I can pick up better languages easier?

What do you want to do with it?