[PHP-DB] Uploading files problem

2001-08-22 Thread Ian Grant
Hi, I have this code after a user submits a form with name, description and image file upload fields: images/people/preview is simply a unix link to /tmp/phptempimg-ian.grant The problem is, when this script is run, the image show is that from the previous operation. If you refresh the page, the

Re: [PHP-DB] getting ID

2001-08-20 Thread Ian Grant
ch_row($result); $id = $row[0]; return $id; } Ian. Ian Grant <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > mysql_insert_id([resource link_identifier]) returns the value of the > auto_increment field for the previous INSERT quer

Re: [PHP-DB] getting ID

2001-08-20 Thread Ian Grant
mysql_insert_id([resource link_identifier]) returns the value of the auto_increment field for the previous INSERT query. It will return 0 if there is not an auto_increment field. If the link_identifier is not specified, the last opened connection is used. So, use $id = mysql_insert_id(); directly

Re: [PHP-DB] HTML editors

2001-08-17 Thread Ian Grant
Okay thanks, I'll have a look at that. I am right in thinking that ActiveX controls can work in Netscape, as long as Internet Explorer (>4.0) is installed? Ian. John Pickett <[EMAIL PROTECTED]> wrote in message 001501c1269f$c977ed20$4c6146a6@notebook">news:001501c1269f$c977ed20$4c6146a6@notebo

[PHP-DB] HTML editors

2001-08-16 Thread Ian Grant
tag would be better, considering the users are not going to be HTML-proficient. However, I cannot seem to find anything like this that doesn't cost loads. Does anyone know of anything similar? Thanks, Ian Grant. -- -- PHP Database Mailing List (http://www.php.net/) To unsubscri

Re: [PHP-DB] Submit forms

2001-08-13 Thread Ian Grant
Yes, thank you, this works! Ian. Paul Burney <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > on 8/10/01 7:50 AM, Ian Grant at [EMAIL PROTECTED] wrote: > > > I've got a simply search form, on my site using PHP and MySQL. >

[PHP-DB] Submit forms

2001-08-10 Thread Ian Grant
Hi, I've got a simply search form, on my site using PHP and MySQL. It writes a SELECT query using WHERE ( LIKE '%thingy%') where thingy is the word entered in the form. It works fine if the submit button is pressed, but if you press return after typing the word, instead, it fails and writes noth

[PHP-DB] Re: Making a new row in HTML tables

2001-07-25 Thread Ian Grant
last row with > empty cells. > > "Ian Grant" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Hi, > > > > Can anyone help me with this - I have a database of people, that I want to > > print into an HTML t

[PHP-DB] Making a new row in HTML tables

2001-07-25 Thread Ian Grant
Hi, Can anyone help me with this - I have a database of people, that I want to print into an HTML table - how can I make the table wrap into an equal number of rows. i.e. if there are 4 entries, a 2x2 table, 6 a 2x3, 8 a 2x4, 9 a 3x3, etc. At the moment, I have something like: $rows=mysql_num_r