whats wrong with my code please help!!!

Posted on 16th Feb 2014 07:03 pm by admin

this is the error


Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /var/www/IpSearch.php on line


Code: [Select]<?php

$srch = $_REQUEST["srch"];

if (empty($srch)) {
print <<<HERE
<form>
Type the Store location:
<input type = "text"
name = "srch">
<input type = "submit">
</form>
HERE;

} else {

$con = mysql_connect("localhost","root","icebird");

if (!$con) {
die('Could not connect: ' . mysql_error());
}

mysql_select_db("IpPhoneDir", $con);

// Send a query to the server
if ($result = mysql_query($con, "call GetBranchBeg($srch)")) {

$um_rows = mysql_num_rows($result);
if($num_rows <= 0) {
echo "no match found";
}
print "<table border = 1>n";

//get row data as an associative array
While ($row = mysql_fetch_assoc($result)) {
print "<tr>n";
//look at each field
foreach ($row as $col=>$val){
print "<td>$val</td>n";
}//end foreach
print "</tr>nn";
}//end while-
print "</table>n";

} else {
trigger_error(mysql_error(),E_USER_WARNING); //this will display MySQL's error message
}
}
mysql_close($con)


?>



Code: [Select]DROP PROCEDURE `GetBranchBeg`//
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetBranchBeg`(IN starts_with CHAR(15))
BEGIN
DECLARE tmp CHAR(15);
SET tmp = CONCAT(starts_with, '%');
SELECT IpPhoneNo, location FROM IpPhoneList WHERE location LIKE tmp OR location =starts_with;
END

Your Answer:

Login to answer

Other forums

Last character removed
I have created a string from an array. I have inserted commas from my form values. I am trying to re

Motivational Posters
Hello,

I wonder how can i do them in php. Are there any sample codes that you can show me?

Cursor statement failed with errors
Following statement failed with the errors.

cursor proj_cursor1 is (select projectID from

php web service error
hey guys,
I'm working on a project requires the use of web services. I've been trying a few tutor

mails going in spam??
The mails I sent to folks in my database using mail(function) are going in spam??

Any idea ho

Storing user data help?
Hey Guys,

I'm not use if this question is to broad but I can always give you more informatio

simple ping code
been searchin the site/web and found code thats simple but doesnt work.

I have a personal we

small inaccuracies
I have this code to convert fractional base 10 into base 2:

while($num > 0)

How to have a log of all the status a VIM document had been ?
Hi guys,

I’m using SAP Invoice Management plugin and the /OPT/VIM_ANALYTICS transa

Printing a webpage
I use this to print the webpage: o