Re: [PHP-DB] Placing a form on a page

it to align with floating elements?/rhetorical -- Cheers David Robley Freedom is just chaos with better lighting. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Processing Account Login

putting into production is high quality and not hap hazard. Thank you for any help you are able to provide me with. Ron Piggott www.TheVerseOfTheDay.info Try 'php mysql login' as your Google search string -- Cheers David Robley File not found. Should I fake it? (Y/N) -- PHP

[PHP-DB] Re: Query will not work - SOLVED

Ethan Rosenberg, PhD wrote: What am I doing wrong?? Not checking the errors that mysql returns? -- Cheers David Robley Tennis in the Bible: Moses served in Pharaoh's court... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: SQL syntax

'.mysqli_real_escape_string($yesterday).') Personally I would have used a lookup table for the order status. -- Cheers David Robley A cynic smells flowers and looks for the casket. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: PDO Mysql data truncation missing error

attribute may do what you want? Cheers -- David Robley I'm not rude, I'm attitudinally challenged. Today is Pungenday, the 14th day of Bureaucracy in the YOLD 3178. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Multiple Access to Database

://dev.mysql.com/doc/refman/5.5/en/privilege-system.html Cheers -- David Robley Heads I win, tails you lose. Today is Setting Orange, the 15th day of Chaos in the YOLD 3178. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Problem with mysql and php

of that. I'd hazard a guess that there might be indexing problems. http://dev.mysql.com/doc/refman/5.1/en/using-explain.html Cheers -- David Robley Insert inevitable trivial witticism of your choice. Today is Pungenday, the 41st day of The Aftermath in the YOLD 3177. -- PHP Database Mailing

[PHP-DB] Re: PHP + SQLite - Issues with update

of flush that needs to happen which happens only if the script errors out. Any help is appreciated. Thanks, Prashant. Spelling matters :-) $row = $res-fecth(); Wrong $row = $res-fetch(); Right Cheers -- David Robley Caterpillar: Scratching post. Today is Prickle-Prickle, the 2nd

[PHP-DB] Re: Odd MySQL Problem...

the leading zeros you'll need to store them in a char type and quote them when INSERTing or UPDATEing Cheers -- David Robley The information went data way Today is Boomtime, the 68th day of Bureaucracy in the YOLD 3177. -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Re: Working with large datasets

. http://dev.mysql.com/doc/refman/5.0/en/using-explain.html Amongst other things With the help of EXPLAIN, you can see where you should add indexes to tables so that the statement executes faster by using indexes to find rows. Cheers -- David Robley I've been to San Francisco said Tom heartlessly

Re: [PHP-DB] PHP.ini file

-- David Robley The calm confidence of a Christian with four Aces. - M.Twain Today is Pungenday, the 50th day of Discord in the YOLD 3177. Celebrate Discoflux -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: jpgraph and mysql passing array

)) { $datay[] = $row[MBusage]; $datax[] = $row[Distance]; } echo TEST DATA PRINT; print_r($datay,false); ? snip Thank you, Chris If $datay shows as empty, my first step would be to check that your SQL query doesn't return an empty set. Cheers -- David Robley This ocean

[PHP-DB] Re: Prepared Statements

/pdostatement.fetch.php looks to be one solution. Or http://php.net/manual/en/pdostatement.fetchall.php which gives you an array of all the result set rows. Cheers -- David Robley To shoot a mime, do you use a silencer? Today is Pungenday, the 43rd day of Chaos in the YOLD 3177. -- PHP Database Mailing

[PHP-DB] Re: Prepared Statements and mySQL

it; I imagine the same applies for prepared statements #3) Dates are entered aas strings, so need to be quoted as strings Disclaimer; I have also not used prepared statements, but have looked quickly at the mysqli docs :-) Cheers -- David Robley My software never has bugs. It just develops random

[PHP-DB] Re: PHP Search DB Table

$query . 'br /'; $result = mysql_query($query); And see what is actually in the query. Cheers -- David Robley Reality is nothing but a collective hunch. Today is Pungenday, the 56th day of The Aftermath in the YOLD 3176. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] Re: Escaping an '

Ron Piggott wrote: For a query similar to: SELECT * FROM `tablle` WHERE `column` LIKE 'Sally's Hair Parlor' how do I escape the ' for 's? It's in the manual - assuming you use mysql, see http://php.net/manual/en/book.mysql.php Cheers -- David Robley I just won 1000 dollars, Tom said

