472,354 Members | 1,718 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,354 software developers and data experts.

SQL Query Problem on Dynamic PHP Page (HELP!)

I'm having trouble with my SQL statement for a PHP/MYSQL page I am
creating. The search page is located at
http://dcavello.phenominet.com/alumn...umnisearch.php and the
results page at http://dcavello.phenominet.com/alumn...mniresults.php

Here is the code for the results page:

<?php require_once('../Connections/connAlumni.php');

mysql_select_db($database_connAlumni, $connAlumni);

$query = sprintf("SELECT s FROM tb_alumni WHERE %s LIKE
'%%%s%%'",$_POST['search'],$_POST['keyword']);

mysql_select_db($database_connAlumni, $connAlumni);
$rsAlumni = mysql_query($query, $connAlumni) or die(mysql_error());
$row_rsAlumni = mysql_fetch_assoc($rsAlumni);
$totalRows_rsAlumni = mysql_num_rows($rsAlumni);
?>

Can anyone direct me to where I might be going wrong? Thanks.
Ryan
--
To reply, please remove your robe.

Jul 19 '05 #1
0 938

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Ryan Sullivan | last post by:
I'm having trouble with my SQL statement for a PHP/MYSQL page I am creating. The search page is located at http://dcavello.phenominet.com/alumnidev/alumnisearch.php and the results page at...
5
by: Mark | last post by:
I'm interested in displaying a dynamic page title, rather than the static html <title>My Page</title>. In a previous posting, I had seen a suggestion of making the title into a server control...
3
by: vodafone | last post by:
Hy all I've a little problem. I need to write a dynamic page that render control according to validation status return from previous control validation status. To be clear, I've page that...
4
by: Chris | last post by:
Can anyone recommend how to do a screen scrape from a dynamic page and save it to a text file? Regards, Chris.
4
by: Ed Jay | last post by:
I generate a DHTML page (a medical report) with dynamically generated text based on user input (answers to questions). The page length changes dynamically. I desire that when the page is printed...
1
by: florencepushpa | last post by:
hi, i need to create a staic and dynamic page in html.pls give the code. Thank u Pushpa
5
by: ycquak | last post by:
Hi, Currently I need to read contents from a dynamic page, which goes something like: http://servername/filename.jsp?arg1=a&arg2=b The content is not static, neither is there a file for me to...
1
by: braich | last post by:
Hi All I am new to PHP and have been reading few basic books on PHP. I am trying to create a dynamic page based on the keyword in the url. Letís say I have...
6
by: RoomfulExpress | last post by:
Here's the problem that I'm having- I'm trying to pull in 2 fields from my database and place them in the title of the HTML. I'm connecting to the db and selecting everything exactly the same as I am...
0
by: vijay bharath | last post by:
how to take backup of database using java by query itself? please help
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
1
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. header("Location:".$urlback); Is this the right layout the...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
0
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.