Jump to content

Archived

This topic is now archived and is closed to further replies.

Nothadoth

WHERE this is this and this is this???

Recommended Posts

I know that you can use the clause WHERE this_field='$this'

However, is there a way you can use two WHEREs?

Can someone tell me how to do this?



Something like (it doesn't work i've tried it):

WHERE this_field='$this' AND this_other_field='$this2'



Thanks!

Share this post


Link to post
Share on other sites
well I am using this and it says that it isn't working.

[code]  $queryphones = mysql_query("SELECT * FROM phones WHERE manufacturer='$catmode' AND special='$type' ORDER by model ASC");
while($phones = mysql_fetch_array($queryphones)) {

}[/code]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/noth/public_html/igbltd/browse.php on line 313

http://www.finalfantasyfan.net/igbltd/browse.php?catmode=Sony%20Ericsson&parentmode=Phones&type=Walkmans

Please help

Share this post


Link to post
Share on other sites
Try adding an or die statement. Also, separating the query out will help so you can echo the query string:
  $sql = "SELECT * FROM phones WHERE manufacturer='$catmode' AND special='$type' ORDER by model ASC";
  $queryphones = mysql_query($sql) or die("mysql_error()<br />Sql:$sql");
while($phones = mysql_fetch_array($queryphones)) {

}

Share this post


Link to post
Share on other sites
<?php

session_start();

$database_host = "localhost";
$database_username = "";
$database_password = "";
$database_name = "";

$connection = mysql_connect($database_host, $database_username, $database_password) or die(mysql_error());
$db = mysql_select_db($database_name, $connection);

$catmode = "a";
$type = "a";

$queryphones = mysql_query("SELECT * FROM phones WHERE manufacturer='$catmode' AND special='$type' ORDER by model ASC");

while($phones = mysql_fetch_array($queryphones))
{
echo"$phones[manufacturer]";
}

?>

that works and echos out results...

Share this post


Link to post
Share on other sites
still not working.

Error:
[code]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/noth/public_html/igbltd/browse.php on line 319
[/code]

Ill give you the whole snippet from that area. It starts at line 286 and ends at line 300
[code]if ($type == "All") {
 
  $queryphones = mysql_query("SELECT * FROM phones WHERE manufacturer='$catmode' ORDER by model ASC");
 
  $temp1 == "";
 
} elseif (!$type == "All") {
 
  $temp1 == $type;
 
  $sql = "SELECT * FROM phones WHERE manufacturer='$catmode' AND special='$type' ORDER by model ASC";
  $queryphones = mysql_query($sql) or die("mysql_error()
Sql:$sql");
 
}[/code]

Share this post


Link to post
Share on other sites
Well i would guess the error is on the other query then
[code]
<?php
if ($type == "All") {
 
  $sql= "SELECT * FROM phones WHERE manufacturer='$catmode' ORDER by model ASC";
  $queryphones = mysql_query($sql) or die("mysql_error() Sql:$sql");
 
  $temp1 == "";
 
} elseif (!$type == "All") {
 
  $temp1 == $type;
 
  $sql = "SELECT * FROM phones WHERE manufacturer='$catmode' AND special='$type' ORDER by model ASC";
  $queryphones = mysql_query($sql) or die("mysql_error() Sql:$sql");
 
}
?>
[/code]

Share this post


Link to post
Share on other sites
I got it working. I used what GingerRobot said.

For some reason if I take out the elseif (!$type == "All") and change it to just else it works.

If I leave it as elseif (!$type == "All") then it shows nothing in the while loop.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.