--
"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.'';
if ($db_type == 'odbc
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 nam
The easiest way is to use mysql_insert_id();
- Original Message -
From: "bedul" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
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 mysql.
after i
I'm writing a script for uploading into a database urls for a picture and its
thumbnail, but for some reason when I test it out the page doesn't load, and
not even the errors appear. Please help, here's the code:
Enter url of large picture:
Enter url of thumbnail:
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 eve
hen Johnson" <[EMAIL PROTECTED]>
To: "Alexander" <[EMAIL PROTECTED]>; "PHP-DB"
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..
x27;s always an
error */
- Original Message -
From: "Alexander" <[EMAIL PROTECTED]>
To: "PHP-DB"
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
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"
Sent: Saturday, January 27, 2007
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:
Sent: Saturday, January 27, 2007 8:29 PM
Subject: Re
They should have data. here's the form code:
function write_form() {
echo "";
echo "Enter url of large picture: name='picture' />";
echo "Enter url of thumbnail: name='thumbnail' />";
echo "";
echo "";
}
I've done everything excatly how my PHP boo
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: http://www.php.net/uns
I realized that there may 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]>;
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 ""
- Original Message -
From: "Chris Carter" <[EMAIL PROTECTED]>
To:
Sent: Thursday, October 11, 2007 10:16 AM
Subject: [PHP-DB] Is displaying image in php t
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 {
$this->echo_entered
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
only escapes it once. THIS however is at the
same time the big advantage of the third code, because the developer
does 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?
Than
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
ma
without any side effects (also without 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.
T
ion (change some data posted 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, visi
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
sincerly
Alexander Schunk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ng 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 PROTECTED]
--
PHP Database Mailing List (http://www.php.n
nother problem which may be related 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
- - - - - - - - -
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
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: Pau
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
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 pe
>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
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
> 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
nd
let that class 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
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%'");
$s
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 ex
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
34 matches
Mail list logo
