SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",
substr(I_NAME, INSTR(I_NAME,'O')+1) "Second part"
FROM Enrollment
WHERE I_NAME like '%O%';
2 3 4
I_NAME First part Second part
--------------------
LIOU LIO U
I am just not sure why it’s only pulling one name from the table.
please help me... my password gets encrypted but not able to get in database
hai guys, please help me... in the following function my password gets encrypted but not able to get in database.is any error in the query please help me...... <?php $email =
Passing JS to PHP
So I have the followingCode: <?phpgetdetails(?><script type="text/javascript">document.write(jsvariable)</script><?php );?>The idea is
OOP help
okay so i have a class im making it has everything setup i just need to randomize the 2 variables and return which variable that was randomized and output it.Code: <?phpclass hit_chance {
Inserting multiple records from single form
I've found a number of threads that deal with this issue, but I'm new to php and coding language so I don't quite understand what they're talking about or what the code means.Here's the situation: I
Can I use a loop
Hi buddies!
Please help with SMTP Authenticated PHP Email Form
Hello, I'm creating a PHP email form, and for this particular server, I have to use SMTP Authentication. They hosting service sent me this link: http://email.about.com/od/emailprogramm ...
upload control not working with update panel
Hi,I am working with Asp.Net FileUpload control with ajax update panel,if i use the AsyncPostBackTrigger,i am unable to get the filename in serverside,but if i use PostBackTrigger its working fine
How do I create a 2D game "camera" to follow player?
In J2ME programming I'm targeting MIDP 2.0 devices.I'm using gamecanvas and I was thinking that I could create my full world (640 x 480) using a TiledLayer and then set the refpixel of the TilerLayer
Edit MySQL Row Using PHP and HTML Form
Hello,Here's what I'm trying to do. Build a page where a user enters a MySQL row number in. Then, a new page appears with an HTML form where the user can edit the information in that row. Like for
Insert data in Mysql and move to another page
I'm stuck with this simple problem. I need to insert data in Mysql and then hit submit and move to another page. My first thougt was to use Post but that didn't work. How do I use Get and Post to do
