[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 _

[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') {

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: [E

[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

[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?? __

[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

[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("htt