?
Any Help would be greatly appreciated,
Ian McGhee
Email: [EMAIL PROTECTED]
of doc_root in php.ini? Makes no
difference.)
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]> or
7;
and 'flatfile' handlers give me 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 t
t a valid DBA identifier
resource in c:\apache\htdocs\admin\dba.php on line 6
Warning: dba_close(): supplied argument is not a valid DBA 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
ation 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
b3") // for example
What am I doing wrong please?
Thanks 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
; Bastien
>
> >From: ian <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: [EMAIL PROTECTED]
> >Subject: [PHP-DB] MySQL problem..
> >Date: Mon, 08 Nov 2004 17:02:53 +
> >
> >Any body met this error?
> >Warning: mysql_connect(): Cli
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: http://www.php.n
}
else
echo "selection failed";
?>
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 and R J Hu
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 b
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,
, '$bodytype', '$eyecolour', '$height', '$weight',
'$facialhair', '$hobbies', '$interest', '$aboutme', '$profession', '$food', '$music',
'$tvshows', '$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 (http:
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. N
nd fetch the team name
> 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
d in and his team is called "silly team" the
link will look like this
fant_stnd3.php?week=1&team=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
I'm trying to build a query string for one of my links.. for example...
fant_stnd3.php?week=1&team=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 instea
option, as it will mess up other applications
that are dependent on the ldap server. The entries need to be made in the
server, and they must have a null value if there is nothing to go in.
It was working fine with openldap 1.2.13, but with openldap 2.x, its a no go,
and it is causing a lot
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
if you look closely at your code (instead of posting yet another silly
message on this board) you'll notice that the first has an onclink
event..i am not presently aware of any such event.
to all you newbies out there: look over your code, check php.net, check the
comments sections, if ALL els
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 additi
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 field
$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,
> f
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
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 wo
also, to get existing vals to show in the select as default,
while($row=mysql_fetch_array($result)){
$selected=($row["ID"]==$ID)?"selected":"";
echo "" . $row["name"] .
"\n";
}
the value can be in single quotes also, altho i dont think quotes matter
unless you use opera or some other wierdass b
is anybody using procs in sql server? has anyone been able to get a return
parameter? can you use mssql_query, or only odbc?
is this just a BIG FAT php limitation???
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-ma
t;password",5);
if (!odbc_execute($stmt, &$parms)) die("odbc_execute failed");
is it possible to change this to both: explicitly pass the parameters by
name and pass the return value to a variable?
thx
Ian Ferger
--
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]
and likely
> this is the code used in the book:
>
http://www.wrox.com/Books/Book_down.asp?section=11_3&isbn=1861003730&subject
=&subject_id=
>
> this in case you typed it from the book yourself, this download could
> eliminate typo's.
>
> > > > >-
>then this is the short way:
> > >
> > >$user = "your_username_for_the_database";
> > >$pass = "your_password_for_the_database";
> > >
> > >$con = mysql_connect("your_host", $user, $pass);
> > >
> > >if(!$con) {
> > >
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:
the .php file is like this:
";
}
?>
Sorry about poxy formatting, hope it is legible.
I seem to have a problem passing the database to the db
titles order
> by sort_col;
Argh, that still produces 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
then
substring (title, 5, 255) when title like '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-
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 (ht
55)
when Title like 'A %' then substring (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 Info
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, the
ch_row($result);
$id = $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 quer
(); 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 PRO
Okay thanks, I'll have a look at that.
I am right in thinking that ActiveX controls can work in Netscape, as long
as Internet Explorer (>4.0) is installed?
Ian.
John Pickett <[EMAIL PROTECTED]> wrote in message
001501c1269f$c977ed20$4c6146a6@notebook">news:001501c1
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/)
To unsubscri
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.
>
ails
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]
last row with
> empty cells.
>
> "Ian Grant" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Hi,
> >
> > Can anyone help me with this - I have a database of people, that I want
to
> > print into an HTML t
=mysql_num_rows($result);
$i=1;
while ($array = mysql_fetch_array($result)) {
print ("".$array["Image"].">".$array["Name"]."\n");
if (is_int($rows / $i)) {
print ("\n");
}
$i++;
}
Thanks,
Ian.
--
--
PHP Database Mailing List
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 M
Thank you 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]
ster";
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]
coding to select the test field and display it in HTML page, output likes,
This is a testing messages:- 1. MSG A. 2. MSG B. 3. MSG C.
How to display $test in the requested format?
Thanks in advance.
Best Regards,
Ian.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e
d_day.
> >
> > Let say,
> > posting_date = 2000-12-20
> > expired_days = 14 days
> >
> > So my due date is 2001-01-02(from my own calculation). Same as case 1, I
> > would like to display all data from Test table where expired_day plus
> > post
s
So my due date is 2001-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 Rega
51 matches
Mail list logo
