gple

$roster=mysql_query("select *, (hits/ab) as avg from softball_players, softball_rosters, softball_ostats where softball_ostats.roster_id=softball_rosters.id and softball_players.id=softball_rosters.player_id and softball_rosters.year='$year' order by avg desc"); $roster_num=mysql_numrows($roster); How do I get avg to appear in three decimal places? Not two as this is outputting

$time="20:00:00"; how do I put this variable as 8:00?

Is there anyway to write up a code that will show me all of the open MYSQL connections on my website.

Does anyone know a quick way to move a file from one directory to another. IE directory1 --> file1 directory2 --> empty How do I move file1 from directory1 to directory2

sorry didnt realize how I wrote my original code.

$query=mysql_query("select * from gaf order by '".$ordering."where test=0'"); Is this correct coding?

<?php if (mysql_query("insert into test values (' ', '$day', '$date', '$location', '$time', '$division', '$team1',' ','$team2,' ','$comments')")) {echo "Success";} else {echo "NO";} ?> I keep getting NO. All the variables are correct.

$link=$_SERVER['PHP_SELF']; when I output this, I get something like this: ///////////////////////////////////////Test/index.php any idea why I would get this?

I like the way it works, but then I want to store the order in which they appear into a table so that on the front end, the viewer can see what I order I put it in.

Is there anyway I could make a list and move them up and down in a list and then have the order number change as such.

I have a list of documents in which the name gets outputted onto a website. I created another column in the table to distinguish which order they should appear in. so I have 10 records and each of them has a different number next to it (1-10) and this will be the order that they appear in. How can I make sure that the user does not put the same number for two different records?

that works. thanks

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order='9' where id='45'' at line 1

$id and $order both output what I passed them. why doesnt the update work? $id=$_POST['id'.$i]; $order=$_POST['order'.$i]; mysql_query("UPDATE type_size set order='".$order."' where id='".$id."'");

This does not work. It adds pluses where the spaces are. Any other way I have coded it, I get % where spaces are. I dont need those.

I can but I would like to have the spaces.

Here is my code <td><img src=\"../prod_images/" . $image . "\" height=90><br>".$image."</td> $image=WEB 100% Cashmere Sweater 001resizedcashmere.jpg Here is my output http://mensfashiondirect.com/prod_images/WEB%20100%%20Cashmere%20Sweater%20001resizedcashmere.jpg and the image is not showing up properly because of the '%' character in. any way around this.

Warning: main(): URL file-access is disabled in the server configuration anybody know why this would happen.

no i know thats the problem but is there anyway to write up something to see where those connections are still open?

i think its too many SQL connections open

I know why I am getting this message. Is there any code I can write up to find how many connections are open and on what pages they are open.

has anyone every used the paypal payments pro with an existing shopping cart before?\

Something that looks more professional. I tried using the paypal payments pro but nothing works properly. is there something else I can use. Any ideas?

I have created a shopping cart on my website but I want to know what is the best and most secure way to go through the checkout and process the payment. Is there a service that does all this. I wrote the code for the shopping cart, I just want to be able to click on checkout and have some service take care of this. Is there anything that I can use.

if i have a variable 'time', and I want to create a new variable which is an hour and fifteen minutes after the 'time' variable. how do i write that?