[PHP-DB] Getting first character?

2001-11-12 Thread Matt C 

I have numbers stored in a text field in my database:

ie.

321
322
401
402
403
404
405
406

I think you get the picture ;) Anyway I need to know how to get just the 
first character of each stored number and store it in the variable $season.

Any help much appreciated, thanks in advance,

Matt

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Check Boxes!

2001-10-19 Thread Matt C 

I still can't get my damn code working :( :( :(

All I want to do is have any records with a checked check box given the 
value of 1 in the AuthStatus row.

Can anyone help me please?

-


JobID;

  for ($i = 0; $i <= $Max_JobID; $i++) {
if($HTTP_POST_VARS["chkAuthStatus_$i"] = 'on') {
$JobID = $i;
}

if($JobID){

$sql = "UPDATE vacancies SET AuthStatus='1' WHERE (JobID = '$JobID')";
mysql_query($sql,$dbconnect);

}


  }
}

?>

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Check Boxes/UPDATE

2001-10-03 Thread Matt C 

I am sorry but I still really don't get it :(

How do I do the array thing?

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Check Boxes/UPDATE

2001-10-02 Thread Matt C 

I have a page of jobs with AuthStatus set to 0. Basically I want to list 
each job title with a checkbox next to it. This I have done.

What I really don't understand is how do I make it so that the rows in my 
table for all the different records when ticked are updated to 1?

Please help.

Matt

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Searching/keywords

2001-09-20 Thread Matt C 

I have summaries of episodes stored in a database. How on earth do I go 
about highlighting keywords? I mean I have done a search and it gives a list 
of urls:

episodes.php?id=4&highlight=max

But how do I get it to go through all the words and highlight "max" or 
whatever keyword it is??

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] I am really stuck

2001-08-23 Thread Matt C 

I am extremely stuck with trying to do two things.

1) I would like to pull all entries out of a table that have dates that 
haven't occured yet. Basically forget anything before the current day. How 
do I do that?

2) I enter news into a table and would like to display a summary page. 
Basically it has a list of headlines under the date they were added.

Monday 10th August
*Item 1
*Item 2

Tuesday 11th August
*Item 1

etc

How do I do that?

Any help much appreciated,

Thanks, Matt

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Please help!

2001-08-22 Thread Matt C 

Thats my code!

What I want to be able to do is have it so instead of one column there are 
two columns of pictures:


pic1  | pic2
pic3  | pic4

etc..


How can I do this?

Thanks in advance!




http://www.charmed-guide.com/pictures/$row[2].jpg\"; 
target=_blank>\n");
printf("http://www.charmed-guide.com/pictures/$row[2]_th.jpg\"; 
border=0>\n");
printf("\n");

$counter++;
}

}
?>

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]