473,473 Members | 1,583 Online

Sign in
Join

Home Posts Topics Members FAQ

MYSQL Error when i try to execute

10 New Member

i have the following error when i trying to execute the page

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\test\ouraction.php on line 14

here's my
ouraction.php

Expand|Select|Wrap|Line Numbers

 
<?php

$host = "localhost"; 

$user = "root"; 

$pass = ""; 

$dbname = "univeristy"; 
 
$connection = mysql_connect("localhost","root","") or die (mysql_errno().": ".mysql_error()."<BR>"); 

mysql_select_db($dbname); 

//error_reporting(0);

$sql = "select * from hotel where name='" . $_POST['name'] . "' and myrtlebeacharea='" . $_POST['myrtlebeacharea'] . "'"; 

//echo $sql; 
 
$query = mysql_query($sql); 

while ($row = mysql_fetch_array($query)) { 

echo "<p>",$row['name'],": ",$row['myrtlebeacharea']; 

} 
 
?>

and this is my form

Expand|Select|Wrap|Line Numbers

 
<html> 

<head> 

<title>Search Hotels</title> 

</head> 

<body> 

<form name="form1" method="POST" action="ouraction.php"> 

<p> Hotel name: <input name="name" type="text" id="name"><p> 

<SELECT name="myrtlebeacharea"> 

<OPTION VALUE="ns">North Strand 

<OPTION VALUE="mb">Myrtle Beach 

<OPTION VALUE="ss">South Strand 

</SELECT> 

<SELECT name="city"> 

<OPTION VALUE="cherygrove">Cherry Grove 

<OPTION VALUE="northmb">North Myrtle Beach 

<OPTION VALUE="myrtlebeach">Myrtle Beach 

<OPTION VALUE="surfside">Surfside Beach 

<OPTION VALUE="gardencity">Garden City 

</SELECT> 

<p><input type="submit" name="submit" value="submit"> 

</form> 

</body> 

</html>

please help me what is the mistake i done.

Thanks in Advance

Nov 17 '07 #1

Subscribe Reply

1

1361

1,584

Recognized Expert Top Contributor

//echo $sql;
Hi,
uncomment this line and print the $sql variable. copy it and execute the query in your MySQL query window. is there any Error while executing?

Nov 17 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

PHP MySQL query not displaying data

by: jaysonsch | last post by:

Hello! I am having some problems with a database query that I am trying to do. I am trying to develop a way to search a database for an entry and then edit the existing values. Upon submit, the...

MySQL error from Python

by: Paul M | last post by:

I encountered the following error when trying to perform a SQL UPDATE to a MySQL database table from Python. I would apprciate any assistance. In the Python code I have tried integer and decimal...

MySQL tips that I have come across

by: Mike Chirico | last post by:

Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

by: jiing | last post by:

Now let me describe what I have done and my purpose: Originally, I want to user ports to install phpBB But I found that phpBB doesn't support mysql 5.x (but the ports installed mySQL 5.0.0...

A weird problem (adodb + mysql)

by: Daniel Crespo | last post by:

Hi to all, I'm using adodb for accessing mysql and postgres. My problem relies on the mysql access. Sometimes, when I try to execute a query (using ExecTrans method below), I get this error:...

Anyone running ISAPI and mysql succesfully?

by: ImOk | last post by:

I have the following setup: Windows XP Prof, IIS, PHP5 PHP5 works no problem with either PHP-CGI.EXE and mySQL, PHP5 also works no problem with php5isapi.dll as long as I dont use mySQL....

Deadlock found when trying to get lock (MySQL 5.0 with innodb)

by: cwho.work | last post by:

Hi! We are using apache ibatis with our MySQL 5.0 database (using innodb tables), in our web application running on Tomcat 5. Recently we started getting a number of errors relating to...

MySQL connect failure

by: Bruce A. Julseth | last post by:

I have the following code $Host = "localhost"; $User = "Fred"; $Database = "house"; $Password = "mypw" echo "before mysqli<br />Host: " . $Host . "<br />" . $User . "<br />" . $Database;

Uploading files into a MySQL database using PHP

by: Atli | last post by:

You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t. In situations where your PHP application...

MySQL to MS SQL Conversion

by: ssnaik84 | last post by:

Hi Guys, Last year I got a chance to work with R&D team, which was working on DB scripts conversion.. Though there is migration tool available, it converts only tables and constraints.. Rest of...

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap

Advertise on Bytes
How to Post and Respond on Bytes
How to Promote and Link on Bytes
How to increase your Ranking on Bytes
Become a Recognized Expert on Bytes
Feedback Welcomed! Contact Us