Ad:

PHP Discussion Thread
Unsolved
Views: 2601

Nov 16th, 2006

is there something wrong with my SQL statement?

Expand Post »

i don't see anything wrong with it... what's the deal? this is the results page that displays the results of a search query.
Parse error: parse error in ../../../../merchandise/testreg/results.php on line 21

php Syntax (Toggle Plain Text)
    @ $db = mysql_connect("localhost", "apache", "R3GP@SS!");
 
    if(!$db)
    {
    echo "Error: Could not connect to the database. Please try again later.";
    exit;
    }
 
    mysql_select_db("registry_DB, $db);
    $sql = mysql_query("SELECT brideLname, groomLname FROM my_search_table WHERE brideLname LIKE '%". $lname ."%' OR groomLname LIKE '%". $lname ."%'") or die(mysql_error();//<--- LINE 21 (entire SQL statement is on one line
    $result = mysql_query($sql);
    $num_result = mysql_num_rows($result);
 
 
    echo "Number of matches: ". $num_result ."<br />";
 
    @ $db = mysql_connect("localhost", "apache", "R3GP@SS!");

    if(!$db)
    {
    echo "Error: Could not connect to the database. Please try again later.";
    exit;
    }

    mysql_select_db("registry_DB, $db);
    $sql = mysql_query("SELECT brideLname, groomLname FROM my_search_table WHERE brideLname LIKE '%". $lname ."%' OR groomLname LIKE '%". $lname ."%'") or die(mysql_error();//<--- LINE 21 (entire SQL statement is on one line
    $result = mysql_query($sql);
    $num_result = mysql_num_rows($result);


    echo "Number of matches: ". $num_result ."<br />";

Similar Threads

Syntax error in "like" in sql statement in ASP.NET
Question about SQL statement in MS SQL
SQL statement error in ASP.NET
sql statement in Visual Basic 4 / 5 / 6
run sql statement in asp in ASP

boo_lolly

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

35 posts
since Nov 2006

Permalink

Nov 16th, 2006

Re: is there something wrong with my SQL statement?

You are missing a ')'

(Toggle Plain Text)

die(mysql_error())

Last edited by stymiee; Nov 16th, 2006 at 12:25 pm.

stymiee

Moderator

Reputation Points: 161

Solved Threads: 38

He's No Good To Me Dead

Offline

1,422 posts
since May 2006

Permalink

Nov 16th, 2006

Re: is there something wrong with my SQL statement?

you're the man...

Click to Expand / Collapse Quote originally posted by stymiee ...

You are missing a ')'
(Toggle Plain Text)
die(mysql_error())
die(mysql_error())

boo_lolly

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

35 posts
since Nov 2006

Permalink

Nov 16th, 2006

Re: is there something wrong with my SQL statement?

the tables don't exist yet, but the database does... i get the following error when i click the submit button for a search. it seems to be combining my database name AND my table name....

Table 'registry_DB.my_search_table' doesn't exist

my database name is 'registry_DB'. my table name is 'my_search_table'. what's the deal here?

Last edited by boo_lolly; Nov 16th, 2006 at 1:49 pm.

boo_lolly

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

35 posts
since Nov 2006

Permalink

Nov 16th, 2006

Re: is there something wrong with my SQL statement?

That's just good error reporting. It helps that it is so specific as to avoid any confusion with similar table names in other databases.

stymiee

Moderator

Reputation Points: 161

Solved Threads: 38

He's No Good To Me Dead

Offline

1,422 posts
since May 2006

Permalink

Nov 29th, 2006

Re: is there something wrong with my SQL statement?

Click to Expand / Collapse Quote originally posted by boo_lolly ...

i don't see anything wrong with it... what's the deal? this is the results page that displays the results of a search query.
Parse error: parse error in ../../../../merchandise/testreg/results.php on line 21
php Syntax (Toggle Plain Text)
    @ $db = mysql_connect("localhost", "apache", "R3GP@SS!");
 
    if(!$db)
    {
    echo "Error: Could not connect to the database. Please try again later.";
    exit;
    }
 
    mysql_select_db("registry_DB, $db);
    $sql = mysql_query("SELECT brideLname, groomLname FROM my_search_table WHERE brideLname LIKE '%". $lname ."%' OR groomLname LIKE '%". $lname ."%'") or die(mysql_error();//<--- LINE 21 (entire SQL statement is on one line
    $result = mysql_query($sql);
    $num_result = mysql_num_rows($result);
 
 
    echo "Number of matches: ". $num_result ."<br />";
 
@ $db = mysql_connect("localhost", "apache", "R3GP@SS!"); if(!$db) { echo "Error: Could not connect to the database. Please try again later."; exit; } mysql_select_db("registry_DB, $db); $sql = mysql_query("SELECT brideLname, groomLname FROM my_search_table WHERE brideLname LIKE '%". $lname ."%' OR groomLname LIKE '%". $lname ."%'") or die(mysql_error();//<--- LINE 21 (entire SQL statement is on one line $result = mysql_query($sql); $num_result = mysql_num_rows($result); echo "Number of matches: ". $num_result ."<br />";

you have no text box... how would you search and your html form?

hazel_0821

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Nov 2006

Permalink

Dec 2nd, 2006

Re: is there something wrong with my SQL statement?

The form may be on another page!

You can then use $_REQUEST['TBOXNAME']; to get the information.

phper

Reputation Points: 15

Solved Threads: 17

Junior Poster

Offline

189 posts
since Nov 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: view employee info for the employee selected from the drop down list

Next Thread in PHP Forum Timeline: Image link in an email from php

DaniWeb Message

Cancel Changes

User Name
Password