Chris Payne wrote:
I'm using Booleans in my searches (New to it) but it works perfectly
on my
local 3.23 version of MySQL, but on the main server which uses version 4 of
MySQL I get an error so there's an error in my Syntax. Here's what I
currently use:
[snip]
Bob Lockie wrote:
I use $row = fetch_row_object, array_push($row) and I want to manually
insert a row at the end of my array to indicate if there are more rows.
Is there a way to create a row object?
class row
{
var $morerows = 'Yes';
}
$more = new row;
array_push($more);
about all there is
The database queries all the sources at night after everyone has gone home. That means
the data was current as of yesterday. This little snippet below returns yesterday's
date, except that the first day of the month returns 0 for the day. Now, I know why
this is happening, but I can't find out
accidentally replied only to karen.
The database queries all the sources at night after everyone has gone
home. That means the data was current as of yesterday. This little snippet
below returns yesterday's date, except that the first day of the month
returns 0 for the day. Now, I know why
I am currently writing code to write and read data to a Microsoft SQL 2000
database. At the same time I have sessions being recorded to another SQL
2000 database. Could these two database connections being open at the same
time cause an access violation by php on a windows 2003 server?
Thanks,
Hi,
I'm trying to figure out how to write a MySQL query that will return the
highest primary key a table.
Thanks,
Ms. Jimi Thompson, CISSP
Manager, Web Operations
Cox School of Business
Southern Methodist University
What kind of peace do we seek? Not a 'Pax Americana' enforced
Thompson, Jimi wrote:
I'm trying to figure out how to write a MySQL query that will return the
highest primary key a table.
1) Why?
2) SELECT MAX(id) FROM table
3) If you're trying to find the key of the last row inserted to an
auto_increment column, use mysql_insert_id() or LAST_INSERT_ID() in
Is the primary key field numerical? If so then you can try to use an sql
statement like: SELECT MAX(field) AS max_field FROM table GROUP BY max_field
Chris
Jimi Thompson [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
I'm trying to figure out how to write a MySQL query that will
That depends on the SAPI you are using. With CGI or FastCGI there is no
problem but with ISAPI or Apache module you might get problems, as the
DBLIB library used to build the extension is not thread safe.
- Frank
I am currently writing code to write and read data to a Microsoft SQL
2000
You need to compile PHP with MySQL support. There is a php-mysql.rpm
package, but I'm not sure if it will work with MySQL 5. You might just
have to recompile PHP (but probably not).
Cole
Iain Wiseman wrote:
Cole S. Ashcraft wrote:
They are at http://dev.mysql.com/downloads/mysql/5.0.html.
Iain
10 matches
Mail list logo