[PHP-DB] Re: Stuck in apostrophe hell

, and make sure you aren't using stripslashes somewhere? Also, echo the actual query that is being passed to mysql to check what is happening. Cheers -- David Robley Life is Roff when yer Stewpid Today is Sweetmorn, the 70th day of Confusion in the YOLD 3176. -- PHP Database Mailing List (http

[PHP-DB] Re: MySQL Wildcard

reporting function? If so, try using it. Note that to retrieve all records, you could skip the WHERE, or use WHERE 1 Cheers -- David Robley Machine-independent: does not run on any existing machine. Today is Pungenday, the 55th day of Discord in the YOLD 3176. -- PHP Database Mailing List (http

[PHP-DB] Re: Rounding up results

not let you access the mysql documentation? http://dev.mysql.com/doc/refman/5.1/en/mathematical-functions.html Cheers -- David Robley CTRL-ALT-DEL is the key to success Today is Pungenday, the 68th day of Chaos in the YOLD 3176. -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Re: mysql_query

check the mysql section of the documentation, where you will find http://php.net/manual/en/function.mysql-affected-rows.php which will tell you how many rows were affected by your INSERT. Alternatively, if you are using Innodb tables, you could look at using transactions. Cheers -- David Robley

[PHP-DB] Re: PHP and table/view names with '$'

Try enclosing your query in single quotes so php doesn't try to expand what it sees as the variable $sql. For example $stmt = OCIParse($conn, 'SELECT * FROM v$sql'); Cheers -- David Robley I am Homer of Borg. Prepare to be assim... , donuts. Today is Pungenday, the 40th day of Discord

[PHP-DB] Re: session variable in select query showing picture from database

will give you some useful information. Cheers -- David Robley I hate Chablis, Tom whined. Today is Pungenday, the 43rd day of Chaos in the YOLD 3175. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Queries / variables

are returning all the language fields for each query but only using one. Why not just retrieve the specified language instead, based on the content of $language? Cheers -- David Robley Circular Definition: see Definition, Circular. Today is Sweetmorn, the 49th day of The Aftermath in the YOLD 3174

[PHP-DB] Re: Apache HTTP Server has encountered a problem and needs to close

S, Murgesan (GE, Corporate, consultant wrote: Hi, I have posted an error in http://bugs.php.net/?id=46519 Please help me to resolve it. Probably the best thing you can do at this stage is submit a backtrace as you were asked on the bugs site. Cheers -- David Robley Recovery

[PHP-DB] Re: Form processing

, probably on and would be better off. Of course this may create havoc with database queries if you aren't already ignoring it and using the appropriate escaping for whatever db you use. Cheers -- David Robley Entropy isn't what it used to be. Today is Setting Orange, the 36th day of Bureaucracy

[PHP-DB] Re: Connecting to mysql from another host

] Cheers -- David Robley Why doesn't the Bat Computer ever crash? Today is Setting Orange, the 69th day of Confusion in the YOLD 3173. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: mysql_real_escape_string

defined, the last MySQL connection is used. Cheers -- David Robley Some days, nothing goes left. Today is Pungenday, the 45th day of Discord in the YOLD 3173. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: auto_increment

in the AUTO_INCREMENT column, the value is reset to the current maximum plus one. It probably should be said that there is normally no reason to play with auto-increment values. Cheers -- David Robley An ulcer is what you get mountain climbing over molehills. Today is Prickle-Prickle, the 31st

[PHP-DB] Re: Using apostrophe's within a text field

the user enters a word like won't or can't. Them it crashes during the form submit. What can I do to fix this stupid thing anyway? thanks in advance. Steve Smith http://php.net/mysql_real_escape_string The manual is your friend. Cheers -- David Robley I'm Serfectly Pober. Today is Boomtime

[PHP-DB] Re: imagettfbbox

enabled any help -- madunix In phpinfo, under GD you should also have a line FreeType Supportenabled I'd guess that your configure for freetype is wrong, but I'm not sure where you might find it - perhaps /usr/local ?? Cheers -- David Robley Don't use no double negatives. Today

Re: [PHP-DB] Access denied for user...sometimes???

connection to your own machine - use localhost instead of your dynamic(?) IP, and set skip-networking (or whatever it is called) to on in your my.cnf file. Cheers -- David Robley Useless Invention: Checkered paint. Today is Pungenday, the 53rd day of Chaos in the YOLD 3173. -- PHP Database Mailing

[PHP-DB] Re: Filter array results... no copies

= state_from_dataset endwhile Cheers -- David Robley Auntie Em: Hate you, hate Kansas, taking the dog. -Dorothy Today is Boomtime, the 12nd day of Chaos in the YOLD 3173. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Retrieve text from Oracle Text

will ignore the newlines - View Source should confirm that this is the case. You should use nl2br() on the retrieved data before passing it to the browser. Cheers -- David Robley Buy me something to drink? said Tom drily. Today is Setting Orange, the 71st day of Bureaucracy in the YOLD 3172

[PHP-DB] Re: pulling numbers from a column and getting a total

DB to do the work for you. Cheers -- David Robley Power corrupts; absolute power is even more fun. Today is Pungenday, the 62nd day of Confusion in the YOLD 3172. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Linux Commands

Manoj Singh wrote: Hello All, Is it possible to run the Linux Commands through php functions or code? If anyone knows, please help me out. Regards Manoj php.net/manual/en/ref.exec.php Cheers -- David Robley User Error: replace user and press any key to continue. Today is Prickle

[PHP-DB] Re: Automatically +1 every 30 mins to a value in the database.

every $period from cron; for Windows I think there is a task scheduler (or similar name) that allows the same thing. Cheers -- David Robley I tried to daydream, but my mind kept wandering. Today is Pungenday, the 7th day of Confusion in the YOLD 3172. -- PHP Database Mailing List (http

[PHP-DB] Re: Warning, Subscribers please read!

from Rasmus recently which indicated that there had been a problem with the spam filter - problem had been resolved. Cheers -- David Robley If I can't fix it, it's probably dead. Today is Sweetmorn, the 58th day of Discord in the YOLD 3172. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] if() and else() help needed

, if your DB supports these statements. Cheers -- David Robley NUMBER CRUNCHING: Jumping on a Computer. Today is Pungenday, the 15th day of Discord in the YOLD 3172 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] help with file downloads from MySQL

