[PHP-DB] Code problem - need help.
Hello all, I have the following code: echo "\n"; echo "\n"; $sql2 = mysql_query("SELECT signature FROM event ORDER BY cid DESC LIMIT 10"); while ($row = mysql_fetch_array($sql2)) { // $cid_alert = $row["cid"]; $number = $row["signature"]; $name = mysql_query("SELECT sig_name FROM signature WHERE sig_id = $number"); echo "$number$name\n"; } echo "\n"; echo "\n"; When I view on my web page, the $number value comes out fine, but the $name comes out as "Resource ID #x" where x is some number. Currently is says "Resource ID #6". I know the SQL syntax is right, I have tested it. But what is wrong here? I have tried putting single quotes around $number in my query statement. It dod not work though. If anyone can help, it is greatly appreciated!!! Thanks, R Clark -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Code problem - need help.
> When I view on my web page, the $number value comes out fine, but the $name > comes out as "Resource ID #x" where x is some number. Currently is says > "Resource ID #6". I know the SQL syntax is right, I have tested it. But what > is wrong here? The mysql_query command returns a result set, not the 'value' of the query. Look up the mysql_fetch_array [http://us2.php.net/manual/en/function.mysql-fetch-array.php] and mysql_fetch_row commands. There are also several variants of these that return slightly different formats. Chase -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] - mail() with atachment
Hello list! Does anybody knows how to send a mail through a php page using mail() function including an attachment file? Thanx Nikos
RE: [PHP-DB] - mail() with atachment
Take a look at http://phpmailer.sourceforge.net/ a very usefull php class for sending e-mail including attachements. Rene. -Original Message- From: Nikos Gatsis [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 12, 2003 3:21 AM To: PHP-mailist Subject: [PHP-DB] - mail() with atachment Hello list! Does anybody knows how to send a mail through a php page using mail() function including an attachment file? Thanx Nikos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Session on PHP with MySQL
Dear Bayu, Sunday, January 12, 2003, 10:27:50 AM, you wrote: BS> it seem to me you didn't use session at all, BS> so where is the session problem? yup now I use seesion,here my script [hope you ca help me] User ID atau Password yang anda masukkan tidak benar "; } else { echo " Welcome $user_name "; } } function login_form() { global $PHP_SELF; ?> Login Page Login Required Nama Password Have No LoginID please Register BS> it's very helping if you send us the error message, for error mesage i just tell to user whit this script session_register("user_name","user_pass"); $name = auth($user_name,$user_pass); if (!$name) { echo "Wrong Authentication, pls relogin"; exit; } BS> is it from the mysql,php,or something else? I use php+mysql, thanks for yr support -- Warm regards, Afif mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] - mail() with atachment
Hello, On 01/12/2003 09:21 AM, Nikos Gatsis wrote: Does anybody knows how to send a mail through a php page using mail() function including an attachment file? Just try this class that provides exactly what you need and more and is very easy: http://www.phpclasses.org/mimemessage -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] RE: mysql_errno() list?
Thanks for replying Adam, I know how to trap an error and how to show errors in the document, what i was aiming for is to build my own system of user-friendly errors into my database layer of my server application to make the errors nicer, and wanted to write myself an include file with nicer versions of all the errors in. It turnsa out the text file I talked about in my original poost actually has what I need, but thanks anyway Kind regards James -Original Message- From: Adam Royle To: James Booker; [EMAIL PROTECTED] Sent: 10/01/03 22:30 Subject: Re: mysql_errno() list? Just use a combination of mysql_errno() and mysql_error(): echo mysql_errno() . ": " . mysql_error(). "\n"; Adam PS. Documentation always rocks! >Hi guys, >I've been playing with PHP for a while now, and love the mysql >functions, >but there's one thing I'd like to know... > >I want to check if a mysql error is a certain number, and thats all >fair >enough because every time i encounter an error I can write down what >that >error was. However, it would be handy if I could have my own define >file >with all the errors in. Can I ask if anyone has a list of errors and >their >numbers for mysql_errno? I've looked on the web and found a load of >errors >for the mysql daemon (the page told me to look in >/usr/share/mysql/mysql_errors.txt) but this isnt the file I want as the > >errors there relate to the server and not errors with a query I'm >running > >Thanks in advance for any help > >James Booker >EMPICS Sports Photo Agency >http://www.empics.com >
[PHP-DB] php oop books
I know this is a bit off topic, can anyone recommend a good php / oop book? I've been through php.net's library and nothing really on there. Thanks -Mike
Re: [PHP-DB] php oop books
On Sun, 12 Jan 2003 14:58:36 -0500 "Michael Scappa" <[EMAIL PROTECTED]> wrote: > I know this is a bit off topic, can anyone recommend a good php / oop > book? I've been through php.net's library and nothing really on there. > Thanks I do Not a good book about OO&php, but a good site: http://www.phppatterns.com/ hth pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP and mySQL help!
It looks like the problems is because $date and $host are in different tags. So if one is set, then the other won't be. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > -Original Message- > From: Dzung Nguyen [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 10, 2003 1:33 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] PHP and mySQL help! > > Thanks for the quick reply! Perhaps I should describe my problem more > specifically so that u could have a better idea: > > The code on PHP page to create forms for users to input field names: > > $tempdate = $date ; > $tempselect = $select ; > echo "Choose date > > > > > > > maxlength=10>" ; > echo "" ; > > $temphost = $host; > echo "Choose host > > > > > > > maxlength=10>" ; > echo "" ; > > I then would concat the values to query the database as follow: > > echo " href=\"build_form.php?select=all&date=$date&host=$host&order=$order&orde rt > wo=$ordertwo&way=$way&waytwo=$waytwo\" > target=\"_top\"> > > My problem right now is that I can't seem to keep both values. If one > value is update (host for example), the other value (date) is no longer > set??? > Thanks again for your help. > > > -- > Dzung V. Nguyen email: [EMAIL PROTECTED] > Alpha Linux Group http://linux.iol.unh.edu/clp > InterOperability Laboratory > University of New Hampshire phone: (603) - 862 - 0401 > Durham, NH 03824fax : (603) - 862 - 4181 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] php-mysql connect
I've setup a form to submit data into my MySQL database and it appears to connect properly and whatnot but when I check to see that the data has been inserted properly using phpMyAdmin, the table refelcts a new row entry but the fields are empty. ??? Anyone have this problem before?? Any help is greatly appreciated. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php-mysql connect
does this have anything to do with register_globals being off. are you using $_POST['var_name']? or $_GET['var_name']? can you send some code? jeff "Jared Price" cc: Subject: [PHP-DB] php-mysql connect 01/12/2003 04:47 PM I've setup a form to submit data into my MySQL database and it appears to connect properly and whatnot but when I check to see that the data has been inserted properly using phpMyAdmin, the table refelcts a new row entry but the fields are empty. ??? Anyone have this problem before?? Any help is greatly appreciated. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php-mysql connect
I've setup a form to submit data into my MySQL database and it appears to connect properly and whatnot but when I check to see that the data has been inserted properly using phpMyAdmin, the table refelcts a new row entry but the fields are empty. ??? I suspect this is a register_globals problem (the values from the form which are to be inserted into the database aren't being passed to the script as you'd expected). I'd echo the generated SQL to the browser to see what PHP thinks the query is. Then, if necessary, change which variables you use accordingly. Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Insertion upon upload
Hi all, I have a simple upload form. /// upload.php ## File to Upload: //# Which loads up a process page. //## process.php ### // The upload works great. But I need to pass the three variables created in the above code to a table "files" in the database. $fnme $fid $flctn Any ideas on how to incorporate an insertion method into the code above?? Cheers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Array printing
I am using an array to return the contents of a file. The file root is located on the db and the file content is correctly rendered using the following code: echo "\n\t" . $arrText= file($row["description"]); for ($i=0; $i$arrText[$i]"); } Everything works fine except that the paragraph is led off by the pesky "Array" tag, such as: Array File contents here.. Is there a way to suppress or hide the Array tag? I realize that there probably is an excruciatingly simple solution, but I have not found it yet. Thanks. Michael Conway [EMAIL PROTECTED] (703) 968-8875
[PHP-DB] Re: Array printing
Much simpler: foreach ($arrText as $text) { print $text; } Use that code. Just add in your HTML tags and it will be much cleaner and faster. "Michael Conway" <[EMAIL PROTECTED]> wrote in message news:!~!UENERkVCMDkAAQACABgAeI4MkiQKXEijmrrs5/EPIcKA [EMAIL PROTECTED] > I am using an array to return the contents of a file. The file root is > located on the db and the file content is correctly rendered using the > following code: > > > > echo "\n\t" . > > $arrText= file($row["description"]); > > for ($i=0; $i > { > >echo("$arrText[$i]"); > > } > > > > Everything works fine except that the paragraph is led off by the pesky > "Array" tag, such as: > > > > Array > > File contents here.. > > > > Is there a way to suppress or hide the Array tag? I realize that there > probably is an excruciatingly simple solution, but I have not found it > yet. > > > > Thanks. > > > > Michael Conway > > [EMAIL PROTECTED] > > (703) 968-8875 > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] inserting spaces in the select combo box
Hi, I am trying to align the three values in the select combo box but it is not working. The code is below : for($nRow=0; $nRow < $nNumRows; $nRow++) { $aAns = pg_fetch_array($lResult, $nRow, PGSQL_ASSOC); $JoinedValue = $aAns[location_code] . $aAns[section_code] . $aAns[part_number] . $aAns[uom] . $aAns[item_short_description]; echo "" . str_pad(trim($aAns[item_short_description]),25,'-') . "|" . $aAns[location_code]. "/" . $aAns[section_code] . "/" . $aAns[part_number] . ""; }; The size of item_short_description is 25. But when it is retrieved from the database it is of the actual size of the description. Due to this everything in the select box looks zigzag. str_pad though puts spaces those are not considered spaces in html. I think I will have to put something like . Can anybody help me in the above problem. Thanks in advance. Peace -- Rajesh : [ GNU/Linux One Stanza Tip (LOST) ]### Sub : bash keystrokes (#4) LOST #337 C-l : clear screen [C = Ctrl key] C-_ : undo last action C-r : reverse search in history with completion as you type (even searches through different arguments) <[EMAIL PROTECTED]>## : -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Insertion upon upload
On Monday 13 January 2003 06:23, Bruce Levick wrote: [snip] > The upload works great. But I need to pass the three variables created > in the above code to a table "files" in the database. > > $fnme > $fid > $flctn > > Any ideas on how to incorporate an insertion method into the code > above?? If you're new to databases then check out some php/database tutorials (there are _plenty_ out there). -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Our business is run on trust. We trust you will pay in advance. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php