Recent content by TheDeaner

Great. Thanks for the help guys.

I used this code to have a PHP file email my cell phone and it worked. ------------------------ <?php mail("9999999999@mobile.att.net", "Header here", "More Text here"); ?> ------------------------ My question is does anyone know the code I would need to put into this mysql statement to get...

Bastien, The images are stores as URLs in the database. I can cycle thru the arrays, but I want to do it more than once. Thanks Dean

DRJ478, Let's say you had the list of all the presidents in a database with their date of birth and height. The first SQL Statement would ask for all presidents and list their names alphabetically so they show up on the left column on a webpage. The second SQL statement in the middle of the...

---------------------------------- $sql_statement = "SELECT id, price, title, date, FROM table where date = \"2004/12/7\""; $result = mysql_query($sql_statement) or die(mysql_error()); while($abc = mysql_fetch_array( $result )) { $id = $abcd[0]; $price = $abc[1]; $title = $abc[2]...

Doh. Good thinking. Sorry. Thanks for the help.

I want to loop through results with a while statement without having to do another SQL statement. Here is my example. ---------------------------------- $sql_statement = "SELECT id, price, title, date, FROM table where date = \"2004/12/7\""; $result = mysql_query($sql_statement) or...

I am not sure what I changed but now it is working. Thanks for taking the time to test this out for me. Dean

MYSQL version 4.0.21 for Windows Thanks Dean

Anyone that can help with this will be appreciated. I am using Navicat and setting up a simple database. I want currency to show up properly. Ex: 13.10 should show up 13.10 and not 13.1 I set up the column as decimal and decimals I set to 2. I have Zerofill clicked. But when I add a record or...

I have a basic question that I hope someone can help me with. I need to grab info from two different tables but don't know how. $sql_statement = "SELECT * FROM table1, table2 where table1.item_id = \"$ARG\" && table2.item_id = \"$ARG\""; $result = mysql_query($sql_statement) or...