in your script? If there is an empty line above it, that could cause the extra EOL character. Cheers -- David Robley My other car is a broom! Today is Prickle-Prickle, the 11st day of Discord in the YOLD 3172 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Re: Cut down threads please!

into. J Well, whilst we are having a bitch about things, perhaps everyone could turn on word wrap in their favourite mailer/newsreader. Starting with you, please? Cheers -- David Robley People say I'm apathetic, but I don't care. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] slow loading page

of the document, or whether the document is served independently og logging actions; I would guess the latter. Cheers -- David Robley I'm never anywhere on time, Tom related. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: first record not displayed

it :-) Cheers -- David Robley This library isn't safe - I just stumbled on an idea. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] auto_increment and INSERT INTO

the auto-increment field is for. Cheers -- David Robley Set laser printers to stun. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: SELECT

problem. In other words, create a valid date/timestamp value with CONCAT then use DATE_SUB to determine -90 min. I've given a Mysql based solution as this is php.db :-) Cheers -- David Robley I'm an ordained minister, said Tom reverently. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Add or Subtract

+ $newamount WHERE [something to identify the record to be updated] where $newamount is the positive or negative value of the increase passed in from wherever. Cheers -- David Robley Press any key to continue or any other key to quit... -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Problem with creating parallel connections with mysql_connect

(); $err = mysql_error($accid); Note that I use php-5.1.2RC1 compiled for Darwin Kernel Version 8.3.0 and Macintosh powerpc Aarno Try the above to find exactly where your problem is Cheers -- David Robley If I had anything witty to say, I wouldn't put it here. -- PHP Database Mailing

Re: [PHP-DB] FTPing within PHP

gives the command DELE /path/somefile.txt Is there a way for me to send this command through? I also need to know the command to disconnect --- and wonder if someone could tell me it. Ron All is revealed at http://php.net/ftp Cheers -- David Robley FLOPPY DISK: Serious curvature

[PHP-DB] Re: Refreshing text question!

be getting the data via php/mysql, but the actual method you use to make the outcome how you want it, is not php. I just had to say that before the real pedants on the list get started :-) Cheers -- David Robley If you're not confused, you're not paying attention. -- PHP Database Mailing List (http

Re: [PHP-DB] Importing CSV into MySQL

explode() to get each column value for each row. I think LOAD DATA INFILE might be one option Cheers -- David Robley Are you really American if your ethnicity has to be hyphenated? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] inserting due date into database

information. Cheers -- David Robley Don't be a sexist, broads hate that. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] range_alloc_block_size

