[Music Chart]

yeah, then you pull out:

 

bandid

average

name

totalcount

 

and away you go!

[Music Chart]

here is my top 10 rating query:

 

SELECT rate.bandid, count(rate.bandid) as totalcount, avg( rate.rating ) as average, users.name FROM rate INNER JOIN users on (users.userid = rate.bandid) WHERE users . type = 'b' GROUP BY rate.bandid having totalcount >= 10 ORDER BY average DESC, users.name ASC LIMIT 10

[IPOD]

Check this out:

 

http://macs.about.com/od/ipod/a/copy_from_ipod.htm

[Music Chart]

start off with 3 tables

 

Users:

------

userid

username

password

email

...

 

Profile:

userid

profile

website

photo

...

 

Rate:

rid

userid

rating

...

 

Take a look at my site: www.SyracuseBands.net you might get some other ideas too

 

Hope this gets you started in the right direction

[[SOLVED] php API's to read Microsoft Excel rows/columns]

Check out what I posted here: http://www.phpfreaks.com/forums/index.php/topic,133807.msg563168.html#msg563168

 

hope that gets you started.

[PHP Developers Salary]

yes I agree

[Sound Driver Help, YOU can help.]

Did you download or install something, then it didn't work?

[Sound Driver Help, YOU can help.]

Did they ever work? if so, you can go to the device in device manager and roll back the driver to the previous state.

 

Did you check your PC manufacurer's site (or motherboard)? They usually have the most current driver

[PHP Developers Salary]

don't get me wrong...I don't mind if the are here working and taking care of their family...just be a legal citizen and don't think that if you are a minority or alien that everyone else should conform to what you want and/or your culture.

 

Prime example...Did you guys see the email going around? ...about some school in CA flying the mexican flag over the American flag PLUS flying the American flag upside down! If you didn't get it I think I still have it, I can post pics if you want, or PM me your email and I'll just forward it to you. But anyways...that should not be tolerated.

[PHP Developers Salary]

No, sorry that had nothing to do with pay. I don't know if you get it in the news over there but we have been having some imigration problems lately. Like people just walking over and now suddenly they are "Americans". Thats all I was refering to

[boredom]

very nice, I like it a lot. Just a new small things:

 

- On your main nav (bubbles) on the hover I would make the text darker not lighter and I would make the red bullet a little brighter.

- maybe a little more padding on the body text and in the right hand boxes.

 

looks great though!

[PHP Developers Salary]

Why not? Everyone is doing it! All you have to do is say you are an American and your in

 

 

...ouch

[sorting by column]

SELECT * FROM gems ORDER BY carat ASC

[plz help me]

#1. you double posted.

#2. try google

#3. this is for HELP with a script that you already have...we will not find one for you.

[is it possible to use LAST_INSERT_ID () across queries]

oops, sorry, didn't catch that

[is it possible to use LAST_INSERT_ID () across queries]

just take the last_insert_id() after the first insert and apply that to $id (or something) then just use $id for the other 2 inserts

[uploading file to MYSQL with php]

Check out this tutorial. It might point you in the right direction.

 

http://www.php-mysql-tutorial.com/php-mysql-upload.php

[PHP Developers Salary]

I just started doing it full time a few months ago, but my projections for the first year (from the money I've already made) will be about $35K this year. As I've said in various other posts I usually charge a flat rate/project that comes out to about $40-$50/hr. The other point that I would like to make is that I DON'T work a full 40 hrs/week...which could be a good or bad thing...I think it's great!

[[SOLVED] ID count type]

try this:

<?php 

$userid = 1;

echo fill($userid,6);

function fill($val,$properlen){
$i=0;
$l=strlen($val);
$properlen = $properlen - $l;
$tmpstr=$val;
while ($i<$properlen)
{
	$tmpstr="0$tmpstr";
	++$i;
}
return $tmpstr;
}

?>

[Approximate Charges For a php programmer]

I replied to: http://www.phpfreaks.com/forums/index.php/topic,139197.msg590927.html

 

"I usually try to stay around $40-$50/hr (or more if I get done quicker)"

[Charges For PHP / MySQL programmer]

I usually try to stay around $40-$50/hr (or more if I get done quicker)

[SQL Injections]

$output = mysql_real_escape_string($input);

[Layered internet protocol stack]

Well with the application layer you have your gui and actual program, transport brings it down to binary, network puts it into packets, link sends it over the physical.

 

 

...I think I got that right, it's been a while since i've done this

[Layered internet protocol stack]

Do you have to show how your application works at each level of the OSI model? ...sorry not wuite sure what you are getting at, can you elaborate?

[wanting to use ajax to send newsletter]

i don't think that the wait state times out...I might be wrong but when I've tried a bad php code with ajax I let it go for a while and it never timed out.