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 > http://www.ph

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,0

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

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

2004-04-25 Thread Rachel Rodriguez
> echo ""; > echo""; 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 __ Do you Yahoo!? Yahoo! Phot

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

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('', '$n

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 ex

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

[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