Re: [PHP-DB] Something wierd with time() and curdate()

2004-11-01 Thread Bobo Wieland
Thanks for trying to help me... I just found out what the problem was... I use the number of seconds in a day (86400) as a constant Yesterday there wasn't 60*60*24 seconds in a day though... It was acctually 60*60*25 seconds... That's why the script flipped out at 11 pm... Also, in the spring

RE: [PHP-DB] Problems with mysql_num-rows()

2004-11-01 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 01 November 2004 05:01, Doug Thompson wrote: The variables are not being expanded. As a minimum, you need to escape the single quotes. $query = SELECT * from user where

[PHP-DB] Fixing this code to show all variables!

2004-11-01 Thread Juan Stiller
Hi, im trying to use this code to send a query to a mysql database, and then display the query results and put the results on variables, the problem is that i don´t know how to make it so that if there is more than one result, it uses xvariables as results are, using this script just like it is,

RE: [PHP-DB] Fixing this code to show all variables!

2004-11-01 Thread Bastien Koert
remove the @ symbol from in front of the connect functions @mysql_connect @mysql_select_db Its supressing any errors that you may have...when you finish the debugging, then you can add them back in. bastien From: Juan Stiller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Fixing this

[PHP-DB] Forms list from database

2004-11-01 Thread Jason T. Davidson
I am trying to take information from a database and show that info in a forms list. I have been trying this with while(), but it never comes out and displays correctly. Any help would be appreciated. -- Jason Davidson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] Fixing this code to show all variables!

2004-11-01 Thread Juan Stiller
Ok, i´ve removed the @ form them, and now im trying this, but its not working: // Request all data $result1 = mysql_query(select * from clientesnuevos); $nrows = mysql_num_rows($qr); for ($i=0; $i $nrows; $i++) { $row = mysql_fetch_array($qr); echo Id={$row['id']}; echo

Re: [PHP-DB] Forms list from database

2004-11-01 Thread Juan Stiller
It might be usefull to see the code you are using to show the query results. --- Jason T. Davidson [EMAIL PROTECTED] escribió: I am trying to take information from a database and show that info in a forms list. I have been trying this with while(), but it never comes out and displays

Re: [PHP-DB] Fixing this code to show all variables!

2004-11-01 Thread Juan Stiller
Thanks for the response, Now its fixed, and this is the output for the code: Id=28Apellido=sadfsadfNombre=asdfsdfDni=sadfsdfTelefono=sadfsadfDia=1Mes=12Ano=2004Hora=9Minutos=50Abogado=Dra. Claudia I. GornoNombre=asdfsdfAsunto=asdfsdDonde=Guia Barrial

Re: [PHP-DB] Fixing this code to show all variables!

2004-11-01 Thread Gabino Travassos
Hello Juan If I declare Telefono=4141414 in one line and in the next line I declare Telefono=31453531, then I have overwritten the first variable. What you need to change is the name of the variable. You need to append your ID number to the variable name. So Telefono01=4141414 and

[PHP-DB] Insert and Update on same page

2004-11-01 Thread Bomgardner, Mark A
I've got a problem with trying to insert and updating on the same page. Here is my problem: I have a form that the user fills out. Upon submission, I want the information that was just inserted, to be pulled back out and shows to the user with an unique number for that record other than the

Re: [PHP-DB] Insert and Update on same page

2004-11-01 Thread Micah Stevens
You didn't mention which database you're working with, so I'll assume mysql. In a word, yes, this is possible, just do it in sequence. pseudo-code: mysql_query(insert blah blah); $id = mysql_insert_id(); $data = mysql_fetch_assoc(mysql_query(select * from table where id = $id)); $uniqueID =

Re: [PHP-DB] Forms list from database

2004-11-01 Thread Jason T. Davidson
Here is the code: form name=form1 method=post action=staff_code/add_code.php table width=600 border=0 align=center cellpadding=0 cellspacing=0 tr bgcolor=#CC td colspan=3 bgcolor=#FFdiv align=center select name=controller id=controller option /option option ? while

RE: [PHP-DB] Forms list from database

2004-11-01 Thread Norland, Martin
Assuming, for the moment, that there's more code above that to actually support this... You want to be quoting the keys in the array, and containing each array 'lookup' in {}s: print $check[LNAME],$check[FNAME]($check[CID]); Should be print

[PHP-DB] November 2, 2004

2004-11-01 Thread GH
Greetings: This is just a friendly reminder that if you are registered in the United States to VOTE on November 2, 2004 (TOMORROW) Need to know where you vote? Please see the attached file (it is an image) that contains some information -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] Re: [EMAIL PROTECTED] November 2, 2004

