woocha

hey guys, I am looking for a way to find out information about the referring site a user clicked through to get to my site. Is that possible and if so, How? Ideally, I am looking for: Site Domain Name The referral URL Meta information of the page I believe I can get this stuff from analytics software, but I am trying to think of a way to do it in my own script. Is it possible and does anyone have any ideas to point me in the right direction? thanks

Thanks to all ...IT WORKS GREAT !!

yes everything works great when I remover the description, size, and price lines but i need those attributes to describe the paintings in the gallery.

Hi Guys, I have a JS file for an AJAX app that works great in Firefox, Chrome, and Opera, but not in IE6 or IE7. The JS file is located here: http://www.russwilliamsart.com/scripts/imago.js and the XML file it grabs info from is right here: http://www.russwilliamsart.com/gallery/Giclees/gallery.xml I think the problem is in the JS file, but I can't seem to find the error, can someone please help me out. thanks,

AWESOME.....Thank you...That's great...I can't believe i didn't think of it.

Hi guys, I have a script that pulls info from a db and I need to determine if the db field contains ul for this I used: if(strstr($row['body'],ul)){} but now I need to know how to insert </p> before the ul is read from the db. I am doing this so that the page validates. I DO NOT want to alter the db field. I just want to change the string before it is displayed to the browser. Does anyone have any ideas? thanks guys and gals

OH DUH !! Thanks ...but other than that, you think this should be good for allowing users to login into and register to my site.....STRICTLY SPEAKING ABOUT SQL INJECTION, no other validations

<?php function sanitize($value) { if(get_magic_quotes_gpc()) { $value = stripslashes($value); } else { $value = $value; } mysql_real_escape_string($value); return $value; }?> Its something I slapped together....do you guys think it makes good sense as a function?

SWEET !! That worked like a charm...I thank you for the tip. Your post squared it away for me. Thank you

Hey Thank you for the quick reply... The code I was trying is: $query = "SELECT instock FROM inventory where instock < 1 and products.item_number = inventory.id"; That is very similar to what you suggested, but mine did not work. Can you see anything I might try differently?

Hey Guys... I am trying to do a simple SQL query on 1 Database but from 2 seperate tables. I have one table 'products' with an int id auto increment and I have another table 'items' with an int product_id . What I want to do is, make a one line SQL query that will grab any results where product_id {from table 1} = id{from table 2} Anyone have any experience with this? Thanks guys

LIKE and Wildcard % awesome...that is just what I was looking for guys. Thanks

Thanks guys, but I am more worried about the SQL query...I mean If I use substr to finms the first letter of the name, how to I write the SQL to search all usernames that begin with that substring? Is there an SQL function like $query = "SELECT username FROM users WHERE username starts with a"; ? I know it looks stupid, but is there anything like that?

Hi Guys.. I need to read all of the rows from a MySQL table and return only the results that start with a user input letter. So like if the user types in Andrew. I want the database to return all rows that have usernames beginning with the letter a. Has anyone ever done anything like this before? Thanks

thanks guys...I'll give it a shot

if anyone else is looking to do something similar to this you might want to avoid trying to use an array(I COULDN'T FIGURE IT OUT). You might think about using this instead: keep the string as a string and search the string for the answer

I test this with $answer = trim($answer); but that didn't work. I think you might be on to something though. The values that don't work seem to be the first and the last values of the array. Strange!

Logically, I am pretty damn sure this should work, buy it isn't. I am building a text file db driven 'are you human' test. The test is of questions and answers. To validate the answers, I am using the built in php in_array function. Here is my code and I hope you guys can help me out: <?php if(isset($_POST['submit'])) { $fp = fopen('questions.php','r'); $answer = $_POST['answer']; $field2 = $_POST['array']; echo $answer.'<br />'; echo $field2.'<br />'; $array = split ('-', $field2); print_r($array); echo '<br />'; echo $answer.'<br />'; if (in_array($answer,$array)) { echo 'passed'; } else { echo 'failed'; } } else{ $file = 'questions.php'; $lines = count(file($file)); $number = rand(1,$lines); if (($number > 0) and ($number < $lines)) { $fp = fopen('questions.php','r'); if (!$fp) {exit('ERROR! Unable to open questions database.');} $count = 0; while ($count != $number) { $count++; $line = fgets($fp, 1024); $fp++; } fclose($fp); list ($field1, $field2) = split ('\|', $line); } if(!$field1){header ('Location: flat-test.php');} ?> <h1>Are You Human Test</h1> <form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post"> <label><?php echo $field1; ?></label> <input name="answer" /> <input type="hidden" name="array" value="<?php echo $field2; ?>"> <input name="submit" type="submit" value="SHOW" /> </form> <?php } ?> My text file is: Are you human? | yes-no-sure Are you human-2? | bob-weave-stab The script seems to work some times but not all the time. Can anyone see what I am doing wrong?

What would this do? Because x!=y, it would update all of the rows? Is it safer to do it that way?

I want to query my db table that has 325 rows of data. thats 325 users. Each users 'members' level is defaulted to 3 and some of them have changed. I wand to know if it is possible to update all 325 users to the default number 3 using a php script

Hey Guys, I am not sure if this is possible or not, but am trying to update my MySQL db so that every row of one field is restored to its default vaue. If this is not possible, I would like to set the fields equal to a value. has anyone done this before, or does anyone know how to do this? Thanks guys

Hi Guys... I ran into a problem today. I am designing a new site and my background image is show in my style sheet. I need to know if I can throw php in a .css file to execute a php random image function. The idea is to display a new image at random on a refresh or new visit. So can I do this, or does anyone know of a different or maybe better way? Thanks Guys