1,741 Posted Topics
 | |
| | |
| | |
| | [inlinecode]select orderid from bOrders where userid IN (select userid from email = 'John@abc.com');[/inlinecode] Thats wrong. You are missing where clause.. :) [inlinecode]select orderid from bOrders where userid IN (select userid from bUsers where email = 'John@abc.com');[/inlinecode] Cheers, Nav |
| | |
| | I agree with buddylee17. Without having a timestamp field or an autoincrement field, you can't make out which record was added last. Edit: you can make use of rowid (i think)  |
| | |
 | |
| | Simple. Use header("location: url"); Eg. [code=php] if($sent){ header("location: http://www.google.com"); } else { header("location: http://www.yahoo.com"); } [/code] |
| | |
| | |
| | |
| | |
 | |
| | Most people recommend Marco Tabini's [url=http://gocertify.com/0973862149/php&124;architect&39;s_Zend_PHP_5_Certification_Study_Guide.htm]Zend php5 certification study guide.[/url]. You need to know php inside-out to clear the test. (That's what I have heard!). Read that book atleast 5 times, solve practice tests and that will do it. All the best. Welcome to Daniweb, btw. |
| | [inlinecode] $checkboxvalue = $_POST['checkboxname'] [/inlinecode] is how you get the value of a checkbox. For example, if you have [inlinecode]<input type=checkbox name=checkbox value=10>[/inlinecode] in your form, on submitting, you access the value (only if the checkbox is checked) as,[inlinecode] $checkbox = $_POST['checkbox']; [/inlinecode] So, $checkbox has the value 10. Cheers, … |
| | |
| | [code] <?php // Have a button/link ("Send message") on the member profile. When clicked, it has to fetch the "email_address" of that member from the respective table. Assign it to $to_address. $to_address="address_of_the_recipient"; if(isset($_REQUEST['submit'])){ $subject=$_REQUEST['subject']; $message=$_REQUEST['message']; $headers = 'From: Naveen < >' . "\r\n"; mail($to_address, $subject, $message, $headers); echo "Message sent …  |
| | Well, check DocumentRoot in httpd.conf . Also check <Directory "path/of/your/files"> in the same file. I guess they aren't properly configured. |
| | |
| | |
| | |
| | |
| | Re: Access database Welcome! Post your question in [url=http://www.daniweb.com/forums/forum128.html]Ms-access forum. [/url]  |
| | What is the problem ? |
| | The query would be, [inlinecode] SELECT t1.username, t2.high_school FROM members as t1 JOIN high_schools as t2 ON t1.high_school_id = t2.id; [/inlinecode] |
 | |
| | Welcome to Daniweb! You are posting your question in wrong forum ! Please read the guidelines before posting your question. Cheers, Nav  |
| | |
| | yep. With $_POST, $_REQUEST and $_GET. You should escape all the special characters by using addslashes/mysql_real_escape_string. |
| | Simplest 'next-forward' script, just to get the idea on how it works. You will find much more efficient code on the net. [code=php] <?php $offset=isset($_REQUEST['offset'])?$_REQUEST['offset']:0; $conn=mysql_connect("localhost","root"); mysql_select_db("test"); $total=mysql_num_rows(mysql_query("select * from test")); $query="select * from test limit $offset,5"; $result=mysql_query($query); while($row=mysql_fetch_array($result,MYSQL_ASSOC)){ print_r($row); } if($offset==0){ $next_offset=$offset+1; $prev_offset=0; } elseif($offset == $total) { $next_offset=$total; … |
| | Well, thats because, the variable $result is empty or doesn't have a valid mysql resource. Try printing $result value. If it prints null(ie., if it doesn't print anything!), then you know where your problem is. Btw, Next time you post your question, please put your code within [c o d … |
| | |
 | Re: Hi To All Here Welcome! Post your question [url=http://www.daniweb.com/forums/forum17.html]here[/URL]. |
| | |
| | What do you mean by uploading a picture to a webpage ? You can either upload a picture to a database or save it in the filesystem, but not to a webpage! |
| | |
| | |
| | |
| | |
| | |
| | |
| | If you are populating the listbox from a table, just add the value of the textbox to that table. |
| | |
| | Do you have a webspace to host your site ? You can't make your site go 'live' without having a domain name and space. |
 | [QUOTE=<1337>Me</1337>;497847]Wow, sos that was horrible. |33t? It's 1337 dude. Pipe (|) is an I. And if you didn't know all the 1337 letters to that word, why didn't you just type leet? 0|-| /\/'/ 90|) 7|-|47 5|_|<|<5 73|-| |\||_|75 |=0|2 j00![/QUOTE] hmmm.. Now i m cursing myself for using two … |
| | If you are updating using php, you can use mysql_real_escape_string or addslashes to escape all the special characters like \, ' and ". |
| | Re: PHP Help Please Umm.. sending a mail is pretty straight forward in php. mail($to,$subject,$message,$from). You can include user defined text, form fields in $message. Instead of attaching a file, you can put your code in [ c o d e] tags. That would be much easier. btw, to send a mail, you should … |
| | [QUOTE=jbennet;496364]dont know. Iamthewee is a bit wierd sometimes, just ignore it[/QUOTE] ditto.  |
| | Re: hi everyone Hi.. I dont think someone will do your assignment unless you show us what you have done so far! |
The End.