find date an time of a table update

2006-12-21 Thread Marcelo Fabiani
Hi, I didn't find a way to know the time and date of the last update of table, not the data but the table info itself. Is this possible? I want to use this info in order to show it in a web page. Mysql 4.1 Apache Myisam Regards Marcelo Fabiani -- MySQL General Mailing List For

Re: help with insert +php

2006-09-01 Thread Marcelo Fabiani
Chris W escribió: Marcelo Fabiani wrote: Here is the code: . . . $result = mysql_query($sq)or die ("problema Leyendo Tabla");; . . . Why are there two ; at the end of that line? I'm really not sure what if anything that will do but I would remove it just in case.

Re: help with insert +php

2006-09-01 Thread Marcelo Fabiani
John Meyer escribió: Try this $retval = mysql_query($sql) or die(mysql_error()) To at least get an idea of what MySQL thinks is the error. The is no error in the insert it adds the row, but in addition add's two more rows with no data, only the auto_increment ; Example: Adds 1 Ma

Re: help with insert +php

2006-09-01 Thread Marcelo Fabiani
[EMAIL PROTECTED] escribió: Marcelo, The usual advice is to echo out the query string and examine it for syntax. Assuming it has form data in it for the variables, then try copying/pasting it into the mysql client and run it from there. Let us know how that goes. David Already done that

Re: help with insert +php

2006-09-01 Thread Marcelo Fabiani
06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Marcelo Fabiani [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 1:06 PM To: mysql@lists.mysql.com Subject: help with insert +php I'm trying to insert some data to my our web database, but when Insert the data, it inser

help with insert +php

2006-09-01 Thread Marcelo Fabiani
uot;; $sq = "SELECT * FROM empresas"; $result = mysql_query($sq)or die ("problema Leyendo Tabla");; echo ""; echo "Nombre EmpresaNitDireccionTelefono"; while ($row=mysql_fetch_row($result)){ echo

using like

2006-08-24 Thread Marcelo Fabiani
Hi to all the group, I have a problem with a query using mysql 4.01+mysql+php This is the form i use to get the data for the query: http://www.ibtec.info/resbu.php";> Ingrese palabra a buscar and here is the php i use \n"; $row = mysql_fetch_row($result); while ($row=m