2004-11-01 Thread Patrick Donker
GH wrote: Greetings: This is just a friendly reminder that if you are registered in the United States to VOTE on November 2, 2004 (TOMORROW) Need to know where you vote? Please see the attached file (it is an image) that contains some information Do we care? Realy? Unlikely. Maybe you should

Re: [PHP-DB] Re: [users@httpd] November 2, 2004

2004-11-01 Thread Joseph Crawford
Do we care? Realy? Unlikely. Maybe you should send your 'useful' info on a national mailinglist only. i am sorry but i do care, if you do not care about voting you dont care if the war comes to the US. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] For a GMail account contact

Re: Re: [PHP-DB] Re: [EMAIL PROTECTED] November 2, 2004

2004-11-01 Thread John Holmes
From: Joseph Crawford [EMAIL PROTECTED] Do we care? Realy? Unlikely. Maybe you should send your 'useful' info on a national mailinglist only. i am sorry but i do care, if you do not care about voting you dont care if the war comes to the US. Thank you, but WRONG LIST! I see no

[PHP-DB] super define...

2004-11-01 Thread Jonathan Haddad
Is there a way to use define so it replaces the constant even if it's inside quotes? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Insert and Update on same page

2004-11-01 Thread Bastien Koert
Sure, the easiest way is to get that unique value with PHP and then insert it, then you can show the form again with that unique value, no need to do an update or other manipulation, if I understand your requirements correctly... Bastien From: Bomgardner, Mark A [EMAIL PROTECTED] To: [EMAIL

[PHP-DB] can i display an image _directly_ from postgres db storage?

2004-11-01 Thread P. George
i know that postgres has a raw binary datatype called bytea for storing pictures and whatnot, but i'm having trouble finding an example of displaying an image on a web page with php that is pulled directly from the database? is this possible? if so, how? thanks. - philip -- PHP Database

RE: [PHP-DB] can i display an image _directly_ from postgres db storage?

2004-11-01 Thread Mike
Philip, Typically, it's infinitely more performance-friendly to simply store your files on the hard disk and use the database to refer to that location. For instance, assume your root web dir is /www. Inside there you have an /images directory. If you religiously put all files inside of

Re: [PHP-DB] can i display an image _directly_ from postgres db storage?

2004-11-01 Thread P. George
Typically, it's infinitely more performance-friendly to simply store your files on the hard disk and use the database to refer to that location. For instance, assume your root web dir is /www. Inside there you have an /images directory. If you religiously put all files inside of /images you

Re: [PHP-DB] can i display an image _directly_ from postgres db storage?

2004-11-01 Thread Jason Wong
On Tuesday 02 November 2004 03:36, P. George wrote: i know that postgres has a raw binary datatype called bytea for storing pictures and whatnot, but i'm having trouble finding an example of displaying an image on a web page with php that is pulled directly from the database? is this

Re: [PHP-DB] can i display an image _directly_ from postgres db storage?

2004-11-01 Thread P. George
Tutorials that shows how to upload and store image/binary files in a database also usually shows how to retrieve them (and in the case of images, also how to display them). One function you'll find useful is imagecreatefromstring() thanks. i found an example for uploading an image into the

[PHP-DB] How can I store Images in the MySQL Database

2004-11-01 Thread Mulley, Nikhil
Hi Lists , My Query is How Can I store Images in the MySQL Database , and how to Index them , can anybosy help me on this please I am starting out a Online Photo Gallery and want to share them , and I want to make the search available, Does anybody has already done on this ?

Re: [PHP-DB] can i display an image _directly_ from postgres db storage?

2004-11-01 Thread P. George
$result = pg_exec($dbconn, SELECT $image FROM thetable where name='$name'); nevermind. i had a missing double-quote on this line. works great now. thanks. - philip -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] sms service to my site..?

2004-11-01 Thread Ilanthiraian,B
Dear Sir, I would like to add SMS Services in my Site. So if any body know the scripts in PHP, Could you guide me to my progress..?. I think any body have done this kind of work as your company projects..!, So i want urgent. Regd, Ilanthiraian,B __

Re: [PHP-DB] Re: [EMAIL PROTECTED] November 2, 2004

2004-11-01 Thread Lester Caine
Joseph Crawford wrote: Do we care? Realy? Unlikely. Maybe you should send your 'useful' info on a national mailinglist only. i am sorry but i do care, if you do not care about voting you dont care if the war comes to the US. There are many more of us who do not have the right to vote in the US,

[PHP-DB] Re: How can I store Images in the MySQL Database

2004-11-01 Thread Daniel Kummer
Nikhil Mulley wrote: Hi Lists , My Query is How Can I store Images in the MySQL Database , and how to Index them , can anybosy help me on this please I am starting out a Online Photo Gallery and want to share them , and I want to make the search available, Does anybody has already done