[[SOLVED] False value query...]

$info_location = "inf-bin/bil/$current.dat";
if(!file_exists($info_location)) { /* display fallback image */ }
else { /* do the other stuff */ }

[Preg_Match help]

echo $m[0];

[[SOLVED] php sql problem]

php 
ini_set ("display_errors", "1");
error_reporting(E_ALL);

$username = $_POST['username'];
$password = $_POST['password'];

$dbh=mysql_connect ("localhost", "username", "password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("database");
$query = "SELECT * FROM table WHERE username = '$username' and password = '$password'";
$result = mysql_query($query,$dbh) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
    $area = $row['area'];

 

$_GET is typically used for variables in a query string at the end of a page.  index.php?do=foo would assign $_GET['do'] = "foo";

[mssql select error php script help please]

I'm not braining very well today (I blame the weather), I meant consecutive queries.  If you don't append or die(mssql_get_last_message()) you could probably miss that message.  I read an article when I was first getting acclimated to MSSQL and it presented some really bizarre scenario that could make it not work.  I don't have the link anymore but I don't think it's anything to fret over either, lol.

[mssql select error php script help please]

Yeah, it sounds weird but in practice it works the same when used with die() or exit().  Only if you're doing concurrent queries will you introduce the possibility of it not displaying correctly and if that's going on you should probably rethink your code.

[[SOLVED] php sql problem]

your use of or die() doesn't make sense in this context.  It'll still return a result, only with 0 rows, if the query is built correctly.  But your query needs to look like this:

 

$query = "SELECT * FROM table WHERE username = '$username' and password = '$password'";
$result = mysql_query($query,$dbh) or die(mysql_error());

[mssql select error php script help please]

mssql_get_last_message() is no less reliable than mysql_error().  I've never had a problem with it.

[[SOLVED] Sessions & client names]

You wouldn't have to modify any code, it's simply a matter of convenience to have the username stored as a variable. It's not overwriting your 'priv' element.

[[SOLVED] PHP Help]

JavaScript is much more useful than PHP in this as you won't have to submit the page and then fool with variables and stuff.

 

See this for form validation.

 

Although you may be right, if javascript is turned off, anyone can submit anything to that page without having it validated.

 

More than likely, but I've had scant luck getting PHP to pop-up validation errors on-the-fly.

 

Either way, the OP needs to at least take a stab at making it work.

[[SOLVED] Being creative with scalars...]

Something tells me it has to do with your use of ch$count, PHP isn't gonna know what that is.  Perhaps ch.$count will work but I think you'll need to rethink your logic there.

 

Also you can use $PositiveFirstCriteria++ instead of += 1.  Same thing for $count.

[[SOLVED] PHP Help]

JavaScript is much more useful than PHP in this as you won't have to submit the page and then fool with variables and stuff.

 

See this for form validation.

[Arranging images into rows]

<?php
   include("config.inc.php");

$result = mysql_query("SELECT * FROM gallery_photos");
$i = 0;
While($row = mysql_fetch_array($result)){
if($i == 3) { echo "<br />"; $i = 0; } //change 3 to however many you want per row
echo "<a href='photos/" . $row['photo_filename'] . "'><img src='photos/tb_" . $row['photo_filename'] . "' border='1' /></a>"; 
$i++;
} 

?>

[[SOLVED] How to change date format with php?]

Take a look at date() and you should find the exact method of displaying that you want.

[selecting rows and ordering them based on numeric value]

$query = "SELECT Question, Answer, Number FROM table ORDER BY Number";

[[SOLVED] what's wrong with my mysql_query syntax?]

in other word

$query = mysql_query("SELECT * FROM fc_matches ORDER BY matchID DESC LIMIT 5") or die(mysql_error());

 

 

See my signature and let me know what happens.

I tried it and got

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'foo' at line 1

 

Well there's the problem obviously. 

[[SOLVED] what's wrong with my mysql_query syntax?]

See my signature and let me know what happens.

[HOW TO SHOW OTHER DATA WHEN A COUNTRY NAME IS SELECTED FROM A LIST BOX]

It sounds like you're going to need to select all the rates along with the country codes and use JavaScript to populate the text field with the correct data.  JavaScript ain't my thing so maybe someone else on here can get you going but it doesn't sound terribly difficult.

["SELECT DISTINCT" -- Sort Order]

Your php Freaks are really fast thanks you are great!!!

 

Could you indicate where at the end to put "Order By" please or simply modify my sample code for me I really would appreciate it. Sorry but I'm new to PHP and rely on guys like you for help. Really appreciate this!!!

 

Andy

 

ORDER BY should be the last statement in your query, after any WHEREs.

[Linking thumbnails to fullsize images.]

<?php
   include("config.inc.php");

$result = mysql_query("SELECT * FROM gallery_photos");
While($row = mysql_fetch_array($result)){
echo "<a href='photos/" . $row['photo_filename'] . "'><img src='photos/tb_" . $row['photo_filename'] . "' border='0' /></a><br />"; 
} 

?>

[[SOLVED] What it be a good idea to store the salt value in a table in your database?]

having a single salt in a configuration file

 

How would you do that?

What is a configuration file?

 

You're creating a physical PHP file that has the salt as a string.  You can then include() the file as necessary and make use of the salt that way.

 

So I could create a file called salt.php

and salt.php could be something as simple as $salt = "some value";

?

 

Absolutely.  Just make sure it's a PHP file and not plain text, so it gets processed instead of displayed to the web. (ie, salt.php and not salt.html)

[[SOLVED] What it be a good idea to store the salt value in a table in your database?]

having a single salt in a configuration file

 

How would you do that?

What is a configuration file?

 

You're creating a physical PHP file that has the salt as a string.  You can then include() the file as necessary and make use of the salt that way.

[[SOLVED] A Simple Search [needs improvement].]

With regards to quotes, you should add this line immediately after your else statement:

 

$keyword = mysql_real_escape_string($keyword);

[[SOLVED] What it be a good idea to store the salt value in a table in your database?]

Oddly enough vBulletin stores the unique salt for each user as well, but in it's own field as opposed to prepended to the password.  From a security standpoint I can't see how that's any safer than no salt at all.

[PLease Help with my error]

Right.  A good tip with mysql_error() is to look immediately before the error string it provides, which would be your comma.  Commas work in UPDATE statements across multiple fields but to qualify a search result you need to use WHERE artist='$cd_artist' AND title='$cd_title' AND...etc.

[PLease Help with my error]

Replace your query with this and rerun it and see where the error is.

 

$result = mysql_query("SELECT *  FROM tProducts WHERE artist='$cd_artist', title='$cd_title', genre='$cd_genre', year='$cd_year', type='$cd_type'") or die(mysql_error());

 

But, to the point, you need to replace your commas with the AND statement.