It might well be. There is a config setting in mysql called max_allowed_packet which might be relevant in this case. IIRC it defaults to quite a small value. Yes, the default is 1 Mb in versions 3 and 4 of mysql. Cheers -- David Robley I joined the Lion's Club, said Tom pridefully. -- PHP Database

[PHP-DB] Re: file_get_contents

of file_get_contents to a variable and then displaying that variable somehow? Perhaps the string being displayed contains a character that would foul up the display? More information, please. Cheers -- David Robley #define QUESTION ((bb) || !(bb)) - Shakespeare. -- PHP Database Mailing List (http

Re: [PHP-DB] file_get_contents

were to try wrapping the lines to around 80 characters you might get over the problem. If not, amybe it is the World Wide Web getting its own back for you using such a lengthy URL :-) BTW, your HTML syntax on that page is not correct. Cheers -- David Robley It's two, two, two mints in one

[PHP-DB] Re: printing errors

understood Cheers -- David Robley Change is inevitable, except from a vending machine. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Batch queries in the same mysql_query()

it will tell you that the query shouldn't end with a semicolon ; What it really should say is the query shouldn't _contain_ a semicolon. This is php attempting to protect you from SQL injection. Just do a separate mysql_query for each query. Cheers -- David Robley Friction can be a drag sometimes

[PHP-DB] Re: xml to mysql tables using php

- see http://php.net/xml for all the gory details. Of course, you'll need to write your own code to insert the parsed data into your favourite database. Cheers -- David Robley Everything bows to success, even grammar. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] Re: PHP Mail command

table; is there a similar way to get around this problem I am having? I suspect you want str_replace() Cheers -- David Robley Useless Invention: Brown undershorts. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: Select

