[[SOLVED] MYSQL not reading - and + plus numbers correctly]

My own silly fault, setting the field to an integer worked.

 

Thanks.

[[SOLVED] MYSQL not reading - and + plus numbers correctly]

Hi.

 

I have a little league table integrated at www.afc-chat.co.uk

 

It doesnt seem to the rows in the right order.

 

MySQL is

SELECT * FROM leaguetable ORDER BY points DESC, gd DESC

 

As you will see i want the data ordered by points then by goal difference (gd). I have tried both ASC and DESC and they work when the numbers invert by being either positive or negative, but changing that manually obviously isnt the right way to do things.

 

The database is entered into the database by a single field like: "+10" or "-4". Maybe its the input i need to change?

 

Any help greatly appreciated.

 

JM.

 

 

[How do i get checkboxes to email?]

Is there a cleaner method without all the "if" and "else" statements?

I currently have 6 options but might be expanding them.

Thanks for replies so far.

[How do i get checkboxes to email?]

Hi there.

How do i get checkbox values sent to my email account?

I have other variables that send fine like name, email etc and the mail () function works fine.

I would like to get checkboxes working though.

I have 6 activities such as quad biking, off road driving etc and how can i send these names if selected to my email account?

Thanks for your time.

[Getting checkboxes ticked to email]

Thanks for the reply Ken.

I put in the code as you said but its still not working

i have :

[code]mail($recipient, $subject, "\n Group Number: $group \n\n Activities: $actos \n\n Message:$msg ", $headers);[/code] for sending mail

and

[code] if (isset($_POST['foo'])) $actos = implode("\n",$_POST['foo'])."\n";[/code]

for getting the variables.

Thanks for your help

[Getting checkboxes ticked to email]

Hi i want the checkboxes selected to be sent to my mail account. The email part works fine but i just cant get these checkboxes to be included.



[code]<input type="checkbox" name="foo[]" class="no"  id="fishing" value="Fishing"  "/>

<input class="no" name="foo[]" type="checkbox" id="quadBiking" value="Quad Biking" />
    

<input class="no" name="foo[]" type="checkbox" id="gameShooting" value="Game Shooting/>[/code]




[code]$foo = $_POST['foo'];
if (count($foo) > 0) {
    
     for ($i=0;$i<count($foo);$i++) {

            $actos .= "$foo[$i]\n";

     }

}

[/code]



Any help greatly appreciated.

[Adding in Bold, h1 , h2 header buttons]

Hi,

how hard would it be add in 3 buttons above a form i have which add in tags such as <h1></h1><strong></strong><em></em>

I dont want a full wysiwyg editor just these 3 commands.

Is it possible for a 3/10 phper?

Thx.

[Date problem , ORDER BY]

Many Thanks.

[Date problem , ORDER BY]

Hi there, i am trying to display some news with the most recent date at the top

 

heres my SQL:

 

$sql = mysql_query("SELECT *,
   date_format(article_date, '%D %M, %Y') as article_date 
   FROM news_system
   ORDER BY article_date 
   ASC LIMIT 5");

 

It seems to mess up and have a random order of things.

 

Thx.