Webmaster Forum / PHP / Database Access / September 2007

Thats field not table -
I just want to see if a particular field exists in a specified table and
for the method to work reliably on as many mySQL versions as possible.
Obviously the most efficient would be best  - I can't see anything in the

My problem is I want to compare every word in large paragraph with
every row in database.But this technique use to much process and slow
down query performance.e.g.
My paragraph:

Following script stops after a while (appr. 1 minute) without an error-
message:
// Loop 12 Times:
  $conn=odbc_connect("database1","","");

I am new to this SQL.  Can someone answer this question for me?
1.   Given the following schema of an employees table:
*employees (*
*  empid    integer primary key, -- employee id number*

I have inherited a system for which I not only need to maintain php code,
but also server as the system administrator.
I need to run some blog software and I need to know how to discover what my
db_host is set to or how to set my db_host.

I have problem with my php/sql code because id (auto inc., primary) row.
(
   $sql =  "INSERT INTO ".$_CONF['tprefix']."schedule_scores VALUES ";
   $sql .= "('NULL','$newdate','$newtime','$newlocation','$team1_id',";

Some of my php files start with <?php session_start(); ?>
Up to recently this was no problem. Recently my provider upgraded from
php4 to php5. From then I get this message:
Warning: session_start() [function.session-start]: SAFE MODE

I have a table with a unique constraint on two integer columns.
Works fine, but one of the two columns can be null and then the
constraint does not work.
1    2    : OK

I have a table with an ENUM row.
If I insert a new row (using PHP5, MySQL5 and PDO for database
connections) with a value that is not in the ENUM list, no error, no
warning, no exception ... The row is inserted but the field where

I'm having difficulty getting data out of MS SQL Server via a PHP
database call.  When I look in the database, it crashes on the line
where there is a single quote in the database.  I've seen several
articles about addslashes/stripslashes and str_replace for MS SQL.

I am having a problem with a search.  Below is the code:
$colname_rs_product = "-1";
if (isset($_GET['search'])) {
 $colname_rs_product = (get_magic_quotes_gpc()) ? $_GET['search'] :

Here's the problem:
I have meeting minutes that need to be paged through via my website.  I have
created a developer server on my local machine and when I run the PHP code
against the MySQL table that I imported from my ISP's website everything

I'm new to the world of programming and all, what I would like to know
is how to create MySQL databases and resources that would help an
aspiring programmer like myself at getting the hang of the whole world
of MySQL, I love the idea of writing dynamic websites and such are ther

I've written my first search script and I have 2 problems. First, I'm
getting duplicate results because I have identical questions related
to different topic_id's (aka categories). Second, if a search term
isn't found, it's

I have started using the new mysql_* extensions.  Here is the code I am
trying to run:
    $temp2 = "SELECT * FROM assignments2 WHERE daydue < '247' && progress !=
'100'";