Hi again,
I am having trouble with updating. How do I tell php to update the database
at mid night instead of every time the browser is
refreshed? I have looked for it but can't find the info.
Also I thought session ID's were different between users. Is this true?
Thanks
Jennifer Downey
--
I'll give you all the short version of what I need and if it is enough for
you to help that would be great. I need to pull the last 10 updated topics
from a table and output them. However, the posts table lists each post and
then has a topic id. There is also a table of topics with topic id, title
I think this is what you're getting at:
">
or something like that so it would look like (in HTML)
Artist's Name First in list
Artist's Name second in list
Artist's Name third in list
if you select the first item in the list, the next page will produce:
$artistID = "23"
so yah... that
At 2:00 +0800 2/10/02, Jason Wong wrote:
>On Sunday 10 February 2002 00:21, Miles Thompson wrote:
>> Unless there has been a very recent development, MySQL doesn't support
>> transactions. Use PostgreSQL, DB, etc.
>
>The v4 series of MySQL does support transactions.
MySQL has supported transact
Hi Barry!
you can do it like this for example:
$query = "SELECT * FROM artist WHERE artist_name LIKE 'b%' ORDER BY artist
ASC";
$count = mysql_query("SELECT COUNT(artist) AS count FROM artist WHERE
artist_name LIKE 'b%'",$db);
$x = mysql_fetch_array($count);
$result = mysql_query($query) or
USe the count() function in mysql.
Like this:
$query = "SELECT count(artist) as howmany FROM artist
WHERE artist LIKE
'b%' GROUP BY artist ORDER BY artist
ASC";
$result = mysql_query($query) or die("Select
Failed!");
echo "Total Number Of Artists In
\"B\": ";
echo mysql_num_rows($resul
Thanks Rick, Now it works.
On Thursday 07 February 2002 03:04 pm, Rick Emery wrote:
> The following means you have not opened a link to your database.
> Concerntrate your efforts there.
>
> Warning: Supplied argument is not a valid MySQL-Link
> resource in /var/www/html/list.php3 on line 26
>
Here is the code I have tried... but no luck
$kw has been found in the resume of
$LastName, $FirstName http://madden.williamsen.net/recruiter/resumes/$filename\";>Resume
";
}
else {
echo "The keyword $kw was not found in the resume
$filename";
}
}
fclose($fd);
?>
How would I go about doing this.. I tried to search within a MS Word
document, but that didn't work too well, since Word is not ASCII formatted,
but on the other hand, I wasn't able to search a text document created in
notepad or exported from word to a text file.
Anyway how to do this?
--
P
Gee Jason You always come up with these great and inspiring replies!
Well, I figured it out how to search within a column, but not within a text
document.
But, This isn't the solution I really am looking for. I want the ability to
search within a text document that resides on the server in a sp
On Saturday 09 February 2002 07:35, Joe Van Meer wrote:
> Hi there. You bet you can have relationships between tables! You accomplish
> this by setting primary keys and foreign keys when you create you tables.
> When you assign a unique identifier to a table not only do you assign a
> name such as
On Sunday 10 February 2002 00:55, Barry Rumsey wrote:
> I have the following code:
> $query = "SELECT * FROM artist WHERE artist LIKE 'b%' ORDER BY artist
> ASC";
[snip]
> What I would like to know is how do I do a count on each result
> returned.e.g. Benny(4) , Bill(10)
Try:
$query = "SELECT
On Sunday 10 February 2002 00:21, Miles Thompson wrote:
> Unless there has been a very recent development, MySQL doesn't support
> transactions. Use PostgreSQL, DB, etc.
The v4 series of MySQL does support transactions.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Without lo
On Sunday 10 February 2002 00:58, Todd Williamsen wrote:
> What I am doing is user inputs their contact information, then copies and
> pastes text and also uploads a formal document, which the location is
> stored in the database.
>
> Now, the text that gets pasted into the text field is then stor
What I am doing is user inputs their contact information, then copies and
pastes text and also uploads a formal document, which the location is stored
in the database.
Now, the text that gets pasted into the text field is then stored into the
database for search purposes.
This is the problem...
you must first connect to the mysql database,
for example
$dbhost = "localhost";
$dbuser = "DATABASE USER";
$dbpass = "DATABASE PASSWORD";
$database = "DATABASE NAME";
@mysql_connect($dbhost, $dbuser, $dbpass) or die ("Deze pagina is
tijdelijk offline.");
@mysql_select_db($database)
I have the following code:
$query = "SELECT * FROM artist WHERE artist LIKE 'b%' ORDER BY artist
ASC";
$result = mysql_query($query) or die("Select Failed!");
echo "Total Number Of Artists In \"B\": ";
echo mysql_num_rows($result);
echo "";
if (mysql_num_rows($result)) {
echo "";
echo "Artists";
Unless there has been a very recent development, MySQL doesn't support
transactions. Use PostgreSQL, DB, etc.
Miles Thompson
At 09:51 AM 2/9/2002 +0300, Hayan Al Mamoun wrote:
>Hi, How can I maintain MySQL transactions with PHP
>
>Best Regards
>Hayan
>
>
>--
>PHP Database Mailing List (http:/
On Sat, Feb 09, 2002 at 01:10:58PM +0100, Jaros?aw Jankowski wrote:
>
>
> Theodore D Boardman wrote:
>
> > Greetings!
> >
> > As far as I can tell from the documentation, the OCI8 driver supports Oracle
> > 8. However, on the ADODB site, they mention that the OCI8 driver supports
> > Oracle 8/9
Andy wrote:
> Hi there,
>
> how is it possible to copy rows from more then one table into a temporary
> table?
>
> I have 250 city tables named after the country e.g: ca_cities. Now the user
> has choosen stuff from
> lets say ca and gm. I want to collect the data into a temp table and then
> q
Theodore D Boardman wrote:
> Greetings!
>
> As far as I can tell from the documentation, the OCI8 driver supports Oracle
> 8. However, on the ADODB site, they mention that the OCI8 driver supports
> Oracle 8/9.
>
> Can someone clarify what the status of support for Oracle 9i is in PHP? I
> need
what would you like todo?
explain further
Jeroen
- Original Message -
From: "Hayan Al Mamoun" <[EMAIL PROTECTED]>
To: "PHPList (E-mail)" <[EMAIL PROTECTED]>
Sent: Saturday, February 09, 2002 7:51 AM
Subject: [PHP-DB] Maintain MySQL Transactions
> Hi, How can I maintain MySQL transactio
hello,
i think you could not realize that with php and sessions.
Because you can not read the session from a visitor.
or ?
Jeroen
- Original Message -
From: "Hayan Al Mamoun" <[EMAIL PROTECTED]>
To: "PHPList (E-mail)" <[EMAIL PROTECTED]>
Sent: Saturday, February 09, 2002 7:52 AM
Subje
23 matches
Mail list logo