Message- From: David Robley [mailto:[EMAIL PROTECTED] Sent: Martes, 17 de Mayo de 2005 03:42 p.m. To: php-db@lists.php.net Subject: [PHP-DB] Re: Select Miguel Antonio Guirao Aguilar wrote: Hi!! I have this query in PHP: $items2 = mysql_query(SELECT DISTINCT * FROM rev ORDER BY rev

[PHP-DB] Re: Select

Miguel Antonio Guirao Aguilar wrote: Hi!! I have this query in PHP: $items2 = mysql_query(SELECT DISTINCT * FROM rev ORDER BY rev, $link); I have three rows with the same data on it, and DISTINCT seems to be not working, since I got all the rows, any ideas of what is going wrong?

[PHP-DB] Re: Just can't get it to work.. variables

Gavin Amm wrote: Hi All, I just can't for the life of me get the variable to output a value from the array: (all preceding script in place to make this work..) The start date retrieved from the database is, for example, 20050412 (mmdd). The example output for each variable (w/o

RE: [PHP-DB] Re: Just can't get it to work.. variables

Gavin Amm wrote: Yeah, I ended up doing that (associative array) then reading your e-mail.. Oh well, thanks. I couldn't cast the var as an int. in the database it's setup as a timestamp(8) (mmdd), not sure why I set it up as such.. Cheers, Gavin I guess I didn't fully explain that I

Re: [PHP-DB] Connecting To Mysql through php/mysqli

On Thu, 3 Feb 2005 13:49, Graeme wrote: I like the idea of a mysqli_queasy() function. Maybe it would allow you to sumbit SQL statements that don't conform to any standard? ;) graeme. Bastien Koert wrote: the second error is a misspelling in the mysqli_query command bastien Call to

[PHP-DB] Re: Excel to MySQL

. Thank you, One option might be to export the Excel data as csv, then use whatever option your database provides to import the csv data. -- David Robley Nostalgia isn't what it used to be. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Returns Blank

to the browser. Also a check of the document source might help. -- David Robley This steamroller really works, said Tom flatteringly. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: ssh tunneling with phpmyadmin

would ask here :) I am using Mac OS X if it matters many thanks g If your ISP allows you to make a remote connection to mysql, just point your local phpmyadmin at that. -- David Robley I've gone back to my wife, was Tom's rejoinder. -- PHP Database Mailing List (http://www.php.net

RE: [PHP-DB] Looping within a string?

have the data all in one variable. -- David Robley My pencil is dull, said Tom pointlessly. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Using a loop on a result destroys array??

, an internal pointer is advanced to the next row; if the final row has been requested, the pointer points to 'nowhere' and can't be further advanced without resetting it to the first row. Cheers -- David Robley I won't finish in fifth place, Tom held forth. -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Re: How do I reverse-finding root entry in tree-structure ?

and stick the branch to it ... and doing all of this in reverse since that's what I need for the visual part... Using MySQL btw ... I don't know if you have seen http://www.sitepoint.com/print/hierarchical-data-database but it may provide some help. Cheers -- David Robley Don't use no double

[PHP-DB] Re: Finding the highest number in a column?

and MySQL to find out what the highest number is in a particular column easily when the numbers are auto-incremented so aren?t necessarily one after the other? I would really appreciate any help on this as it?s really bugging me. Chris Does SELECT MAX(column) do what you want? -- David

[PHP-DB] Re: I can't seem to get Max() to work

; ++ | max(au_linkid) | ++ |540 | ++ 1 row in set (0.03 sec) FoodItemNumber is an integer type? -- David Robley I Have To Stop Now, My Fingers Are Getting Hoarse! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Converting Date for mysql

like this simply and without resorting to the mailing list. -- David Robley Terminal glare: A look that kills... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: error

: Undefined index: op in \\premfs15\sites\premium15\mrbushforpeace\webroot\replytopost.php on line 9 You probably have different error_reporting settings in the php.ini files on the different servers. Test if the value is set. -- David Robley I commanded a group of ships for a week, Tom said

[PHP-DB] Re: Finding the value of the COMMENT in a table column

of the returned data. If there is a better way, I haven't found it yet :-0 Not sure how this will work with column comments. Cheers -- David Robley May I introduce the family Stone? Tom asked slyly. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Socket Errors

to news.php.net:119 (A non-blocking socket operation could not be completed immediately. ) in D:\htdocs\WebReader\System\NET\Sockets\Socket.php on line 25 The nntp server at news.php.net seems to have been out of action for quite some hours. -- David Robley Constant change is here to stay

[PHP-DB] Re: Name searches for the spelling impaired

/String_functions.html Something like SELECT fields FROM table WHERE SOUNDEX(name) = SOUNDEX('searchvalue') Cheers -- David Robley Lead me not into temptation, I can find it myself. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

-- David Robley Would you like to buy an alarm? asked Tom self-righteously. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Php if statement in a form

On Fri, 6 Aug 2004 11:04, Justin Baiocchi wrote: Still no joy. The parse error actually refers to the -- if ($row[timeout] IS NULL); --- line. Please trim your replies. IS NULL is for mysl - try if ($row[timeout]=== NULL) -- David Robley Heads I win, tails you lose. -- PHP Database

[PHP-DB] Re: sendmail

in the php.ini file that just went over my head. Can anyone enlighten me on this function. Thanks, There are no sendmail functions in php - there is the mail() function that should interface with whatever mta you have, if php was compiled with the mta already installed. Cheers -- David Robley It's

[PHP-DB] Re: Converting an MS Access DateTime in PHP

to suit. http://www.php.net/manual/en/ref.datetime.php -- David Robley OK, I'm weird! But I'm saving up to become eccentric. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: JOIN question

://dev.mysql.com/doc/mysql/en/JOIN.html for the syntax and examples, and also http://www.google.com/search?q=sql+tutorial as a starting point for some SQL tutorials which will cover joins in more detail than you will probably get here. -- David Robley Shh! Be vewy quiet, I'm hunting wuntime errors

[PHP-DB] Re: php/mysql error

using a query without indexes. Try running EXPLAIN on your query, and have a look at this page from the mysql site which tells more about table scans. http://dev.mysql.com/doc/mysql/en/How_to_avoid_table_scan.html Cheers -- David Robley Help! I'm lost somewhere in the Generation Gap. -- PHP

[PHP-DB] Re: Query returns duplicate rows

DISTINCT does. The keyword applies to the entire record, not individal fields, and will effectively delete any duplicate rows. ScoreId is presumably a unique ID for the record; that being the case you can expect all selected rows will be different. Cheers -- David Robley Backups? We don' *NEED

Re: [PHP-DB] problem....

, username FROM RuneRunner, RuneRunner_1 WHERE User_ID = 3; 2) Use mysql_error() to get the actual error from mysql $result = mysql_query($query,$connection); echo mysql_error(); $pic=mysql_fetch_array($result); -- David Robley I'd like to learn a new card game, Tom said wistfully. -- PHP Database

RE: [PHP-DB] Re: CSV update Mysql feature

for each field $query .= FROM table WHERE where ORDER BY whatever; Or something like that. Then you output in csv format with echo or print or sprintf or whatever -- David Robley Don't hate yourself in the morning - sleep till noon. -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Re: Multi search function (help)

Nabil wrote: hi all Is there a way to condition your search: -I have a form for four text boxes for search my Mysql... -I don't want to write 4 conditions and for SQL statements incase he decided not to search with all keywords (fields) - I have by example : name, lastname ,

[PHP-DB] Re: Multi search function (help)

Nabil wrote: David Robley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Nabil wrote: hi all Is there a way to condition your search: -I have a form for four text boxes for search my Mysql... -I don't want to write 4 conditions and for SQL statements incase he

Re: [PHP-DB] Re: Regular Expression

[EMAIL PROTECTED] (Andy Amol) wrote in news:[EMAIL PROTECTED]: hi, Thanks for the reply. I want to know how to include char - i.e a dash . I want to test for it. eg: COSC-3006. I should be able to test that string as valid. Also is there a way in which the form validation fails but when

[PHP-DB] Re: Fatal error: Call to undefined function: mysql_connect()

[EMAIL PROTECTED] (Tim) wrote in news:[EMAIL PROTECTED]: Setup: 2 servers, one with PHP 4.1.2 and no MySQL installed, the other has MySQL and PHP 4.1.2 Problem: I am attempting to connect to the MySQL server from the server without MySQL, but I get the error that shows in the subject.

[PHP-DB] Re: Hi I am new to PHP

[EMAIL PROTECTED] (Andy Amol) wrote in news:[EMAIL PROTECTED]: I have posted my problem at No: 33892 of this mailing list. I have received 1 reply. No: 33897 My exact problem with second file is as follows: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result

[PHP-DB] Re: Query Help!

[EMAIL PROTECTED] (Jerry) wrote in news:[EMAIL PROTECTED]: Hi Everyone, Happy Easter to you all. I have this query, reasoning for posting on this Mailing List is under it. :) SELECT `username` , `score` FROM round . $round_number . WHERE 1 ORDER BY `score` DESC LIMIT 0, 30 Is there

