Dear all,
i need help with my search query statement.. what is wrong with my code?
$word = split(" ", $keyword);
$num_words = count($word);
$word_str = "";
$criteria = "";
for ($i=0; $i<$num_words; $i++)
{
if ($i)
$word_str .= "and colN
On Wed, Dec 17, 2003 at 07:43:50PM -, Shaun wrote:
> I need to retrieve the data and column names from a single row in a table,
> i.e. 'SELECT * FROM Table WHERE Field_ID = 1'
Maybe something like this:
$result = mysql_query ("SELECT * FROM Table LIMIT 1",$db);
$my_row = mysql_fetch_array ($r
Hi,
I need to retrieve the data and column names from a single row in a table,
i.e. 'SELECT * FROM Table WHERE Field_ID = 1'
How can I get PHP to show the data and the column names? With reference to
my earlier post and the replies I can't use DESCRIBE in conjunction with
SELECT and I don't want
__
This communication is intended for the use of the recipient to whom it
is addressed, and may contain confidential, personal, and or privileged
information. Please contact us immediately if you are not the intended
recipient of this communication, and do not copy, distribute,
From: <[EMAIL PROTECTED]>
> > is there a PHP function that wil return the names of the columns for a
> > given table?
> http://www.php.net/mysq_list_fields
Note: The function mysql_list_fields() is deprecated. It is preferable to
use mysql_query() to issue a SQL SHOW COLUMNS FROM table [LIKE 'nam
Thanks for your response Frank, but this is still driving me nuts and
making me look like a moron at the same time (-:
This simplified query:
$query = "SELECT distinct convert(varchar(36),a.traineeID) INTO #tempdata1";
$query .=" FROM tblSignIn_trainee a";
$queryresult = MSSQL_QUERY($query,$cn) o
Hi Frank.
When does this table get deleted? when the DB connection closes or does one have to run a process to clear the temp tables?
Thanks,
Matt
On Tue, 2003-12-16 at 17:29, Frank M. Kromann wrote:
Hi,
Any table that starts with # is a temp table. You can use
create table #mytemp (...) o
> is there a PHP function that wil return the names of the columns for a given
> table?
You need to use an SQL function called DESCRIBE
http://www.mysql.com/doc/en/DESCRIBE.html
HTH
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://w
http://www.php.net/mysq_list_fields
hth
Jeff
"Shaun"
Hi,
is there a PHP function that wil return the names of the columns for a given
table?
Thanks for your help
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Actually I start a PHP script from the cron task that
runs every 5
minutes using PHP CGI executable version. I just
process upto 100
bounced messages per run avoid hogging the database
server and blocking
the POP3 mailbox for a long time, as this is not a
prioritary task.
---
Right, how do
Hi ,
Does anyone know what could be the reason for an 'request synchronization
error' ?
It occurs after calling ibase_fetch_assoc(). The same thing going on with
ibase_fetch_object() and ibase_fetch_row(). The resultset is being delivered
correctly by ibase_query(). The SQL-String (SELECT) returns
> I am looking to create a "comp-time" calculator of sorts using
> PHP/MySQL. I am still in the learning process of how all of this
> works. I want to be able to create a web interface where my employee
> can login and enter her comp-time as she works extra. I also want to be
> able to have an a
Welcome Rodrigo!
Start checking php.net
for object/clasess check out this mirror site of php.net
http://php.oregonstate.edu/manual/en/ref.classobj.php
By the way I don't know if we have from Brazil here...
M. Mamedov
- Original Message -
From: "Rodrigo Kochenburger" <[EMAIL PROTECTED]>
14 matches
Mail list logo