?
Any Help would be greatly appreciated,
Ian McGhee
Email: [EMAIL PROTECTED]
.)
3. Use single, rather than double quotes for dba_open() parameters. In my
original test, I used double quotes (below) and, of course, \t was
interpolated!
Cheers,
Ian
(New Year's resolution - RTFM!)
Ian [EMAIL PROTECTED] originally wrote:
Hi all, Season's Greetings!
I am testing my PHP
identifier
resource in c:\apache\htdocs\admin\dba.php on line 7
Ian
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
the results I need from my Win32 testbed. I
wonder why DB3 fails - perhaps it's a bug after all, as I mentioned in my
original post
Thanks for your patience,
Ian
Bastien Koert [EMAIL PROTECTED] wrote:
make sure in the general tab that the read only checkbox is NOT checked
bastien
From: Ian
): Driver initialization failed
for handler: db3: Permission denied in c:\apache\htdocs\admin\dba.php on
line 1
However, this command does create a zero-byte file -
C:\Apache\htdocs\test.db.
Ian
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
for your help,
Ian
PS This appears to be a fixed bug (http://bugs.php.net/bug.php?id=28122) but
I still get permission denied. Why?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
/usr/local/apache2/html/poems/browse.php on line 15
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
thnx ya'll... :)
On Mon, 2004-11-08 at 17:52, Bastien Koert wrote:
Check the mysql website. Have you upgraded from 4.0x to 4.1 recently. If so
you need to update the client libraries that come with mysql. There are
significant protocol changes from 4.0x to 4.1.
Bastien
From: ian
returned $Outer rows!/b;
}
else
echo selection failedbr;
?
It is running in and apache server with php set up using the .dll method.
Ian McGhee
Junior Analyst Programmer
Richard Lawson Autologistics Group
Telephone: 01382 560259
Email: [EMAIL PROTECTED]
J B Cartwright, G D Frost
Hi,
I am not sure if my issue can be partially solved by a good database
design or that all stands or falls with the application.
If I have a bunch of locations in a table and I want to describe a
route between a number of these locations, what's the best way to do
it, considering that it must
On 1 Dec 2003, at 21:11, [EMAIL PROTECTED] wrote:
I'm just getting into PHP, and have found that as a PHP code editor,
Dreamweaver works pretty well (with the extension I installed). My
question
is this, whenever I save an include file with the .inc extension, all
of
the
color coding goes away,
', '$authors', '$movies', '$rolemodel', '$place', 0, 'y' , 'y');
mysql_query($SQLQuery,$link);
?
ian
- Original Message -
From: SAGERAT [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 12:17 AM
Subject: [PHP-DB] set password on a page
How do I set up password on a page so that only restricted people can open
it?
--
PHP Database Mailing List
Ok I'm trying to write this function to up date some fields in my database
so i'm grabbing some info from a query and throwing it into an array (with
mysql_fetch_array).
one of the values i'm puting into that array is the table id. I'm then
comparing the table id with the value of $i in my loop.
on each page load. Otherwise, they can easily change which team they're
using.
Ian Fingold wrote:
Sorry I don't think I explained very well... heres my situation...
I have a mysql database set up... I have a user table with 2
fields...team_name and fant_week.
What I want to do is, depending
I'm trying to build a query string for one of my links.. for example...
fant_stnd3.php?week=1team=fun%20team
I need to be able to grab the values of 'week' and 'team' from an array, I
can do that no problem, but when the code runs it cuts off the value if
there is a space in the string. so
=1team=silly team
but again, my problem is that it's cutting off the team value when there is
a space in the string..
Gürhan Özen [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Sun, 2003-06-01 at 22:26, Ian Fingold wrote:
I'm trying to build a query string for one of my links
try mysql_fetch_array... mysql_fetch_row is a crappy old function.
- Original Message -
From: Peter Westergaard [EMAIL PROTECTED]
Newsgroups: php.db
To: [EMAIL PROTECTED]
Sent: Monday, January 07, 2002 8:32 AM
Subject: Pulling a long list of data stalls PHP
Hi,
I'm
to use a desc, you need an order by
Barry Rumsey [EMAIL PROTECTED] wrote in message
001001c197d6$ceb70160$0100a8c0@weizmain">news:001001c197d6$ceb70160$0100a8c0@weizmain...
$query = SELECT * FROM xp_sings,xp_artist,xp_songs WHERE
xp_artist.artist_id = xp_sings.artist_id AND xp_sings.song_id =
order by tableId desc limit 1
Necro [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
What query can I use to select the last row in a table??
Andrew
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
look at the mysql_insert() function and then
look at the comments for the function mt_rand()
Pjc [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I need a script that will populate a MySQL database with mostly random
data
(without crashing my box) with fields
also, to get existing vals to show in the select as default,
select name=colorz
while($row=mysql_fetch_array($result)){
$selected=($row[ID]==$ID)?selected:;
echo option value=' . $row[ID] . ' $selected . $row[name] .
/option\n;
}
/select
the value can be in single quotes also, altho i dont think
mysql is better for quick and lightless overhead than postgress, less
functionality too. overall, if you sit and tune it, you can get postgress to
run better, but who has the time.
Andy [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi there,
I am
there is a very cryptic function for getting the session id:
session_id()
if you pass it a value, it will also set the id
Chris Payne [EMAIL PROTECTED] wrote in message
000c01c184ef$53abc220$0200a8c0@chris">news:000c01c184ef$53abc220$0200a8c0@chris...
Hi there everyone,
I know how to get the
$table = some_junk;
$resultset=mysql_query(select blah ,blah from $table);
Russ Michell [EMAIL PROTECTED] wrote in message
news:SIMEON.10112131209.A@k1c. anglia.ac.uk...
Hi there everyone:
I have a genericphp/MySQL search+retrival mechanism. Generic in that it
takes table names,
fieldnames
Hello, wonder if anyone can debug this script.
I copied it from an example in a book.
There is a .php file and a .inc file
This is the .inc file:
?php
//common_db.inc
$dbhost = 'localhost';
$dbusername = 'root';
$dbuserpassword = '';
$default_dbname = 'mysql';
$MYSQL_ERRNO = '';
$MYSQL_ERROR
'A %' the' at line 1
--
Ian Evans
Digital Hit Entertainment - News and Information
http://www.digitalhit.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail
the same syntax error. Our hosting company is
using MySQL 3.22.32 if that's any help.
--
Ian Evans
Digital Hit Entertainment - News and Information
http://www.digitalhit.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e
(Title, 3, 255)
when Title like 'An %' then substring (Title, 4, 255)
else Title
end
That worked like a charm, yet MySQL doesn't seem to accept that. Any
solutions or advice?
--
Ian Evans
Digital Hit Entertainment - News and Information
http://www.digitalhit.com
--
PHP Database Mailing List (http
Petr Tuma wrote:
select *,(case when Title like 'The %' then substring (Title, 5, 255)
ETC.
Alas, MySQL doesn't like that syntax either. :(
--
Ian Evans
Digital Hit Entertainment - News and Information
http://www.digitalhit.com
--
PHP Database Mailing List (http://www.php.net
Hi,
I have this code after a user submits a form with name, description and
image file upload fields:
images/people/preview is simply a unix link to /tmp/phptempimg-ian.grant
The problem is, when this script is run, the image show is that from the
previous operation. If you refresh the page,
(); directly after your $result =
mysql_query($query); operation (where $query is an INSERT query) to pull the
id value you have just auto inserted back out.
Ian.
Manual page: http://www.php.net/manual/en/function.mysql-insert-id.php
Crosswalkcentral [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED
= $row[0];
return $id;
}
Ian.
Ian Grant [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
mysql_insert_id([resource link_identifier]) returns the value of the
auto_increment field for the previous INSERT query. It will return 0 if
there is not an auto_i
of the textarea tag would be
better, considering the users are not going to be HTML-proficient.
However, I cannot seem to find anything like this that doesn't cost loads.
Does anyone know of anything similar?
Thanks,
Ian Grant.
--
--
PHP Database Mailing List (http://www.php.net
Yes, thank you, this works!
Ian.
Paul Burney [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
on 8/10/01 7:50 AM, Ian Grant at [EMAIL PROTECTED] wrote:
I've got a simply search form, on my site using PHP and MySQL.
It writes a SELECT query usi
and writes nothing for the query, so it ends up like WHERE ()
Any pointers?
Thanks,
Ian.
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
=mysql_num_rows($result);
$i=1;
while ($array = mysql_fetch_array($result)) {
print (td
align=\center\.$array[Image].br.$array[Name]./td\n);
if (is_int($rows / $i)) {
print (/tr\ntr);
}
$i++;
}
Thanks,
Ian.
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail
Yeah, but if I had 31,
I'd want 6x5 and then 1 over, or something
Hugh Bothwell [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Umm... 31 entries, 1 x 31...
You might be better to choose a standard width and pad the last row with
empty cells.
I
in advance.
Ian.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Thanks, Thor and Cal ; )
"Ian" [EMAIL PROTECTED] wrote in message
99eaaj$njn$[EMAIL PROTECTED]">news:99eaaj$njn$[EMAIL PROTECTED]...
Please help me !!!
Description :-
Server 1 is installed MySQL which locate
quot;;
etc.
What else should I know or I miss, to make it function? Any good idea to do
that?
Thanks in advance,
Ian.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
-01-02(from my own calculation). Same as case 1, I
would like to display all data from Test table where expired_day plus
posting_date is before the current date.
My display result should be zero.
Any good solutions or suggestions for Case 2?
Thanks in advance.
Best Regards,
Ian.
--
PHP
42 matches
Mail list logo