Hi,
I have many databases, each full up of more than 20 tables. I need to
perform search based on search criteria entered by users.
Does anyone know effective way of performin this task?
Waiting for your comments.
Regards,
Muhammed Mamedov
--
PHP Database Mailing List (http://www.php.net/)
You should have seen the SELECT stmt being outputed when debug is enabled.
If you saw nothing, then the connect() failed. Make sure you turn on error
reporting with
error_reporting(E_ALL);
before you connect.
-* Nadine *- [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Thanx, I
Hi I realy need help hier
I have a aaray of months
$lang['months'] = array
( 1 = Januari, 2 = Februari, 3 = Maart, 4 = April, 5 = Mei,
6 = Juni, 7 = Juli, 8 = Augustus, 9 = September, 10 =
Oktober,
11 = November, 12 = December
);
and a function
function showMonths2($montharray)
{
$maand =
There are fulltext search engines like mnoGoSearch
(http://mnogosearch.org) that can index database tables like
filesystems. You could then search accross all of your databases -- and
you could also include results from mnogo spidering in that search if
appropriate. This might be a good
Yes!
That worked! (It was returning the same field values not column names, my mistake).
Now it returns what it should return. Onwards to the next snafu!
Thanks!
Ryan Jameson (USA) [EMAIL PROTECTED] wrote:
One thing may be that you need to do a fetch to increment the result row
Thanks in advance for reading this:
I am trying to take a query based on user input and selectively output
fields to a table.
Heres the query code:
snip - snip
$query_result = mysql_query($query);
while ($field = mysql_fetch_array($query_result))
{
$returned_rows =
Thanks in advance for reading this:
I am trying to take a query based on user input and selectively output
fields to a table.
Heres the query code:
snip - snip
$query_result = mysql_query($query);
while ($field = mysql_fetch_array($query_result))
{
$returned_rows =
Sorry for accidentally posting twice:
I wanted to point out a typo.
At the bottom I meant advancing the array not table in regards to next()
On Wed, 25 Feb 2004 11:12:10 -0600
PHELPS, SCOTT [EMAIL PROTECTED] wrote:
Thanks in advance for reading this:
I am trying to take a query based on
On Thursday 26 February 2004 01:04, PHELPS, SCOTT wrote:
The problem is that it only prints one name. Also next() doesn't seem to
be advancing the table so I am getting duplicates of the one name it does
print to the table
For starters, you're using next() incorrectly. It returns a value.
Scott Phelps wrote:
Thanks in advance for reading this:
I am trying to take a query based on user input and selectively output
fields to a table.
Heres the query code:
snip - snip
$query_result = mysql_query($query);
while ($field = mysql_fetch_array($query_result))
{
This is an great aproach to solve your problem but i suggest some things to
obtain an better performance on your apps.
See my comments bellow
On Wednesday 25 February 2004 14:24, Justin Patrin wrote:
Scott Phelps wrote:
Thanks in advance for reading this:
I am trying to take a query
When returning to the main page of my script sometimes I'll get the
following error:
Warning: mysql_fetch_array(): 8 is not a valid MySQL result resource in
/home/nick/http/search/includes/main.inc on line 13
This happens only AFTER the first element in the resource has been
processed. Here's
When returning to the main page of my script sometimes I'll get the
following error:
Warning: mysql_fetch_array(): 8 is not a valid MySQL result resource in
/home/nick/http/search/includes/main.inc on line 13
This happens only AFTER the first element in the resource has been
processed.
Error trapping is not really relevant here as the server is properly
configured so the errors are going to show up in either event. In fact,
using the die() function on my server just makes thing worse. In any
case, the var_dump was a good idea as I was able to find out that what
is happening
Hi there. I want to save a variable (its structure and data) in MySQL.
I know the function serialize(mixed value), wich generates a storable
representation of a value. This storable representation has characters like
{ and : (when talking about arrays). So, how can I store this in MySQL?
Wich
On Wed, 25 Feb 2004 14:56:53 -0400
Luis M Morales C [EMAIL PROTECTED] wrote:
Thank you so much Justin and Luis. You guys are awesome.
You both helped me tremendously!
BTW, I figured out a way to make the tables show the $value results in alternating
colors.
I just use a bitwise AND to test
Daniel Crespo wrote:
Hi there. I want to save a variable (its structure and data) in MySQL.
I know the function serialize(mixed value), wich generates a storable
representation of a value. This storable representation has characters like
{ and : (when talking about arrays). So, how can I store
Sorry, I didn't cut that right:
Here it is:
table class=results_inner
?php
foreach ($returned_rows as $key = $value)
{
if ($key 1)
{
echo trtd class='results_blue'.$value['lastname'].,
.$value[firstname]./td/trbr;
;-)
table class=results_inner
?php
foreach ($returned_rows as $key = $value)
{
echo trtd class='.
($key 1 ? 'results_blue' : 'results_white').'.
$value['lastname'].,
.$value[firstname]./td/trbr;
}
What you propose makes sense of course, but no matter what I do, where I
send the errors, even to the system log, the mysql_fetch_array () error
is the only one that shows up. It would appear that either the query is
failing is some way that PHP isn't recognizing, or the fetch isn't
working
X-Mailer: Sylpheed version 0.9.8claws (GTK+ 1.2.10; i686-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
On Wed, 25 Feb 2004 15:39:17 -0800
Justin Patrin [EMAIL PROTECTED] wrote:
;-)
table class=results_inner
?php
22 matches
Mail list logo