[PHP] Please help me with a query

2006-06-13 Thread Jesús Alain Rodríguez Santos
First of all I'm sorry for my english I don't know speak very well, I will try to explain it, I hope you understain what I need. I have two tables: centers and peoples, in table centers I have the centers values and in table peoples I have the peoples values and in table columns center the id

[PHP] arrays

2006-06-09 Thread Jesús Alain Rodríguez Santos
if I have two arrays, example: $a = array (one, two, three, four, two); $b = array (seven, one, three, six, five); How can I get in another variable a new array with the same elements into $a and $b. -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos

[PHP] Hosting php help

2006-04-26 Thread Jesús Alain Rodríguez Santos
Please I need a free hosting with php and mysql, and sendmail active. If you know any site, please send to me the address. -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio.

[PHP] URL problem

2006-02-17 Thread Jesús Alain Rodríguez Santos
I have a following directory: - folder (site) index.php - folder (example) index.php the url to this directory will be: http://www.example.com/site/index.php but I need redirect with: header() function to the index.php inside the folder example without the url change I mean, I want to

[PHP] HAPPY NEW YEAR!!

2005-12-30 Thread Jesús Alain Rodríguez Santos
Happy New Year for all. I weish you the best in this new 2006. Regards. Alain -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio.

[PHP] I want to know if some link is online

2005-10-09 Thread Jesús Alain Rodríguez Santos
I would like to know if a web is online, a have this code: enlace.php ? $vivo = verde.gif; $muerto = rojo.gif; $enlinea = fopen($enlace, r); if (!$enlinea){ header(Location: $muerto); } else { header(Location:

[PHP] mysql query

2005-09-14 Thread Jesús Alain Rodríguez Santos
I have a table colum in mysql with two fields: day and month. I would like to know if it's possible to make a query where I can determine if exist days before to a selected day, for example: if I have in my table: day 19 - month 05, I wish to know if there are previous days inserted at the 19, the

[PHP] edit $variable online?

2005-08-16 Thread Jesús Alain Rodríguez Santos
Hi, I have in a php page one ($variable = 85), I woud like to change the value from this variable online, without any data base, for example ussing a form where I can put the new value and it change the value of the $variable. -- Este mensaje ha sido analizado por MailScanner en busca de virus

[PHP] Insert one or many chekbox values in a db mysql

2005-08-09 Thread Jesús Alain Rodríguez Santos
Hi, I have 5 chekboxes in a page, I would like insert the values of all chekboxes checked in a mysql db. -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. -- PHP General Mailing List (http://www.php.net/) To

[PHP] help with a bucle

2005-08-02 Thread Jesús Alain Rodríguez Santos
Hi, i have in my mysql db one table columm, some think like this: dayreporte ------ 145 256 478 689 790 etc... How can i print all the value from 'reporte' columm depending the 'day' columm, and if there is not exist a day print 0 value, for

[PHP] help with print value

2005-07-30 Thread Jesús Alain Rodríguez Santos
Sorry for my english, i'm cuban, it's dificult for me explain that in english but I'll try: I have a table columns: month, day and value ||month||day||value 7 156 7 334 8 450 9 578 . . . . . . etc... I need to get the

[PHP] help with ORDER BY query

2005-07-29 Thread Jesús Alain Rodríguez Santos
I have a query: $query = mysql_query(SELECT event FROM table WHERE month = 'x' ORDER BY day ASC); I have all days of the month insert in day field: 1, 2, 3, 4, 5 ... when I print the query: if ($query_r = mysql_fetch_array($query)) { do { echo td width='8%'.$query_r['event']./td\n; }

[PHP] print value from db

2005-07-29 Thread Jesús Alain Rodríguez Santos
Hi, I have a table with: month, day, year, value I need to print every value corresponding to a day, for example: value[day1], if exist.. value[day2], if exist.. vale... etc It is possible? -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos

[PHP] function MAX with WHERE

2005-07-24 Thread Jesús Alain Rodríguez Santos
I have someting like this: $test = mysql_query(SELECT MAX(dato) AS datos FROM tabla WHERE campo_mes = '$mes'); $test_m = mysql_fetch_array($test); $test_mes = $test_m['datos']; print $test_mes where $mes is a value I need to know if something its wrong, because I don't recive any error, but I

[PHP] Don't ejecute a sentence if a field is empty

2005-07-23 Thread Jesús Alain Rodríguez Santos
Hello I'm new: I need to know how can I stop a php sentence if my db is empty, for example I have writed a php sentence, if every fields from mmy db are full, there is no problem, but I delete every values from the all fields in my db when I ejecute my script mysql give me an error, Ej: $fecha =