Re: [PHP-DB] Unified DB Query function

2002-07-01 Thread Alexander
-- Casey Allen Shobe [EMAIL PROTECTED] ha scritto nel messaggio [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Whoops, had an extra line in there. Should have been as follows: function db_query ($db_type, $db_conn, $db_query) { // Uncomment to debug //echo $db_query.'br'; if ($db_type ==

[PHP-DB] Dow name from Dow number

2002-07-03 Thread Alexander
Hello, in PostgreSQL I have this: select date_part('dow', timestamp_name), count(id) from table_name group by date_part('dow',timestamp_name); and I get a record count list grouped by week days. E.g.: ---+-- 0 | 123 1 | 16 2 | 45 ... | 6 | 9 I just want the day's

Re: [PHP-DB] find row id where i input

2007-01-26 Thread Alexander
The easiest way is to use mysql_insert_id(); - Original Message - From: bedul [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net Cc: [EMAIL PROTECTED] Sent: Saturday, January 27, 2007 12:14 AM Subject: [PHP-DB] find row id where i input i'm creating a big database using

Re: [PHP-DB] I can't solve the error in the code

2007-01-27 Thread Alexander
thank you. That appears to have solved it. - Original Message - From: Santiago Zarate To: Alexander Sent: Saturday, January 27, 2007 7:26 PM Subject: Re: [PHP-DB] I can't solve the error in the code if(!input) { // an error here... should be !$input or even

Re: [PHP-DB] Am I missing something?

2007-01-27 Thread Alexander
] To: Alexander [EMAIL PROTECTED]; PHP-DB php-db@lists.php.net Sent: Saturday, January 27, 2007 8:01 PM Subject: Re: [PHP-DB] Am I missing something? My first thought is that your values in your insert statement are not in quotes.. $insert = 'INSERT INTO domains ( picture, thumbnail ) values

Re: [PHP-DB] Am I missing something?

2007-01-27 Thread Alexander
always an error */ - Original Message - From: Alexander [EMAIL PROTECTED] To: PHP-DB php-db@lists.php.net Sent: Saturday, January 27, 2007 8:13 PM Subject: Re: [PHP-DB] Am I missing something? No change. I echod my insert statement and got : INSERT INTO domains ( picture, thumbnail

Re: [PHP-DB] Am I missing something?

2007-01-27 Thread Alexander
I'm using PHP 5, I'm running this off of my personal laptop so I downloaded ApacheTriad2 - Original Message - From: Stephen Johnson [EMAIL PROTECTED] To: Alexander [EMAIL PROTECTED]; PHP-DB php-db@lists.php.net Sent: Saturday, January 27, 2007 8:24 PM Subject: Re: [PHP-DB] Am I missing

Re: [PHP-DB] Am I missing something?

2007-01-27 Thread Alexander
Alright, I did that. I now get : INSERT INTO domains ( picture, thumbnail ) values( '', '') and no data entered. /* never take a hiatus from programming for a year */ - Original Message - From: Niel Archer [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Saturday, January 27, 2007

[PHP-DB] Autorunning a file

2007-10-09 Thread Alexander
Is there anyway to auto execute a PHP file? I'm working on a script that tracks activity and IPs of visitors, and then at a certain time daily emails me the results. Any idea of a way to do this? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Autorunning a file

2007-10-10 Thread Alexander
not be a visitor calling the index at the time I need it. I'll look into the cron job. Thanks again, Alexander - Original Message - From: Lasitha Alawatta [EMAIL PROTECTED] To: Alexander [EMAIL PROTECTED]; php-db@lists.php.net Sent: Wednesday, October 10, 2007 7:10 AM Subject: RE

Re: [PHP-DB] Is displaying image in php tough?

2007-10-11 Thread Alexander
I'm assuming that you have the image uploaded into a directory on the server. All you need to do is have the html tags: print img src='folderofsource/ . $image . ' - Original Message - From: Chris Carter [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Thursday, October 11, 2007

[PHP-DB] New with MySQL 3.23: Commands out of sync error

2001-04-19 Thread Alexander Fordyce
connect and pconnect -- sometimes it fails to connect for no apparent reason (about 1 time in 20, maybe (which is a lot))). Thanks in advance... Alex - - - - - - - - - - - - Alexander Fordyce [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-ma

[PHP-DB] New with MySQL 3.23: Commands out of sync error (2nd try)

2001-04-20 Thread Alexander Fordyce
lated is that I have been getting unpredictable results connecting to the database with mysql_connect and pconnect -- sometimes it fails to connect for no apparent reason (about 1 time in 20, maybe (which is a lot))). Thanks in advance... Alex - - - - - - - - - - - - Alexander Fordyce [EMAIL

RE: [PHP-DB] forget it

2001-04-20 Thread Alexander Fordyce
No problem... the other approach, along the lines of what you tried the first time, is to render the line breaks as HTML. PHP has a function to do that nicely... nl2br($str). -alex -Original Message- From: bryan [mailto:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 5:23 PM To:

RE: [PHP-DB] reword my question

2001-04-20 Thread Alexander Fordyce
Compile a cgi binary by leaving out the --with-apache directive, then you can use that to execute scripts from the command line and elsewhere. There's a good article about this at... http://www.phpbuilder.com/columns/darrell2319.php3 Have fun... alex -Original Message- From: Paul

RE: [PHP-DB] Can't get my head around this problem...

2001-04-24 Thread Alexander Fordyce
Looks to me like you'd be better off using an associative array, since associating the count with the day of the week is the whole point. How about... while (list($count, $day) = db_fetch_row($result)) $lastweek[$day] = $count; You'd have to tweak the logic of the rest of the script to use

[PHP-DB] DB design question (so maybe a little OT)

2001-09-07 Thread Alexander Deruwe
Hey all, I have 4 database tables, that each describe some sort of 'person' (transporting company, truck-driver, ..) and have almost exactly the same fields. Is this the best way of storing this, or does this make more sense: One table, with all the same fields + 1 extra, noting the type of

[PHP-DB] Re: [PEAR-DEV] Re: Common DB Abstraction Layer: Re: [PEAR-DEV] Adoption of Metabase

2001-11-21 Thread Alexander Merz
Now for the $15,000 question: does anyone else agree with this ? If PEAR::DB is not abstracting the database what is the purpose of such a library ? a) unifed API You havn't to think about the name of the command to send a query, connecting... b) it offers helpful functionality I.e. don't care

Re: [PHP-DB] More help with mysql -- solved (bizarre)

2003-02-27 Thread Alexander Mejenkov
It's not bizarre behaviour $result = mysql_query(SELECT * FROM SOME_TABLE) || die (Unable to execute SQL query); returns result of logical OR operation which is TRUE or 1 without || die(...) it returns valid MySQL resource Regards Sasha Evan Morris [EMAIL PROTECTED] wrote in message

[PHP-DB] Re: More help with mysql

2003-02-27 Thread Alexander Mejenkov
Supplied argument is not a valid MySQL result resource. This is absolutely correct because after $result = mysql_query(SELECT * FROM SOME_TABLE) || die(mysql_error()); variable $result contains result of boolean OR operation which in your case is TRUE or 1 in order to get valid MySQL result you

[PHP-DB] Mapping objects to tables: the actual database object

2003-03-03 Thread Alexander Deruwe
set up access Has anyone else been down this road? I'd appreciate feedback on this issue. Thanks! -- Alexander Deruwe AQS-CarControl -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Tables

2004-08-24 Thread Ustimenko Alexander
1) 5$ :) 2) It`s not for php.db list 3) May be: class field_commander { var $value; var $name; var ... function field_commander($label, $width, $name, ...) { if (isset($_POST[$this-])) { $this-echo_input(); } else {

[PHP-DB] Re: joined tables

2004-08-24 Thread Ustimenko Alexander
1) No. You must add third column that unically describes a person (primary key). E.g. there will more than one john smith. 2) And my first answer is the answer on your first question: table - fammem personidfamid memid 111 213 3 32 4 454

[PHP-DB] String Parsing/Escaping

2005-01-08 Thread Alexander Mueller
not need to escape the data manually. Now my question is, what would be a good/the best compromise respectively are there any other solutions for this particular issue? Thanks, Alexander PS: All this code is considered to run under magic_quotes_gpc OFF. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] String Parsing/Escaping

2005-01-09 Thread Alexander Mueller
Jochem Maas wrote: hi Alexander, interesting question regarding 'safety' v. readability v. speed - I'm sure you'll get different views depending on who you ask. Here is my take: Thank you Jochem! :) I rate speed as the least important issue - you can alway use a faster machine, get some more

Re: [PHP-DB] Duplicate record

2005-07-30 Thread Alexander Veremyev
requests to post data again). PS Furthermore, such use of GET and POST methods corresponds to their description in HTTP RFC's With best regards, Alexander Veremyev. Hallvard wrote: I have a page that posts data from a form to a mysql database. The problem is that if the user hits

Re: [PHP-DB] Duplicate record

2005-07-31 Thread Alexander Veremyev
early or add something). In any case second click on submit is explicit user action, which can not be considered as anything else then second submit. With best regards, Alexander Veremyev. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Alexander Schunk
i get returned but i dont get returned the second value pair thomas thorr. thank you yours sincerly Alexander Schunk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MySQL: Creating a database with

2010-05-18 Thread Alexander Schunk
sincerly Alexander Schunk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Mysql PDO statement with params in HAVING problem

2013-06-27 Thread Alexander Pletnev
Hi everyone, im new here, so please correct me if i created or formated topic incorrectly. I found a problem. I have a simple query for my needs: $stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as full_name,t.* FROM `specialists` `t` HAVING full_name like '%john%');

[PHP-DB] pg_query creates wrong query

2002-09-04 Thread Sascha Alexander Jopen
Hi there, I'm new to PHP, especially to the db-functions. I've got a problem querying my PostgreSQL server using pg_query. The Tables i'm working on contain colume names with uppercase letters. Working on those tables directly with psql, the client program delivered with postgresql, works like

[PHP-DB] Re: pg_query creates wrong query

2002-09-05 Thread Sascha Alexander Jopen
Thank you. I forgot to use the 's to force mixed-case. Know it works fine. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php