[PHP-DB] Re: Sort Order Description

[EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]: How can I have the explanation above a php table on a sort come out as something different than the sort coding? For example, the sort line below results in the following text above the sorted table: Data Set Sorted by

[PHP-DB] Re: Using results for next query

In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hi People, Am needing a little help on the following scenario. Selecting user_id from one table for all entries that match the required criteria. Now I want to use the user_id's that are returned by the previous query in

[PHP-DB] Re: passing parameter to function

In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hi, Say I have a script that knows the value of a variable $codename. The script contains a function that needs to know the value of $codename. What is the syntax for passing the parameter to the function? Example: the script knows

[PHP-DB] Re: Starters question: mysql PHP.INI

In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Dear all, I'm trying to get the horde applications working. The horde people have redirected my question to this list. Here it comes: How should I change the PHP.INI file in order to work with mysql session data, instead of files?

[PHP-DB] Re: resultset problem

In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... HI all, I am querying a db and getting the resultset, then to get out each individual field of the resultset (which is a single unique line all the time) as mysql_result($result2, 0, p_company). the problem is that if the actual

[PHP-DB] Re: php/mysql weblog - addnews function problems

In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... hey, I've been working on a PHP/MYSQL weblog and I've got most of it working apart from the adding new news function and a login section. I've set the form up but it is coming up with a few errors and the actual submitting of data

[PHP-DB] Re: PHP command not function after upgrade to 4.22

In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hi, I've upgrade the PHP 4.06 to PHP4 .2.2 in Redhat 9.0. after that, it was found the following script can't work well. the empty seems not function. Any one can help! ... If (empty ($A) . else ... Best

[PHP-DB] Re: Keeping the mailing list sain

In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hi guys, So that I don't drive members of the mailing list insane: In Outlook XP (2002), I want to enable the Out of office feature; what I don't want to do is have it reply to every message posted to the PHP mailing list. Does

[PHP-DB] Re: Display Mysql Result in drop down list

In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hi all, Right now I'm trying to retrieve one of the column tutor_name and display al the tutor's name in a drop down list. The problem now is, the drop down list only manage to display 1 record from that row instead of all tutor's

[PHP-DB] Re: Where's the mix-up?

In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Help: snip $sql = select id1 from GCN_Salesmen where username = '$PHP_AUTH_USER'; $user_id = mysql_query($sql) or die(mysql_error()); /snip Produces: You have an error in your SQL syntax near 'id #2' at line 1 snip $sql =

  1   2   >