Re: [PHP-DB] Upload and Display images with Mysql

2004-05-24 Thread Rachel Rodriguez
--- Kpromos [EMAIL PROTECTED] wrote: Dears All, I'm looking for a simple script that will permitme to upload images in a mysql database, calling out the images with a function from a mysql database (calling them from an id variable). I have just tried this tutorial

Re: [PHP-DB] Request for help on (My)SQL Statement

2004-04-27 Thread Rachel Rodriguez
UPDATE ngc_polling SET lastrundate = max(nuke_phpbb_posts.post_time) It returns Invalid use of group function. John, you're getting that error message because the max() function requires a GROUP BY clause. Try this: SELECT max(nuke_phpbb_posts.post_time) FROM nuke_phpbb_posts GROUP

Re: [PHP-DB] Request for help on (My)SQL Statement

2004-04-27 Thread Rachel Rodriguez
John, you're getting that error message because the max() function requires a GROUP BY clause. Ooops, my bad. It requires a GROUP BY if you are pulling from more than one column. = ~Rachel __ Do you Yahoo!? Win a $20,000

Re: [PHP-DB] stuck on stupid...can't find the bloody error...

2004-04-25 Thread Rachel Rodriguez
echo form action=\add.php\ method=\get\; echoform action=\add.php?action=$page_req\ method=\get\; Try that first, and see if it fixes your issue. I'm shutting down for the day and unfortunately, I didn't have time to parse through the remainder of script. ~Rachel = ~Rachel

Re: [PHP-DB] move_uploaded_file

2004-04-24 Thread Rachel Rodriguez
--- matthew perry [EMAIL PROTECTED] wrote: I have a file uploading function that works well on my local server. It finds a picture and uploads it into a defined directory. Matthew, if you are the confident that your function works correctly, your next check should be on what permissions you

Re: [PHP-DB] Re: assigning variables after one-to-many query

2004-04-23 Thread Rachel Rodriguez
--- Torsten Roehr [EMAIL PROTECTED] wrote: Rachel Rodriguez [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi! I have a one-to-many relationship between two tables (table1 and table3) with a linking table between them (table2): table1: table2

Re: [PHP-DB] assigning variables after one-to-many query

2004-04-23 Thread Rachel Rodriguez
what i would do is add it into an array: $emails = Array(); while ($row = mysql_fetch_array($result,MYSQL_NUM)) { $emails[] = $row[0]; } then u have an array with : $emails[0] = [EMAIL PROTECTED] $emails[1] = [EMAIL PROTECTED] etc... Thanks, Uzi! This is exactly what I

Re: [PHP-DB] Inserting date into a table

2004-04-23 Thread Rachel Rodriguez
I want to insert into the TIMESTAMP field the date automatically. How can I do it using the insert command INSERT INTO $table VALUES('','$name','TIMESTAMP','$question','$email','NULL'); Use the word null (no quotes) in place of 'TIMESTAMP': INSERT INTO $table VALUES('', '$name',

[PHP-DB] assigning variables after one-to-many query

2004-04-22 Thread Rachel Rodriguez
Hi! I have a one-to-many relationship between two tables (table1 and table3) with a linking table between them (table2): table1: table2 +---++ +---++ |id | f_name | |id | emailID| +---++ +---++ | 1 | bill | | 1 | 1| | 2 |