MySQL query problem

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

When I try to run the following piece of code, I get this error:
QuoteWarning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/muskelmann098/public_html/build.php on line 37

Here is the area of the code where I think the problem is:
Code:
/*--36--*/ $b = "SELECT * FROM users WHERE town = '$town' AND username = '$name'";
/*--37--*/ $b_res = mysql_query($b,$conn)or die(mysql_error());
/*--38--*/ $barray = mysql_fetch_array($b_res)or die(mysql_error());
/*--39--*/ $blev = $barray["$building"];

I'm not really sure what is wrong with the SQL query as I'm using almost exactly the same syntax a few lines above. I hope someone here might see where I messed up.

Thanks

Other php-forum

list files from folder, only one for each date
I have many files in a folder and wish to only list one of each date

these are the file names

Find occurences of unicode characters in string
I need to prohibit filenames with everything but English characters and numbers but regexp and strin

Uploading Filetypes and placing them in seperate folders.
Hello,

first post , and asking for help im afraid. Very new to PHP, was making good progress

problem in pagination when processing with selectbox form
Hi,

I have a search form, with select boxes, if am selecting the value from the form, it work

Login Issue's
Code: <?php
$file = fopen('user.txt', 'r');

/* Set login to false initially */

Change Age automatically
hi guys . im new to php , is it possible to change age value in mysql automatically when year change

Database/Table Collation
What is the Database, and table collations used for? i don't understand what there used for since co

Must be a string? Huh, what? HELP?
with the following script, I get
Fatal error: Property name must be a string in /home/content/e/

how to remove in php string display
My code is

$message="We're looking at developing our website.";

$body= "

SWF image using php?
Hello once again.

My latest en devour requires me to produce an image of a static .swf that i