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

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] MySQL: Creating a database with

sincerly Alexander Schunk -- 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

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

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

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

Re: [PHP-DB] Autorunning a file

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

[PHP-DB] Autorunning a file

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] I can't solve the error in the code

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?

] 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?

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?

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?

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

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

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] Duplicate record

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] String Parsing/Escaping

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

[PHP-DB] String Parsing/Escaping

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

[PHP-DB] Re: Tables

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

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] Mapping objects to tables: the actual database object

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

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

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

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] Re: pg_query creates wrong query

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

[PHP-DB] pg_query creates wrong query

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] Dow name from Dow number

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

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

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

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

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

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

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] New with MySQL 3.23: Commands out of sync error (2nd try)

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

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

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

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

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