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 list

help with insert +php

2006-09-01 Thread Marcelo Fabiani
/tdtdNit/tdtdDireccion/tdtdTelefono/td/tr; while ($row=mysql_fetch_row($result)){ echo trtd$row[3]/tdtd$row[4]/tdtd$row[5]/tdtd$row[8]/td/tr; } echo /table; include 'closedb.php'; ? Regards Marcelo Fabiani -- MySQL

Re: help with insert +php

2006-09-01 Thread Marcelo Fabiani
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 inserts all

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

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 Marcelo

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. Also are there any

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: FORM method=post action=http://www.ibtec.info/resbu.php; h1Ingrese palabra a buscar/h1 INPUT type=text name=ci INPUT type=submit value=Buscar INPUT type=reset